Information générale
Catégorie:
Codage, syntaxe et commandes
I don't know how this will work from a trigger, but I copy the record to
an array
then when you open the form, you INSERT into table from array and then
REPLACE the fields with the current information.
Hope this helps, have a good day.
>Because I cannot use:
>on Update/Delete Trigger, For reasonable audit log to prevent
>mis-use or mal-use, usually copy current record to another hided table
>With 2 additional fields, DateTime and UserName
>So, I create a kMover.prg and add simple kMover(Mytable) on
>trigger and the following is the Coding but....
>
>* kMover.Prg
>LParameter oTable
>LOCAL nRecno, auditTable
>
>Select &oTable
>nRecno = RECNO()
>auditTable = "k" + '&oTable'
>select &auditTable
>APPEND FROM &oTable FOR RECNO() = nRECNO
>* The last line cause error as the cursor try to move around!!
>So, What Can I do...
>
>How to copy current Recno to new table in Trigger??
>if use: APPEND FROM &oTABLE
>all data in &oTAble will copy to new table...
>but how to make the 'For' condition available on current recno???
>Or any alternative method to do so?!
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement