🚀 go-pugleaf

The Quey componet is the preferred way of accessing data in
client/server databases. The sql Property in the object inspector can
contain the SQL statements you wish to  execute, this property at
design or runtime.

To set value at design time just click the elipse button to enter the
string list editor.

At runtime, you will need to make sure that you clear any previous
queries. e.g

Query1->SQL->Clear();
Query1->SQL->Add("select * from some table");
Query1->Open();
 Sql statements can be executed with either the Open() or the
ExecSQL() method.  Usually statements that contain SELECT use the Open
method, while  sql staments like  insert, update or delete need to use
the ExecSQL() method. eg

Query1->SQL->Clear();
Query1->SQL->Add(" insert into register");
Query1->SQL->Add("(Surname, Forenames)");
Query1->SQL->Add("values('Betcher','Rob')");
Query1->ExecSQL();

Hope this helps.
On Sat, 22 Jun 2002 20:39:17 -0500, "R. Betcher" <betch23@hotmail.com>
wrote:

>Can anyone point me in the best way to make SQL calls on an interbase /
>firebird database without using ADO.  Which Data access tools?  We were
>going to use the Tquery control to connect and make calls.  Is this the best
>tool to use?  If not could anyone email an example of the best technique for
>local and networked Interbase databases?
>