|
| Inicio → WINDEV 2024 → HFSQL-How to have in a triggerProcedure the Old- AND the New-Value of a Field in a Modfiy-Action? |
| HFSQL-How to have in a triggerProcedure the Old- AND the New-Value of a Field in a Modfiy-Action? |
| Iniciado por meikl, 31,ago. 2016 15:15 - 4 respuestas |
| |
| | | |
|
| |
Miembro registrado
127 mensajes |
|
| Publicado el 31,agosto 2016 - 15:15 |
as subject
thanks
meikl  |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
127 mensajes |
|
| Publicado el 06,septiembre 2016 - 10:33 |
seems that I fail to take for granted 
any suggestions to that theme are welcome |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
127 mensajes |
|
| Publicado el 06,septiembre 2016 - 10:34 |
seems that I fail to take for granted
any suggestions are welcome |
| |
| |
| | | |
|
| | |
| |
| Publicado el 06,septiembre 2016 - 13:59 |
Hi Michael
You can do the following:
- use halias to declare an alias on the processed file
- hreadseek on the halias to read the record from disk (before state)
- you can then compare to the current state, in the file buffer
If you want an example of that, I'm using that in WXReplication, in
order to replicate only modified fields.
Best regards
--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting
Ready for you: WXShowroom.com, WXReplication (open source) and now WXEDM
(open source)
More information on http://www.fabriceharari.com
Le 9/6/2016 à 2:34 AM, Michael KRETZSCHMAR a écrit :
seems that I fail to take for granted any suggestions are welcome |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
127 mensajes |
|
| Publicado el 07,septiembre 2016 - 08:51 |
Hi Fabrice,
thanks for the hint will try myself first, if i struggle, i will be back
thanks
meikl |
| |
| |
| | | |
|
| | | | |
| | |
|