"GTi" <nospam@online.com> wrote in message
news:XLOSb.2125$O41.75140@amstwist00...

> The solution is to make sure you never have a single '-character in your
> text string. You need to replace it with two single qoute characters
instead
> (not a double qoute character), because this will then be interpreted as
the
> text representation of the single qoute instead if the end of string
> character.
>
> Some examples:
> Text is
> Test on 'data' field
> replace with
> Test on ''data'' field
>
> resulting query
> SELECT Name, phone FROM PersonTable WHERE info='Test on ''data''
field'
>
> Text is
> This is my 'data'
> replace with
> This is my ''data''
>
> resulting query
> SELECT Name, phone FROM PersonTable WHERE info='This is my ''data'''
>
>
> Note the existens of three single qoute characters in the second example.
> This means that the first two are represting the single qoute character
> string and the last one means end of text string.
>
>
> Regards,
> Johan
>
>
> "GTi" <nospam@online.com> wrote in message
> news:XLOSb.2125$O41.75140@amstwist00...
> ODBC Beginner
>
> Normal I use:
> sprintf(qu,"SELECT Name, phone FROM PersonTable WHERE info='%s'",sText);
> SQLExecDirect(hstmt1,qu,SQL_NTS);
>
> This works fine, except when the sText is:
> Test on 'data' field
> Then I have the ' in the string.
> What else can I use - SQLPrepare?.
> Please give me some samples of using this in SQLPrepare.
>
>
>

"GTi" <nospam@online.com> wrote in message
news:dS5Tb.2275$O41.74861@amstwist00...

> The solution is to make sure you never have a single '-character in your
> text string. You need to replace it with two single qoute characters
instead
> (not a double qoute character), because this will then be interpreted as
the
> text representation of the single qoute instead if the end of string
> character.
>
> Some examples:
> Text is
> Test on 'data' field
> replace with
> Test on ''data'' field
>
> resulting query
> SELECT Name, phone FROM PersonTable WHERE info='Test on ''data''
field'
>
> Text is
> This is my 'data'
> replace with
> This is my ''data''
>
> resulting query
> SELECT Name, phone FROM PersonTable WHERE info='This is my ''data'''
>
>
> Note the existens of three single qoute characters in the second example.
> This means that the first two are represting the single qoute character
> string and the last one means end of text string.
>
>
> Regards,
> Johan