I am filling SQL dinamically and I need to place some string constants in
it. How do I do that? In v2.12 I used "XX" but in ver4.25 " " are not
allowed any more?!
please, advise

Query.SQL.Add(' where p.dokument = "VH" ');

Andrej,

> I am filling SQL dinamically and I need to place some string constants in
> it. How do I do that? In v2.12 I used "XX" but in ver4.25 " " are not
> allowed any more?!
> please, advise

You use single quotes. Also, see the Engine.QuotedSQLString function in
the help file.

Eryk

But I need "quotes inside quotes".
Query.SQL.Add(' where p.dokument = "VH" ');



"Eryk Bottomley" <no@way.com> wrote in message
news:F50E6CD1-FB0B-4241-81C2-33E0D6807CEC@news.elevatesoft.com...
> Andrej,
>
>> I am filling SQL dinamically and I need to place some string constants in
>> it. How do I do that? In v2.12 I used "XX" but in ver4.25 " " are not
>> allowed any more?!
>> please, advise
>
> You use single quotes. Also, see the Engine.QuotedSQLString function in
> the help file.
>
> Eryk

"Andrej Bivic" <andrej.bivic@abitrade.si> wrote in message
news:34FB9FCA-6CED-47DE-AB18-E4A4FAFA2197@news.elevatesoft.com...
> But I need "quotes inside quotes".
> Query.SQL.Add(' where p.dokument = "VH" ');
>

The double quote is decimal 34

select * from table where field = #34 + 'AB' + #34

Robert

>
>
> "Eryk Bottomley" <no@way.com> wrote in message
> news:F50E6CD1-FB0B-4241-81C2-33E0D6807CEC@news.elevatesoft.com...
>> Andrej,
>>
>>> I am filling SQL dinamically and I need to place some string constants
>>> in it. How do I do that? In v2.12 I used "XX" but in ver4.25 " " are not
>>> allowed any more?!
>>> please, advise
>>
>> You use single quotes. Also, see the Engine.QuotedSQLString function in
>> the help file.
>>
>> Eryk
>
>

Andrej,

> But I need "quotes inside quotes".
> Query.SQL.Add(' where p.dokument = "VH" ');

Yes, I know - so you double up the quotes as in any other case of string
handling in Pascal: SQL.Add(' where p.dokument = ''VH'' ')

....this is also what the QuotedSQLString function does automatically.

Eryk

Robert,

> The double quote is decimal 34
>
> select * from table where field = #34 + 'AB' + #34

That would only help if you had a column called 'AB' (including quotes)
....which I doubt is the case here (or anywhere else where sanity
prevails .

Eryk

If I put

where p.dokument = "VH"  in dbSys

I get an error (see the attachment).

I was used  to (ver2.12) use statements like
Query.SQL.Add(' where p.dokument = "VH" ');

where "VH" is a string constant. But in ver4.25 it doesnt work. Please,
advise, how do I form such SQL statemest dinamically, which contains string
constants.

Andrej



"Eryk Bottomley" <no@way.com> wrote in message
news:4EB9FBFF-AC2E-46C7-80AF-A9C832DB246E@news.elevatesoft.com...
> Andrej,
>
>> But I need "quotes inside quotes".
>> Query.SQL.Add(' where p.dokument = "VH" ');
>
> Yes, I know - so you double up the quotes as in any other case of string
> handling in Pascal: SQL.Add(' where p.dokument = ''VH'' ')
>
> ...this is also what the QuotedSQLString function does automatically.
>
> Eryk

Andrej,

> where p.dokument = "VH"  in dbSys
>
> I get an error (see the attachment).

Yes, because there is no field called "VH" in the table. Double quote
characters ($34) denote quoted identifiers ...which in practice usually
means means field names in SQL. You use a quoted identifier when you
want to write something like: ...JOIN Table2 r ON p.dokument = r."spaces
in this field name".

> where "VH" is a string constant. But in ver4.25 it doesnt work. Please,
> advise, how do I form such SQL statemest dinamically, which contains string
> constants.

You use single quotes ($39): WHERE p.dokument = 'VH'. If you want to
embed that in Pascal code you have to double the single quotes:
SQL.Add('WHERE p.dokument = ''VH''') ...the latter is standard behaviour
for Pascal string handling and has nothing to do with databases per se.

Note that: WHERE p.document = "VH" is: $34VH$34

....this is NOT the same as:

WHERE p.dokument = ''VH'' which is $39$39VH$39$39

Eryk

Andrej,

<< I am filling SQL dinamically and I need to place some string constants in
it. How do I do that? In v2.12 I used "XX" but in ver4.25 " " are not
allowed any more?!>>

As Eryk indicated, you need to use single quotes:

Query.SQL.Add(' where p.dokument = ''VH'' ');  // doubled-up single quotes
around VH constant

You can also just use this:

Query.SQL.Add(' where p.dokument = '+Engine.QuotedSQLStr('VH')+' ');

--
Tim Young
Elevate Software
www.elevatesoft.com