Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View TABLEUPDATE() not saved albeit no error returned
Message
From
05/11/2004 14:06:46
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
View TABLEUPDATE() not saved albeit no error returned
Environment versions
Visual FoxPro:
VFP 6 SP3
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00958637
Message ID:
00958637
Views:
48
This is really strange that happens only to ONE form/view in the whole application:

TableUpdate(.T.,.T.,'cmrtaview') from the form in the Project Manager (with the path to production server) would return .T. as successful, however, in the executable file, it doesn't save changes, TableUpdate returns .F. with NO error message. I try to capture it but the error array always returns -1. This is baffling because everything is exactly the same between Project Manager, path setting, etc... and the executable file. All other forms have no problems. I cannot debug from inside the executable.

Free Table CMRTA (we don't use DBC, it's too slow)
View CMRTAVIEW which is set as included in Project Manager and Executable
Form is in optimistic buffering mode
View is set as '5' in Form
View has 'Send SQL Updates' marked, SQL WHERE key fields only, SQL UPDATE

I've spent two days trying to figure out what the problem is. I'm at my wits end. Please help... TIA
Thanks!
~d
J
Next
Reply
Map
View

Click here to load this message in the networking platform