I had this trouble some time ago. Since I need only to compare LONG when they have just short data (my systems stores a number, a name or a address in same field where I store a large text), I have created a VARCHAR field to accomodate this short data infos (in parallel with my LONG field), and used it to compare.
To search in LONG fields when I had large text (where I can't use LIKE operator), I used Lucene search engine to make a full text search index... Interesting is that this approach permited I use SapDB, Oracle and MSSQL in same way, and Lucene is TOO MUCH FAST and powerfull searchs than LIKE operator... After localizing results throught Lucene API, I get PK and find records in my table... When SapDB support (in the future), I'll be happy to create and contribute UDF to integrate Lucene in SapDB... My2c, Edson Carlos Ericksson Richter Gerente de Tecnologia ECONET Solu��es Web +55 61 326 5115 -----Mensagem original----- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Em nome de Carl Olivier Enviada em: quarta-feira, 22 de maio de 2002 03:14 Para: Zabach, Elke; 'Markus Gieppner'; Koetter, Thomas Theodor; 'Srdjan Josipovic'; [EMAIL PROTECTED] Assunto: RE: Problem with Selecting value of LONG data type column on WebPage ADO/ASP on IIS/WIN2k 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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.362 / Virus Database: 199 - Release Date: 07/05/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.362 / Virus Database: 199 - Release Date: 07/05/02 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
