Very important: Problem with ORACLE SQL!

From: Manuel Mießner <SPAMMiessner_at_centaur.deSPAM>
Date: Thu, 27 Aug 1998 14:27:14 +0200
Message-ID: <6s3j5p$uij$1@news.centaur.de>

Hello.

My System: Win Nt 4.0; Visual Basic 5.0 SP3 OO4O Classes; no ODBC. Connect via Oracle Object Library. Oracle 8

I have two problems:

# 1: After an unknown count of youerys (via ExecuteSQL or CreateDynaset)
i get the Oracle Error "Maximum Cursors ecxeeded: why? After every Quere i set the object
to nothing.

#2: This query doens't work. Why?

Fielddefinitions:
aukIndex = SmallInt
gwzID=Integer
gwzKernNr=Integer

Query:
SELECT gwzID, gwzKernNr, 'AK' + aukIndex as AKINDEX FROM tblGWZ, tblGWZ_AK,tblAK WHERE gwzID=a_g_gwzID and aukID=a_g_aukID and gwzKernNr = 100189

the problem part is " 'AK' + aukIndex as AKINDEX "

Thanks for help.
Manuel

e-Mail: miessner_at_centaur.de Received on Thu Aug 27 1998 - 07:27:14 CDT