RealTimeUpdate()
RealTimeUpdate(family
,column
,value
,columnUpdate
,valueUpdate
)
columnUpdate
with the value
valueUpdate
in the record matching
family
, column
and
value
.; As in our RealTime() example, we can update the record like so: exten => 123,1,RealTimeUpdate(sipusers,ext,5678,firstname,Richard) ; resulting SQL command: ; UPDATE sip_users SET firstname = 'Richard' WHERE ext = '5678'
-= Info about application 'RealTimeUpdate' =- [Synopsis] Realtime Data Rewrite [Description] Use the RealTime config handler system to update a value RealTimeUpdate(<family>|<colmatch>|<value>|<newcol>|<newval>) The column <newcol> in 'family' matching column <colmatch>=<value> will be updated to <newval>. REALTIMECOUNT will be set with the number of rows updated or -1 if an error occurs.
11,13c11 < The column <newcol> in 'family' matching column <colmatch>=<value> will be < updated to <newval>. REALTIMECOUNT will be set with the number of rows < updated or -1 if an error occurs. --- > The column <newcol> in 'family' matching column <colmatch>=<value> will be updated to <newval>
RealTime()
”