Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need an alternative for using oldval() on general fields
Message
From
16/12/1997 08:11:52
 
 
To
15/12/1997 11:43:46
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00065880
Message ID:
00066168
Views:
32
>>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform