refreshrecord method cause current record to change position

[inageib]

Hi,
I have this Refresh SQL:

Code: Select all

select 
    table1.pk1,
    table1.f2,
    table2.f_name,
from table2
   right outer join table1 on (table2.pk1 = table1.pk1)
WHERE
  pk1 = :pk1

now when I call the this method tibcquery.refreshrecord;
the cursor jump to different record in the dbgrid. please advise how to make it remain in original record before refresh.

Thanks

[AndreyZ]

Hello,

Please specify the script to create and fill the table1 and table2 tables. Also please specify the following:
- the exact version of IBDAC. You can learn it from the About sheet of TIBCConnection Editor;
- the exact version of your IDE.

[inageib]

pk1 field is Integer and primary key, F2 and f_name are varchar at any size
both table1 and table2 tables can have any data.

the IBDAC 4.5.10 and IDE Version is 14.0.3593.25826

[AndreyZ]

I cannot reproduce the problem. Please try creating a small sample to demonstrate the problem and send it to andreyz*devart*com , including a script to create and fill the table1 and table2 tables.