asString param, limit of 2000 Chars

Morgan · Post by **Morgan** » Fri 16 Apr 2010 12:09

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.

bork · Post by **bork** » Mon 19 Apr 2010 10:08

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.

Morgan · Post by **Morgan** » Wed 21 Apr 2010 07:37

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.

bork · Post by **bork** » Wed 21 Apr 2010 14:37

You should set your param as:

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

Morgan · Post by **Morgan** » Wed 05 May 2010 09:27

Hi,

The asMemo param need a blob field, no ?

bork · Post by **bork** » Wed 05 May 2010 15:16

Hello

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