Subject Re: [ib-support] problems width storing data
Author Martijn Tonies
Hi,


> I'm new user of firebird database and I have problem width inserting
> data into my table:
> INSERT INTO users VALUES(1, 'George', 'Washington');
>
> (table users has columns(int(5), varchar(30), varchar(30)) and when i

You might want to check your table metadata again. I've never heard of
an INT(5) column. Unless it's an array column.

> execute it width isql I get a message: error converting from
> string "BLOB". I can't resolve this problem, so please can anyone
> help me.

If you have more than 3 columns, list the column names too in the
INSERT INTO statement.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."