Home » U++ Library support » U++ Widgets - General questions or Mixed problems » Executing a SQL statment containning a ' ?
| Executing a SQL statment containning a ' ? [message #31160] |
Thu, 10 February 2011 21:00  |
kbyte
Messages: 87
Registered: July 2008
|
Member |
|
|
Hi
I am reading edit contents in order to format a SQL statment to insert it in a SQLite database. Everything is fine until an edit control have a '. this character will of course causing conflits with the field delimiters of the sql statment and the insert into operation fails.
Any "clever" way to handle this?
Thanks
Kim
|
|
|
|
| Re: Executing a SQL statment containning a ' ? [message #31162 is a reply to message #31160] |
Fri, 11 February 2011 05:38  |
Novo
Messages: 1371
Registered: December 2006
|
Ultimate Contributor |
|
|
| kbyte wrote on Thu, 10 February 2011 15:00 |
Hi
I am reading edit contents in order to format a SQL statment to insert it in a SQLite database. Everything is fine until an edit control have a '. this character will of course causing conflits with the field delimiters of the sql statment and the insert into operation fails.
Any "clever" way to handle this?
Thanks
Kim
|
You could try to use Sql::SetParam() to pass a string value.
Regards,
Novo
|
|
|
|
Goto Forum:
Current Time: Sun Nov 10 20:23:32 CET 2024
Total time taken to generate the page: 0.00910 seconds
|
Members
Pages
Help
Register
Login
Home
