Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SYNTAX ERROR on TableUpdate
Message
From
01/03/2000 20:21:11
Jill Derickson
Software Specialties
Saipan, CNMI
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SYNTAX ERROR on TableUpdate
Miscellaneous
Thread ID:
00340313
Message ID:
00340313
Views:
59
I am updating a single record in a table, Group, with a view, ModifyGroup. Probably a bad choice of table name, but it's inherited...could this be causing the problem?

MOST of the time the TableUpdate works...

In a certain case, after the table is updated, I want to revert to a previously saved state of the table. I REPLACE fields of the view with the previous values and when I do a TableUpdate, it fails...and AERROR() tells me: Syntax Error.

Any help on ideas about what could be causing this, or a solution? TIA, J
Next
Reply
Map
View

Click here to load this message in the networking platform