RE: Problem with Selecting value of LONG data type column on WebPage ADO/ASP on IIS/WIN2k

[Markus Gieppner]

Thomas,   "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?   Thanks,   Markus         -----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 SAP DB is open source. Get it!    www.sapdb.org