First() not works

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ErezHarari
Posts: 5
Joined: Wed 21 Jul 2010 14:50

First() not works

Post by ErezHarari » Wed 01 Feb 2017 09:28

Hi,
I call to First method of TSmartQuery but the RecNo doesn't changed.
I try to set TSmartQuery .Options.ScrollableCursor but this raise
'ORA-01002: fetch out of sequence' when I call to Open method.
This error occurred after I upgrade to ODAC 9.7.28.
I use Delphi XE VCL, direct connection to Oracle 11g and Windows 7.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: First() not works

Post by MaximG » Wed 01 Mar 2017 11:34

We checked SmartQuery work according to the description and found no problems. For further investigation, please compose and send us a small project in which the problem occurs. In addition, we will need a script to create DB objects used in this project. You can send this sample via the e-support form ( https://www.devart.com menu "Support"\"Request Support" )

Post Reply