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 10:58:59
 
 
À
16/12/1997 08:11:52
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00065880
Message ID:
00066236
Vues:
30
>>>>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

Bummer, back to the drawing board! Thanks for taking the time to investigate :-)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform