Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
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 Go to next message
kbyte is currently offline  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 Go to previous message
Novo is currently offline  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
Previous Topic: Menu problem on windows
Next Topic: Focus without selecion
Goto Forum:
  


Current Time: Sat Jul 20 05:00:47 CEST 2024

Total time taken to generate the page: 0.01440 seconds