Page 1 of 1

asString param, limit of 2000 Chars

Posted: Fri 16 Apr 2010 12:09
by Morgan
Hi,

I've encounter a problem with delphi 6. I have a column (type long) and when i add informations with a asString param i have a limitation of 2000 char.
How can i exceed the limit of 2000 char?

Thanks you.

Posted: Mon 19 Apr 2010 10:08
by bork
Hello

Where are you going to use this parameter? In a query or in a stored procedure?

Please send us the SQL code where you are going to use your parameter.

Posted: Wed 21 Apr 2010 07:37
by Morgan
Hello,

I use the asString param in Delphi code and when i execute the query, only the 2000 firsts char of my delphi string variable are add in my field.

Posted: Wed 21 Apr 2010 14:37
by bork
You should set your param as:

OraQuery1.ParamByName('LongParam').AsMemo := LongString;

Posted: Wed 05 May 2010 09:27
by Morgan
Hi,

The asMemo param need a blob field, no ?

Posted: Wed 05 May 2010 15:16
by bork
Hello

No, you can use "asMemo" parameters for update field that has Long type.