Error in Params

progman · Post by **progman** » Fri 07 Nov 2008 11:13

I use query with 4 params (2 params of integer type, 2 params of string type). Provider: InterBase/FireBird, UniDac: 1.20.
After I opened query, params of string type disappeared !
When I looked them closer I saw that their names was truncated (2 chars - left side).

Plash · Post by **Plash** » Mon 10 Nov 2008 08:59

Please provide the text of your query.

phelz · Post by **phelz** » Tue 25 Nov 2008 09:32

i have almost the same error, multiple execution of the same query cause string params truncation (2 chars, left side)

this is a sample code

Code: Select all

Q.SQL.Clear;
Q.SQL.Add('INSERT INTO CARTELLINOGIU (CAUSALE, DATA) VALUES (:CAUSALE, :DATA)');
Q.ParamByName('causale').AsString := 'FERIE';
for j:=1 to 10 do
begin
  Q.ParamByName('data').AsDateTime := Date+j;
  Q.Execute;
end;

first execution, param causale = 'FERIE'
second execution, param causale = 'RIE'
third execution, param causale = 'E'
4th to 10th execution, param causale = ''

Plash · Post by **Plash** » Wed 26 Nov 2008 08:51

We could not reproduce the problem. Please send to unidac*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.

Also specify the exact version of UniDAC including build number (see UniDAC | About UniDAC in the IDE menu).

burdian · Post by **burdian** » Thu 27 Nov 2008 11:51

Same here, but only with Interbase(Firebird) provider, no problems with Oracle and SQL Serever.

Best regards
Branko

Plash · Post by **Plash** » Fri 28 Nov 2008 09:08

We have fixed this problem. The fix will be included in the next build of UniDAC.