Hi friends,

I have a question about of tables in LN.

I am working with Infor LN 6.1.

In old BaaN versions when I have placed data in a baan table from an external source, never these tables have had DAL. (Temp. Tables)

Now I am making something similar for LN in a Baan table that has DAL.

Would I have a problem with this when the external source places data in this table?

For example of external source: May be a oracle trigger; that is, the data is not saved in the table by baan sessions.


Thank you.

The DAL has hooks built to perform checks/validations on table fields, and the intention of building DALs is to execute these checks when the table is accessed from within the Baan application or from outside, by using Oracle triggers etc. Depending on what checks are programmed into the DAL of the table you are trying to access, it will affect your database actions from the external source.
If all checks are successful and the data you are trying to save into the table is validated by the DAL, then there should not be any problem. If not, the DAL will return a suitable error message which will tell the external source what the problem is.

the intention of building DALs is to execute these checks when the table is accessed from within the Baan application or from outside

This is not correct "NVP". Dal functionality is only available inside LN. If you modify the table from outside (Oracle, ODBC,..) no DAL checks or update of related tables are done! You could basically end up with corrupted data. If you have to fill DAL-enabled Tables from outside LN you should use something like OLE-Automation which actually fills the Table using an LN DLL.

Hi Vahdani,

Thank you a lot for your answer, I understand you, the dal only will have validations of data, in my caso; that is, the dal doesn't have updates to other tables, then, in the case that I explain you.

Would I have problem in this scenario when I put the data from external source?

Would I have problem in this scenario when I entry to the data from Baan Sessions, obviously, this action after that I put the data from external source?


Thank you...