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.