Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote Views
Message
 
To
27/09/2004 12:27:26
Jim Rieck
Quicken Loans/Rock Financial/Title Sourc
Livonia, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00946321
Message ID:
00946325
Views:
32
>All,
>
> I have an application that will be accessing a remote database. One of the fields has the name "desc". When I create a remote view in VFP 7 and browse the data I recieve the following error message: Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server] Incorrect syntax near the keyword 'desc'. What work arounds are there for this bug?

what does the select statement for the remote view look like?
There is also the possibility that since 'desc' is a reserved word it might be causing a problem.
ICQ 10556 (ya), 254117
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform