Can someone out here help me with DAL scripting,there are three things i want to know:
1. what are the different object hooks and property hooks in DAL and how can we relate them to the earlier versions of BaaN to main.table.io function.
2.if i want to write a function like:
function update.expiry.lines()
{
db.retry.point()
select lines.field
from lines for update
where lines._index1 = {:header.field}
selectdo
lines.field = header.field
db.update(lines, db.retry)
endselect
commit.transaction()
}
in my DAL script. i want this function to be executed for tdpur300.edat, whenever the field changes, that is whenever a user modifies a record in header, the lines should be updated.

pls reply as soon as posible

Thanx
gaurav

Perhaps I can help you but I'm hesitating because I've never heard of "DAL" I've been cranking out code for a few years. We run BaaNIVc3 on HPUX.

Have you looked at the DAL manual u7035BUS. It explains it all. This usually comes with the documentation cd with BaanERP

Joy - DALs exist in Baan 5. It stands for "Data Access Layer". Really they are just DLLs but with predefined extern function names (you can also define your own, these are termed "Business Methods").

The old routines for updating the database still exist (db.*) but do not reference the DALs. However, most code in Baan 5 use the new, DAL, enabled routines (dal.update, dal.delete, dal.insert, etc). The DALs are the only ones that should use the lower-level routines.