Don't forget the QuotedStr() function. It takes most of the hassle out of it.

Helen


At 10:05 AM 9/12/2003 +0200, you wrote:

>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]
>
>
>
>___________________________________________________________________________
>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 http://docs.yahoo.com/info/terms/