🚀 go-pugleaf

not sure if this will work but you can get the jist of an idea.

query->SQL->Add("Select * from table);
query1->SQL->Clear();
query->Open();
while(!query->Eof)
{
   if (query->FieldByName("DisplayStatus")->AsValue > 4)
         query1->SQL->Add("update table set conn =
"query->FieldByName("conn")->AsValue *2);
   else
        query1->SQL->Add("update table set conn = 0");
   query1->Execute();
}


"siraj" <siraj.sm@omnisens.ch> wrote in message
news:419367c2@newsgroups.borland.com...
> Hi!
> I am using c++ builder 5 and access 2000. I connect using ADO components.
> I have a TDBChart and the datasource of the Series on the chart is
> TADOQuery.
> Using the ADOQuery, I query a table in access 2000. The recordset should
be
> modified depending on the value of one of the field in the table.
> For example,
> In my table,  I have name,timestamp,conc,DisplayStatus.
> If DisplayStatus>4 then
> conc=conc*2;
> else
> conc=0
>
> How can i make the ADOQuery return the resultset depending on the above
> rule.
>
> It is something like a batch sql statement.
>
> How can I do this? Any code samples?
>
> Regards
> Siraj
>
>