Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Key in apostrophe
Message
 
 
To
15/09/2004 20:32:15
Yh Yau
Ingenuity Microsystems Sdn Bhd
Kuala Lumpur, Malaysia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00942689
Message ID:
00942703
Views:
17
>VFP6 SP5. Using sqlexec() to insert records into SQL server database. How to allow "'" or quotes to be entered?
>The syntax use is :-
>lcsqlstring = "Something with ' "

You've to double single quotes inside a string literal.
lcsqlstring = [INSERT INTO mytable VALUES('O''Mally')]
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform