With the table functions of finaquant® protos
(non-commercial) or finaquant® calcs
(commercial) data tables are always read and written as a whole, just like you would store matrix variables in a math software.
.. as explained in related forum post: How to read and write tables from/to a database?
For example, assume you have a data table (of type MatrixTable), say T1. You can T1 with following statement:
- Code: [Select all] [Expand/Collapse] [Download] (Untitled.txt)
dstore.WriteTableInstance(T1, "sales", trow);
- GeSHi ©
.. where "sales" is the name of the database table, and trow (of type TableRow) is the table instance information.
If you make some changes on table T1, and re-execute the statement above, the table instance stored in the database completely before storing the current instance of T1.
Incremental or partial read/write operations are not possible, and deliberately so, with finaquant's table functions. because tables are read and stored just like scalar or matrix parameters; always as a whole!