commit in navision standards

MRQ

hi :twisted:

can we use commit in this way

anyrecourd.looktable;
while Not item.next=0 then

.......//code
.......//code
.............//code

commit;
end

in navision standards can i use commit inside loop?????

FSG

Yes, but isn't recomendable

DenSter

you can use COMMIT anywhere you like, except from certain triggers. Navision will scream at you when you put it there. Remember though, that COMMIT will write the transaction and you will not be able to have the DBMS automatically roll it back, so use it wisely (i.e. only at points where the data is consistent).