Devart Forums

Posted: **Thu 17 Jan 2013 13:20**

Hi,
I have this Refresh SQL:

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

Posted: **Thu 17 Jan 2013 15:38**

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.

Posted: **Fri 18 Jan 2013 00:20**

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

Posted: **Fri 18 Jan 2013 08:55**

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.

Devart Forums

refreshrecord method cause current record to change position

refreshrecord method cause current record to change position

Re: refreshrecord method cause current record to change position

Re: refreshrecord method cause current record to change position

Re: refreshrecord method cause current record to change position