Devart Forums

Posted: **Fri 26 Jan 2007 17:00**

I dont know if this is a bug or an I doing something wrong.

Using TCRBDGrig and OptionsEx.dgeLocalsorting := true with TORaQuery and NonBlocking = True I'm receiving a "ORA-01002 Fetch out of sequence" error when I try to Prepare the query after modifing the grid order.

The steps to reproduce the error using the demo provided with ODAC CRDBGrid.dpr with BDS 2006.

1. Change Oraquery.Nonblocking := True
2. Enable Localsorting in the CRDBGrid.
2. Change the code of onClick event of btOpen to

Code: Select all

procedure TMainForm.btOpenClick(Sender: TObject);
begin
  if not OraQuery.Prepared then
    OraQuery.Prepare;

  OraQuery.Open;
end;

3.Compile and run the program
4.Open the query
5.Change the order by clicking in one of the titles
6. Close the query
7. Open again
8. Now I receive the error.

I hope this can help, if I did something worng pelase tell me.

Best regards.

Alexandre.

Posted: **Tue 30 Jan 2007 10:52**

We have fixed this problem. The fix will be included in the next build of ODAC.

Posted: **Tue 30 Jan 2007 12:05**

Thanks.

Can you send me or post the fixed program somewhere?

Alexandre.

Posted: **Tue 30 Jan 2007 15:39**

If this problem is critical for you, please contact us by e-mail and specify your licence number, ODAC edition and Delphi version.

Posted: **Thu 01 Feb 2007 19:03**

I've sent an e-mail to [email protected] with my info.

Posted: **Tue 06 Feb 2007 19:34**

As I said in my e-mail this problem is critical for me.

Why do you asked my license information and not sent me the fix?

I've changed parts o my application to this Grid and now I've to ask my users to not use the new functions avaliable by TCRDBGrid because isnt working.

I can't change my queries to Nomblocking = False.

If you already fixed it why the delay to send me the fixed programs?

Alexandre

Posted: **Wed 07 Feb 2007 08:59**

We have not received your e-mail yet. Please resend it to odac*crlab*com.

Devart Forums

TCRDBGrid problem

TCRDBGrid problem

Thx

Yes it is

Critical Problem