Hmm. Seems like a slight oversight that! We have had to do major work-arounds the LONG datatype for many different applications in code, which obviously causes performance issues.
Is there no way that you could look at prioritising this slightly higher than it seems to be at the moment? Having to used Prepared Statements in updates in tables where there are LONG columns is cumbersome in smallish level applications, but the major problem is not being able to compare LONG columns or use the LIKE predicate... Anyway, my 2 cents, use it, don;t use it, I leave it with you ;) Regards, Carl -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Zabach, Elke Sent: 22 May 2002 07:57 To: 'Markus Gieppner'; Koetter, Thomas Theodor; 'Srdjan Josipovic'; [EMAIL PROTECTED] Subject: RE: Problem with Selecting value of LONG data type column on WebPage ADO/ASP on IIS/WIN2k Markus Gieppner wrote: > "in SAP DB you cannot use long columns like "usual" ones in a where clause." > > Is this (even in a very basic/simple/limited form) planned for a future release? This is not planned in a foreseeable release Elke SAP Labs Berlin > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koetter, Thomas Theodor > Sent: Tuesday, May 21, 2002 4:25 AM > To: 'Srdjan Josipovic'; [EMAIL PROTECTED] > Subject: RE: Problem with Selecting value of LONG data type column on WebPage ADO/ASP on IIS/WIN2k > > > Hi Srdjan, > > > When trying to make a search procedure to search within text of profiles , if > > condition is PROFILE LIKE...something >> ERROR >> > > > Microsoft OLE DB Provider for ODBC Drivers (0x80004005) > > [SAP AG][SQLOD32 DLL][SAP DB]General error;-7032 POS(49) > > SQL statement not allowed for column of data type LONG. > > in SAP DB you cannot use long columns like "usual" ones in a where clause. > > > > "SELECT PROFILE WHERE ID = something " > > > Recordset returns Name of the Field , and all properties which you can > > get with ADO , but value of the PROFILE , text for DB field NONE !!!!! > > > Page stay empty ! > > > Please send me a VB-project and what else is needed to reproduce the error. > > > > Regards Thomas > > ---------------------------------------------- > Dr. Thomas K�tter > SAP DB, SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
