Page 1 of 1
Error in Params
Posted: Fri 07 Nov 2008 11:13
by progman
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).
Posted: Mon 10 Nov 2008 08:59
by Plash
Please provide the text of your query.
Posted: Tue 25 Nov 2008 09:32
by phelz
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 = ''
Posted: Wed 26 Nov 2008 08:51
by Plash
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).
Posted: Thu 27 Nov 2008 11:51
by burdian
Same here, but only with Interbase(Firebird) provider, no problems with Oracle and SQL Serever.
Best regards
Branko
Posted: Fri 28 Nov 2008 09:08
by Plash
We have fixed this problem. The fix will be included in the next build of UniDAC.