Problem with ADO

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

Article #4943

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

#4943

From: Philii Grabher
Date: Tue, 04 Sep 2001 10:14

19 lines
1556 bytes

Hy 

I have the following SQL statement in the Cpp Builder 5.0 and I use
a Oracle Database

SELECT COUNT(STICHPROBENNUMMER) AS SP_COUNT FROM VT_RS_STICHPROBEN
WHERE STICHPROBENNUMMER = :Param1

The statement is correct, but ADO modifies the statement, so the
datebase gets

SELECT COUNT(STICHPROBENNUMMER) AS SP_COUNT FROM
VT_RS_STICHPROBEN.ROWID WHERE STICHPROBENNUMMER = :Param1

But with the ROWID it doesn't work, can someone give me a hint how to
solve this problem?

Thanks a lot in advance
Philipp

Technical Details

Message-ID: <d44f8329.0109040214.6aec6fb8@posting.google.com>

Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f5cad,9a82184c4fbd732e,start
X-Google-Attributes: gidf5cad,public
X-Google-Thread: 10698b,9a82184c4fbd732e,start
X-Google-Attributes: gid10698b,public
X-Google-Thread: 103c8d,9a82184c4fbd732e,start
X-Google-Attributes: gid103c8d,public
X-Google-ArrivalTime: 2001-09-04 03:14:08 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail
From: sportfreund@gmx.at (Philii Grabher)
Newsgroups: borland.public.cppbuilder.database.ado,borland.public.delphi.database.ado,borland.public.cppbuilder.language
Subject: Problem with ADO
Date: 4 Sep 2001 03:14:08 -0700
Organization: http://groups.google.com/
Lines: 19
Message-ID: <d44f8329.0109040214.6aec6fb8@posting.google.com>
NNTP-Posting-Host: 212.152.173.164
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 999598448 17209 127.0.0.1 (4 Sep 2001 10:14:08 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 4 Sep 2001 10:14:08 GMT