Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need an alternative for using oldval() on general fields
Message
De
16/12/1997 08:11:52
 
 
À
15/12/1997 11:43:46
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00065880
Message ID:
00066168
Vues:
31
>>>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
Fil
Voir

Click here to load this message in the networking platform