Token size exceeded error - Confused ??

[bradhiggins]

Hey all,

I have a job tracking database designed so our work can track jobs done for clients.

I have a table with a Description field that is set to VARCHAR(30000) as oftern we keep a job open for a month and just keep adding to it and descriptions get quite lenghty and involved.

When I am conducting a database insert on some of the more larger descriptions I get the following error :
Dynamic SQL Error
SQL error code = -104
token size exceeds limit

Is there a way I can split the description insert into smaller tokens, or enlarge the token size or anything to get around this error.

Cheers

Brad

 

[MartijnTonies]

Hi Brad,

Is this an

INSERT INTO ... VALUES ('Mega long description')

?

If so, I'd try using a prepared statement with parameters:

INSERT INTO ... VALUES description, ... )

Prepare the statement by calling .Prepare method (assuming Delphi)

ParamByName('description').AsString := ...
ExecSQL



Alternatively, why not use a BLOB?


Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird, MySQL & MS SQL Server

http://www.upscene.com