delphi2010+odac 6.90.0.53 update error!

xalion · Post by **xalion** » Fri 29 May 2009 09:14

my oracle version is 10.2.0.4
delphi 2010.

ODAC in direct mode.

create table USERDATA
(
USERID NUMBER(22),
STIME DATE,
ETIME DATE,
BZ VARCHAR2(10)
)

with cx do
begin
close;
SQL.Clear;
SQL.Add('UPDATE USERDATA SET ETIME=SYSDATE, BZ=:BZ');
SQL.Add('WHERE USERID=:USERID');
ParamByName('USERID').Asstring:= '48';
ParamByName('BZ').AsString := 'logout';
Execute; // show unknown error 1!
end;

if changed to
with cx do
begin
close;
SQL.Clear;
SQL.Add('UPDATE USERDATA SET ETIME=SYSDATE, BZ=:BZ');
SQL.Add('WHERE USERID=:USERID');
ParamByName('USERID').Asinteger:= strtoint('48');
ParamByName('BZ').AsString := 'logout';
Execute;
end;
It works fine!

but in SELECT , INSERT ParamByName('USERID').Asstring:= '48' works fine.

Plash · Post by **Plash** » Mon 01 Jun 2009 07:21

We have reproduced this problem, and we are working on it. You will be notified when we fix the problem.

xalion · Post by **xalion** » Sat 27 Jun 2009 02:26

odac 6.80.0.48 still has this bug!

michellenweiter · Post by **michellenweiter** » Mon 29 Jun 2009 08:03

We do have the same problems and are waiting for a solution...

Plash · Post by **Plash** » Tue 30 Jun 2009 07:19

We have not fixed this problem yet. We will fix it in the nearest future.

michellenweiter · Post by **michellenweiter** » Mon 31 Aug 2009 14:23

Have you fixed this problem yet?

Plash · Post by **Plash** » Tue 01 Sep 2009 07:52

We will fix this problem in the next ODAC build.

xalion · Post by **xalion** » Wed 18 Nov 2009 06:42

The problem still in 5.90.0.53

xalion · Post by **xalion** » Fri 27 Nov 2009 01:32

hello?

xalion · Post by **xalion** » Fri 05 Feb 2010 14:24

The problem still in 5.90.0.55

Plash · Post by **Plash** » Mon 08 Feb 2010 13:37

Please contact us by e-mail support*devart*com. We will send us the new version for testing.