A ClientDataSet in Every Database Application
The above link / article explains the workings of a CLientDataSet.
I am accustomed to working with tables in Delphi and such.
After retreiving a dataset using SetRange(begin, end ), I would load the results into a TTable and use the following table methods.
If not Table.active then
Table.open
end if
Table.first;
While Not Table.eof() do
Begin
Table.edit;
// process fields however...
Table.next;
end;
If table.state in [dsEdit, dsInsert] then
Table.post;
end if;
Table.close;
I grid would be most useful for displaying feilds from a recordset. I looked at the table example and see how it functions (to some degree)
I do not know how to iterate records using SQL commands in a fashion similar to that above...
Thanks
MHW
The above link / article explains the workings of a CLientDataSet.
I am accustomed to working with tables in Delphi and such.
After retreiving a dataset using SetRange(begin, end ), I would load the results into a TTable and use the following table methods.
If not Table.active then
Table.open
end if
Table.first;
While Not Table.eof() do
Begin
Table.edit;
// process fields however...
Table.next;
end;
If table.state in [dsEdit, dsInsert] then
Table.post;
end if;
Table.close;
I grid would be most useful for displaying feilds from a recordset. I looked at the table example and see how it functions (to some degree)
I do not know how to iterate records using SQL commands in a fashion similar to that above...
Thanks
MHW
