Socket connection Multitier adoquery 1

[kyriakos70]

Hello,
I have a question, I have created a multitier with socket connection (database sql, oledb connection string with ado connection), on the server side I have placed an ado query and try to execute the SQL of the Adoquery from the client side with a client dataset (the query has parameters it is like 'SELECT * FROM individuals WHERE id LIKE idd)+'%''), how can I close the query fill the parameters values and open it again?

Thank you
Kyriakos

 

[roo0047]

  MyQuery.close;
  MyQuery.sql:= 'SELECT * FROM individuals WHERE id = "me-me"';
  MyQuery.open;

Roo
Delphi Rules!