Hi all,


whats the major difference between:
dal.new() and db.insert()
dal.update and db.update()
dal.destroy() and db.delete()

can anyone tell me about the major diffrence

Edit: why we go for DAL functions instead of the LN functions...

thanks in advance
deepa

HI Deepa ,

In db.insert , db.update etc .. DAL checks are not performed and the commands insert/updates into table without performing any DAL checks .

Regards,
Niraj

hi niraj,


can u plzzz tell me clearly...the exact difference..
like u mean to say in dal no need of querying or checking conditions while inserting or updating .any other difference apart from this

plzz tell me in this regard

thanks in advance
deepa

hi niraj,

if suppose in function after.save.object() we r using either dal.update() or db.update().so whats the diffrence if we use dal.update in after.save.object and so also with db.update in after.save.object.


thanks in advance
deepa

The difference between dal.insert and db.insert is the concept. Using the old db.insert calls activates an insert command in the database driver for the mentioned table. Calling an dal.insert activates the DAL. The DAL is a piece of logic that contains contains and checks. This logic is written in 3GL in such a way that data consistently is guaranteed. At least more than when doing a db.insert. There are much more differences, but this is at least one difference.

Of course you can always use db.insert instead of dal.insert, but if you are not sure what you are doing, using the dal.insert is saver.

Kind regards,
Dick