Re: Convert AdoRecordSet to DataTable
Posted: Fri Dec 06, 2024 4:25 pm
Robert,
That is very good news, an Xs2Ado update. I am working on a project where Xs2Ado is used a lot and while it may be better to use Ado.Net in X#, the priority at the moment is to transform the VO-forms to Winforms and add features. So Xs2Ado will not be abandoned for quite some time, if at all. If possible please update the documentation / help file as well. Lots of things are not explained and there are very few examples given. Something I encountered this afternoon for example is this. In the explanation for AdoServer:RecordSet it says "Please be careful when using this AdoRecordSet object. If you have to move the record pointer, move it back to where it was after you are finished, or else the Server object may get 'confused'." A small piece of code would help here because I don't know how to move back the record pointer in the RecordSet. There is no RecNo or Goto. Or should the record pointer be moved back in the AdoServer object? Does AdoRecordSet:GetRows() move the record pointer in the AdoRecordSet?
Kees.
That is very good news, an Xs2Ado update. I am working on a project where Xs2Ado is used a lot and while it may be better to use Ado.Net in X#, the priority at the moment is to transform the VO-forms to Winforms and add features. So Xs2Ado will not be abandoned for quite some time, if at all. If possible please update the documentation / help file as well. Lots of things are not explained and there are very few examples given. Something I encountered this afternoon for example is this. In the explanation for AdoServer:RecordSet it says "Please be careful when using this AdoRecordSet object. If you have to move the record pointer, move it back to where it was after you are finished, or else the Server object may get 'confused'." A small piece of code would help here because I don't know how to move back the record pointer in the RecordSet. There is no RecNo or Goto. Or should the record pointer be moved back in the AdoServer object? Does AdoRecordSet:GetRows() move the record pointer in the AdoRecordSet?
Kees.
robert wrote: ↑Thu Dec 05, 2024 4:49 pm Kees,
Simply call GetRows() with 3 NIL variables should work
I am working on an update for Xs2Ado. I will make the parameters optional again.Code: Select all
oRs:GetRows(NIL,NIL,NIL)
Robert