multiple sql statement using TADOQuery

Article View: borland.public.cppbuilder.database.ado

Article #1054

Back to borland.public.cppbuilder.database.ado Previous Next

#1054

From: siraj
Date: Thu, 11 Nov 2004 13:23

22 lines
1691 bytes

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

Technical Details

Message-ID: <419367c2@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!colt.net!easynet-monga!easynet.net!news.clara.net!wagner.news.clara.net!news2.euro.net!216.196.110.149.MISMATCH!border2.nntp.ams.giganews.com!nntp.giganews.com!news-hub.cableinet.net!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,33c67b2d6bc6ce6,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "siraj" <siraj.sm@omnisens.ch>
From: "siraj" <siraj.sm@omnisens.ch>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: multiple sql statement using TADOQuery
Date: Thu, 11 Nov 2004 14:23:14 +0100
Lines: 24
Organization: omnisens
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 128.179.67.34
Message-ID: <419367c2@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1100179394 128.179.67.34 (11 Nov 2004 05:23:14 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!colt.net!easynet-monga!easynet.net!news.clara.net!wagner.news.clara.net!news2.euro.net!216.196.110.149.MISMATCH!border2.nntp.ams.giganews.com!nntp.giganews.com!news-hub.cableinet.net!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail