FiveTech Software tech support forums

Posted: **Fri Mar 12, 2021 8:07 am**

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

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

Posted: **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


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

is enough.

Posted: **Fri Mar 12, 2021 4:46 pm**

Grazie RAO

Maurizio

FiveTech Software tech support forums

For Rao,Requery in ADO

For Rao,Requery in ADO

Re: For Rao,Requery in ADO

Re: For Rao,Requery in ADO