<div>
Try doubling the single quote. &nbsp;As far as I know, in normal SQL statements (not under vc5.0/ODBC) thats how you escape the single quote. &nbsp;I've done it before under different development platforms.<br />

</div>


Try doubling the single quote.  As far as I know, in normal SQL statements (not under vc5.0/ODBC) thats how you escape the single quote.  I've done it before under different development platforms.


<div>
Well <br />
it works when I double it!! Thanks &nbsp;a lot to \0 and &nbsp;seanowens.<br />

</div>


Well
it works when I double it!! Thanks  a lot to \0 and  seanowens.


<div>
<div class="content wysiwyg-content">
Hi experts,<br />
I'm looking for the syntax of the sqlstatments that have a ' in the data.<br />
My table has a Entry in Hive like this : [ULM\Dr.Salomon's]<br />
my SQL-statments : SELECT * FROM RegistryEntry WHERE Hive = '[ULM\Dr.Salomon's]';<br />
<br />
but the problem is the ' in Dr.Salomon's<br />
what the solution ?<br />
Thanks<br />
jufer
</div>
</div>


Hi experts,
I'm looking for the syntax of the sqlstatments that have a ' in the data.
My table has a Entry in Hive like this : [ULM\Dr.Salomon's]
my SQL-statments : SELECT * FROM RegistryEntry WHERE Hive = '[ULM\Dr.Salomon's]';

but the problem is the ' in Dr.Salomon's
what the solution ?
Thanks
jufer

SQL Problems on VC5.0 with ODBC

C++ is an intermediate-level general-purpose programming language, not to be confused with C or C#. It was developed as a set of extensions to the C programming language to improve type-safety and add support for automatic resource management, object-orientation, generic programming, and exception handling, among other features.