Has anyone ever written data for Baan directly to the database tables? I am running Baan IVc3, NT 4.0, SQL Server 7.0. I wrote a SQL statement that has an algorithm for the hash columns, and the data seems to be read by Baan. Has anyone else attempted something similar, adn what were the effects?

Think you make your Baan support contract invalid.

Can you send me the algorithm for fill the hash column that you developed?

Thanks

Daniel C Binder
Mind Business Technology

Hi vinceco252,

updating fields in baan-tables directly via updating the database (bypassing baan database driver) seems to work fine as long as You don't update fields that have an integrity reference defined.
(so i.e. if You update the sales price of an item in tiitm001)

The problem is that the baan database-driver (at least for Oracle) does not rely on the database referential integrity checking, but does it's own.

So if You'd update, the region-field (creg) of a customer in tccom010, that integrety tracking would get mixed up, because that field is referenced to some tcmcs table.

The result if you do so is almost hanging processes if those tabeles are touched. (At least that was the behaviour on an BaaN IVc4 whith Oracle 8.0.5 on HP-UX)