topic-40096

Board index FiveWin for Harbour/xHarbour For Rao,Requery in ADO

Maurizio

Posts: 842

Joined: Mon Oct 10, 2005 01:29 PM

For Rao,Requery in ADO

Posted: Fri Mar 12, 2021 08:07 AM

Dear Mr. Rao,
i saw in the example mariaqry.prg that it is possible to use requery

Code (fw): Select all Collapse

if oRs:Requery( cSql )
         oRs:SetXbrColumns( oBrw )
         oBrw:nEditTypes := EDIT_GET
         oBrw:GoTop()
         oBrw:Refresh()
         return .t.
      endif

Is it possible to use the same procedure also with ADO?

Thanks
Maurizio

Maurizio
www.nipeservice.com

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: For Rao,Requery in ADO

Posted: Fri Mar 12, 2021 02:51 PM

This is not relevant or not necessary for ADO.
The columns of a recordset do not change after requery.
So simple

Code (fw): Select all Collapse

oBrw:oRs:Requery()
oBrw:Refresh()

is enough.

Regards

G. N. Rao.

Hyderabad, India

Maurizio

Posts: 842

Joined: Mon Oct 10, 2005 01:29 PM

Re: For Rao,Requery in ADO

Posted: Fri Mar 12, 2021 04:46 PM

Grazie RAO

Maurizio

Maurizio
www.nipeservice.com

FiveTech Support Forums

For Rao,Requery in ADO

Re: For Rao,Requery in ADO

Re: For Rao,Requery in ADO

Continue the discussion