Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View TABLEUPDATE() not saved albeit no error returned
Message
 
 
To
05/11/2004 14:06:46
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP3
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00958637
Message ID:
00958653
Views:
18
>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

What does aError() return. Also see if thread #949319 is at any help.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform