For Rao,Requery in ADO

For Rao,Requery in ADO

Postby Maurizio » Fri Mar 12, 2021 8:07 am

Dear Mr. Rao,
i saw in the example mariaqry.prg that it is possible to use requery
Code: Select all  Expand view
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
User avatar
Maurizio
 
Posts: 807
Joined: Mon Oct 10, 2005 1:29 pm

Re: For Rao,Requery in ADO

Postby nageswaragunupudi » Fri Mar 12, 2021 2:51 pm

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

Code: Select all  Expand view

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

is enough.
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10465
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: For Rao,Requery in ADO

Postby Maurizio » Fri Mar 12, 2021 4:46 pm

Grazie RAO

Maurizio
User avatar
Maurizio
 
Posts: 807
Joined: Mon Oct 10, 2005 1:29 pm


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 27 guests