ODAC 7.0.0.1 can't return all records in direct mode

xalion · Post by **xalion** » Thu 30 Sep 2010 01:36

ODAC 7.0.0.1 with delphi 2010 in direct mode.
I have table with 380000 records.

try
with aaa do
begin
Open;
while not eof do
begin
Inc(i);
next;
application.ProcessMessages;
end;
close;
end;

it only show 9675 records.
but in oci mode. it shows all records

AlexP · Post by **AlexP** » Thu 30 Sep 2010 12:22

Hello,

I couldn't reproduce the problem.
Please send me a script to create the table to alexp*devart*com.

xalion · Post by **xalion** » Thu 30 Sep 2010 15:00

-- Create table
create table IPLOC
(
ip1 VARCHAR2(16) not null,
ip2 VARCHAR2(16) not null,
loc VARCHAR2(500),
ipnum1 NUMBER(10),
ipnum2 NUMBER(10)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 30
next 1
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table IPLOC
add constraint IPLOCPK1 primary key (IP1, IP2)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 28M
next 1M
minextents 1
maxextents unlimited
);

AlexP · Post by **AlexP** » Fri 01 Oct 2010 09:34

Hello,

I created the table and filled it with data (380000 records), but after executing your code I got a correct result.
We had some other problem with the direct mode in the 7.00.0.1 version of ODAC that is already fixed. Maybe your problem also is fixed. Please tell me your email to send the fixed *.dcu files.

xalion · Post by **xalion** » Sat 02 Oct 2010 13:50

Thank you, my email: xalion at xasyu.cn

bork · Post by **bork** » Tue 05 Oct 2010 13:00

Hello

I sent the fix by E-mail.

xalion · Post by **xalion** » Tue 05 Oct 2010 13:51

I use your new file. but I can't compiler the application.
it shows error:
[DCC Fatal Error] Unit1.pas(7): F2047 Circular unit reference to 'Unit1'

AlexP · Post by **AlexP** » Wed 06 Oct 2010 12:24

Hello,

Please, try compile new empty project without any components, and a new project with the TOraSession component. If the error persists, please reinstall ODAC, replace the DCU file and try again.
If it doesn't help, please contact me.

xalion · Post by **xalion** » Wed 06 Oct 2010 12:43

still have error!

AlexP · Post by **AlexP** » Wed 06 Oct 2010 13:35

Hello,

Please tell when the error arises - in the project that contains only TOraSession or in the project that contains other components.

xalion · Post by **xalion** » Wed 06 Oct 2010 13:42

only one orasession.

AlexP · Post by **AlexP** » Thu 07 Oct 2010 10:12

Hello,

Please uninstall all ODAC components and all *.DCU, *.BPL, *.DCP ODAC files.
Unpack and install the original ODAC components without changing the source code.
Try to compile the project with TOraSession, and if the compilation is successful, replace the OraNet.DCU file and try to compi'le the project again.

xalion · Post by **xalion** » Thu 07 Oct 2010 10:58

I am sorry, I put the oranet.dcu in delphi XE.
please send me a oranet.dcu for delphi xe.
Thank you again.

bork · Post by **bork** » Fri 08 Oct 2010 12:05

Hello

I sent the fix for Delphi XE by E-mail.

xalion · Post by **xalion** » Fri 08 Oct 2010 13:16

I got it.
I will test it tomorrow.
Thank you.