Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.


Welcome, Guest
Guest Settings
Help

Thread: ADO CursorType works differently for oracle client 12.1 and 12.2


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 0
Katarzyna Kulpa...

Posts: 1
Registered: 5/3/13
ADO CursorType works differently for oracle client 12.1 and 12.2  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 28, 2017 11:18 PM
Hi All,

I just upgraded my oracle client from 12.1 to 12.2 and I've noticed that ADO CursorType ctDynamic works differently in version 12.1 and 12.2. Namely, for 12.1 move to the next record, which is the last one in the record set, causes that the EOF is set to true. But in 12.2, for the same action, EOF is set to false. Why do I see this difference? Nothing else was changed, I only upgraded the client from 12.1 to 12.2.

I'm using Delphi XE3, and here is a part of my code where I set up the CursorType:

  ADOQuery.CursorLocation := clUseServer;
  ADOQuery.CursorType := ctDynamic;
  ADOQuery.CacheSize := 500;
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02