Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL syntax problems w/ OLEDB provider?
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
00839308
Message ID:
00839543
Views:
22
Thank you Paul.

What do you mean by "escaping out of the quotes"? Be gentle. c# is not my native computer langauge.

Neil

>> // use the full path to the table because there is no dbc
>> 1)//return this.GetDataSet("SELECT * From c:\\gmgwin\\main\\arypat01.dbf WHERE custid = '" + tccustid + "'");
>
>Just a quick guess, but try escaping out the single quotes:
>
>
>return this.GetDataSet("SELECT * From c:\\gmgwin\\main\\arypat01.dbf WHERE custid = \'" + tccustid + "\'");
>
Previous
Reply
Map
View

Click here to load this message in the networking platform