Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error Message # 1886
Message
 
 
To
13/06/2005 08:32:51
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 98
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01022718
Message ID:
01024536
Views:
30
I had something similiar happen.
Try replacing all the OLDVAL( "field", "table")
with NVL( OLDVAL( "field", "table"), 0 ).
Substitute an empty field value for 0, if the field is not numeric.

Just a guess is that during the SQL, FoxPro create a temporary index.
And THAT does not accept NULLs.
- Andy Rice
San Diego, CA
Previous
Reply
Map
View

Click here to load this message in the networking platform