🚀 go-pugleaf

Access SQL supports some VBScript functions, so query like this may work:

select Iif(DisplayStatus > 4, conc*2, 0) as conc from mytable

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"siraj" <siraj.sm@omnisens.ch> �������/�������� � �������� ���������:
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
>
>