Hello,Nando!

Courier?!!! Only Bookman! ;))))

One of solution is:
with MyQuery do
begin
close; sql.clear;
sql.text:='update mytable set myfield=?NewValue where id=?IdValue';
Prepare;
ParamValues['NewValue']:='What you need here';
{ or '''' + 'What you need here'+'''' - single quote}
{ or ' " '+'What you need here'+' " ' - double quote }
{ or ' """""" '+ 'What you need here'+' """""' ' - many quotes ;))))))) }
ParamValues['IdValue'] :=YouIdValue;
Execute;
{.. etc ..}
end;

AFAIK parameters is better ;)

WBR, Dmitry Beloshistov AKA [-=BDS=-]

----- Original Message -----
From: Nando Dessena
To: IBObjects@yahoogroups.com
Sent: Tuesday, December 09, 2003 8:44 AM
Subject: Re: [IBO] Re: TIB_Query Programatically Defined SQL with Strings


Jason,

J> It can be hard to tell these apart:

J> One double quote: "
J> Two single quotes: ''

J> Unless you have a really good eye, or you simply attempt to edit it... you
J> won't know for sure.

Courier New? I cannot believe there's still people looking at source code in
the Arial font. :-)

Ciao
--
Nando mailto:nandod@...


Yahoo! Groups Sponsor
ADVERTISEMENT




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]