Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Preserving data if not NULL
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01156159
Message ID:
01156229
Views:
20
Looks like I'm alone with this problem. :)

Anyway, I think the simplest solution would be to write each replace independantly (e.g. if isnull(Trans.field) and not isnull(cursor.field) replace...)

If I would have lots of fields I may save the record with scatter name, then do replace, then compare saved and new and if they are the same, revert changes...
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform