Message Boards

Write to table via ODBC

A van Asten, modified 3 Years ago.

Write to table via ODBC

Post Date: 12/21/17 (Bronze, 3 Posts) Recent Posts

Hello all,

Is it possible to send data directly to QAD tables via ODBC? Therefore the use of cim-files will become unneccesary. 

Hope to hear from someone whether this is possible or if this is blocked by QAD or that it comes with a price. 

 

Kind regards,

 

Asjer 

thumbnail
Raymond Chin Kwie Joe, modified 8 Years ago.

Re: Write to table via ODBC

Post Date: 12/26/17 (Rhodium, 825 Posts) Recent Posts
In general direct writing to the db is possible. CIM loads"enter" data via the" QAD menus",  checks if the data is valid and updates all other tables (as if a  "user" is entering data in a menu) thus  prevents data corruption. With a direct data upload you do not have any control and might end up with a corrupt database. The trade of is always: speed of transactions vs corruption of data.

Message place holder