Our Italian guys used delete records in <Tablename> with bla bla blavery often.
And since some weeks we have problems with this statement.
It doesnt work any more in a procedure with the form
Define fields bla bla bla.
Delete records in tablename with xxx=yyy .
For othertablename with aaa=bbb ;
Enter a record in tablename
Copy all from othertablename ;
Additionalfield := qwerty .
Do something more or do something else
So deleting records before entering new ones in.
If we change such a procedure with the statement run procedure pdeletetablename
And create procedure pdeletetablename with the only statement the delete records ; it works.
Does this have to do with a big procedure or something with locking or something else ?
Any idea ?
I searched for delete record in dql info and there I got 105 hits, I dont like when we have to change them.
And it worked in 7.2, never had problems.
Did something change there ?