Hello,

I have a short question if some body can answer me.

When I'm trying to update/modify record in table tisfc010 using GTM while DAL is active, I'm getting following error.

"The Data Access Layer doesn't allow the operation update on table tisfc010"

Could any please tell me,
1. Where it is programmed in LN to show this message in GTM
2. Can i modify record using script


Thanks,
/Aamir

You might be getting error because of some checks written in the DAL script of the table tisfc010. You can change the value in you 4GL scripts by using db.update() fn. but if you are are using dal.update() fn. then system will again go through the checks which are written in the DAL script. You can change the value through GTM also, for that before viewing the records of the table first you need to deactivate the DAL in GTM then you can edit the records through GTM without DAL checks.

Regards,
Gaurav B

Hi,

If you it is test company then not much problem.
But Dal checks are there for business integrity.
If you skip those and update records then your data may contain wrong values.

Regards,
--MilindV

tisfc010 is somewhat weird to be updated using DAL. As a rule of thumb, GTM (or also DAL based exchange or simply calling the dal.xxx methods in a script) will not do the trick here. That DAL has a global variable, indicating sort of on operation mode, making it behave differently if used during planning, reporting complete etc. That variable must be set using a particular business method in the DAL (and to make things worse, the name of that method is Feature-Pack dependent - the DAL was rewritten for FP3). GTM will not call that business method, so the DAL will not work correctly giving you the error you're experiencing, since without that flag set to some value, it will allow no updates at all.