Information générale
Catégorie:
Codage, syntaxe et commandes
>>>I'm using oldval() to check record updates for buffered data. Works ok for all except General fields. What is an alternative for comparing general fields for changes?
>>
>>hi Jim,
>>
>>If you wanna recognize only if the field was or wasn't changed,
>>you can use a function GETFLDSTATE(). See FoxPro help for
>>more informations.
>>
>>Peter
>
>Thanks Peter. I don't think I was clear enough in my question however. I am using GETFLDSTATE() to check for field modifications within the record. When I determine that my field has changed I need to save the OLDVAL() version to an audit table as well as the current buffered value. This works fine for all fields except General fields. I get the error "Operation is invalid for a general field".
>
>In my case these general fields will always contain graphics. Also, they will always be embedded and not linked data. What method can I use to save the original value of the bitmap to my audit log?
>
>Thanks
I see. So Foxpro help says, that Oldval() function returns a value. A general filed is a special
case and the value of its can not be returned by a function (I guess :-). That's why the general
fields are not supported by Oldval() and Curval() functions.
Supported types are Character, Currency, Date, DateTime, Double, Float,
Integer, Logical, Numeric, and Memo.
I think, you will have to use some other technique to save old values of general fileds.
Peter
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