Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SYNTAX ERROR on TableUpdate
Message
From
02/03/2000 00:09:26
 
 
To
01/03/2000 20:21:11
Jill Derickson
Software Specialties
Saipan, CNMI
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00340313
Message ID:
00340426
Views:
23
That could be. Here's what you do: Edit the SQL code that creates the view and put quotes around the table name. IE:

SELECT * FROM "group"

This might alleviate the problem.


>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
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform