For Rao,Requery in ADO

Post Reply
User avatar
Maurizio
Posts: 827
Joined: Mon Oct 10, 2005 1:29 pm
Contact:

For Rao,Requery in ADO

Post by Maurizio »

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

Code: Select all | Expand

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
nageswaragunupudi
Posts: 10729
Joined: Sun Nov 19, 2006 5:22 am
Location: India
Been thanked: 10 times
Contact:

Re: For Rao,Requery in ADO

Post by nageswaragunupudi »

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


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

is enough.
Regards

G. N. Rao.
Hyderabad, India
User avatar
Maurizio
Posts: 827
Joined: Mon Oct 10, 2005 1:29 pm
Contact:

Re: For Rao,Requery in ADO

Post by Maurizio »

Grazie RAO

Maurizio
Post Reply