🚀 go-pugleaf

"Sudesh" <sudeshc@vfemail.net> wrote in message 
news:47bdbf12@newsgroups.borland.com...

> I could not get one thing working. Could you please tell me what's wrong 
> below:
>
> ADOQuery1->SQL->Clear();
> ADOQuery1->Close();

Personally, I'd put the close before the clear.  Also note, when you clear 
SQL TADOQuery will implicitly close the database.  I'd still leave the call 
to close in there to make it obvious what you are doing.

> ADOQuery1->SQL->Add("SELECT * FROM marks ");
> ADOQuery1->SQL->Add("WHERE student_score > 25");
> ShowMessage(ADOQuery1->SQL->Text);
> ADOQuery1->Open();

Looks fine.

> //ADOQuery1->ExecSQL();
> ADOQuery1->Active = false;

Remove these two lines.

> With this code, I still see all the records in DBGrid instead of records 
> having score >25.

I assume the grid's DataSource property references a datasource on your form 
(ie. DataSource1).  The datasource's DataSet property should be linked to 
ADOQuery1.  If that's how things are configured then you should only be 
seeing records with student_score > 25.  If you can't get this to work then 
in the IDE switch to your form's designer view.  Type ALT+F12 to switch to 
edit the DFM of the form.  Select all, copy, and paste this in your response 
to my post.

> is ExecSQL() required or Open() and Active is ok?

ExecSQL() is used to execute commands that return no data like INSERT, 
UPDATE, and DELETE.  Use Open() or "Active = true" to open a SELECT command.

Clayton