Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Syntax Error Modifying Remote View
Message
From
13/07/2001 10:44:18
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
13/07/2001 10:27:19
Steven Herbin
SNH Computing Corporation
Swan Lake, New York, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00530237
Message ID:
00530249
Views:
15
Check if you don't happen to have fields with reserved names. For instance, once I had a field called "Value", which caused me hard-to-debug errors.

Hilmar.

>I'm trying to modify a remote view generated using an ODBC driver called "LinkBook." This driver allows access to QuickBooks tables.
>
>I can create my remote views and then browse the results. However, when I try to modify the view, as soon as I click on the modify button, I get a syntax error without any clue as to what the error is or where it is.
>
>Does anyone have a clue as to where to start hunting this one down?
>
>BTW, the LinkBook driver is seemingly a work in progress as far as VFP is concerned although the vendor seems to have it working well in Access. The vendor support has been absolutely fabulous with other problems encountered.
>
>Thanks in advance.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform