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

[Koetter, Thomas Theodor]

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