From: Bruno Arliguy (barliguylaposte.net)
Date: Fri Mar 12 2004 - 05:18:43 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]