Use Params:

Imagine that your SQL is something like...
MyIBOQuery.SQL := 'SELECT * FROM TEST WHERE A=:Var1 AND B=:Var2

you must use something like:

with MyIboQuery do
begin
Prepare;
Params[0].Value := '12345';
Params[1].Value := 24;
Open;
...

The order of Params[...] is the same of the order of the SQL Statment.

Artur

----- Original Message -----
From: rod@...
To: IBObjects@yahoogroups.com
Sent: Tuesday, August 14, 2001 11:27 AM
Subject: [IBO]


How can I place a variable in a SQL query in a TIBOQuery.SQL property. Or
do I have to format a string every time and set it in the property. Any
better methods ?





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



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