Text datatype

[Joeyp]

I have one table with a text column. When I try to insert into this table, this error message appears:

# 617: A blob data type must be supplied within this context.


The insert statment is:
insert into teste_blob (codigo, desc) values (1,'Test')
codigo = Integer
desc = Text

Thanks.

 

[sanjaynahar]

assume u r using dbaccess try "load" statement.

sure it helps.

sanjay

 

[LeoAtilano]

I have the same problem, but the load statement gives me a "values does not match the number of columns" error.

Also, I have to insert the text values from an ASP.

Does anybody know to do this?

 

[nkm]

Hi Leo

I think in the unload file you have specified a pipe too many.
Dont have a pipe at the beginning of the record in the unload file, and end it with a pipe

e.g.

1|<clob data>|