SQLExecute failures

[Stan Busk]

Hi,

SQLExecute with UPDATE seems to work only on fresh files. In 2 
different products with several files, as soon as you have many records 
the command simply fails. I have been facing the problem during 2 
months so far. The command is:

rows = myDatabase.SQLExecute("UPDATE myTable SET myField='0'")

rows returns the correct record count but not a single myField of 
myTable is set to 0. Use to work on fresh files but one day, after 
adding a given number of records, it stops working.

Anybody knows what can cause that?

Stan