Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO Recordset Find Limitation?
Message
From
15/08/2000 14:29:15
 
 
To
15/08/2000 13:00:39
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00405064
Message ID:
00405126
Views:
18
>Hello all ADO/VB gurus,
>
>I'm having trouble getting the ADO.Recordset.Find method to work when the value for the criteria has an embedded single quote.
>

I don't know if it works in ADO, but in SQL Server, you have to use a double single-quote, e.g.,
Instead of "Dave's Art and Pawn"
It would have to be "Dave''s Art and Pawn"
You might try that and see if that works.
Insanity: Doing the same thing over and over and expecting different results.
Previous
Reply
Map
View

Click here to load this message in the networking platform