Hello Bruno, unfortunately, there is no way to use content of a LONG column in any expression for searching and sorting.
Sorry for any inconvenience caused Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: Bruno Arliguy [mailto:[EMAIL PROTECTED] > Sent: Friday, March 12, 2004 12:19 PM > To: [EMAIL PROTECTED] > Subject: [QUESTION] LONG field in WHERE clause > > > Hi list. It's my fisrt message, happy to use MaxDB :) > > Could you tell me if there is a way to use a LONG field in a > WHERE clause? > > For exemple, a table like this : > CREATE TABLE SYS_CODE > ( > CREATED TIMESTAMP, > UPDATED TIMESTAMP, > PKREF INTEGER NOT NULL, > CODE_CONTENT LONG UNICODE > ) > > I would like to use the CODE_CONTENT field in a WHERE clause > (mainly to > find a text). If I try this, I get an error message "General > error;-7032 > POS(32) SQL statement not allowed for column of data type LONG." > > Or do you know an other way to store text field (up to 10000 char) and > search on it? > > Thanks. > > -- > Bruno > > > > > > > > -- > Ce message Envoi est certifie sans virus connu. > Analyse effectuee par Anti-virus AVG (http://www.grisoft.com). > Version: 7.0.225 / Base de donnees virus: 262.2.0 - Date: 04/03/2004 > > > > > > -- > Ce message Envoi est certifie sans virus connu. > Analyse effectuee par Anti-virus AVG (http://www.grisoft.com). > Version: 7.0.225 / Base de donnees virus: 262.4.3 - Date: 11/03/2004 > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
