SQLExecute failures

[Frank Schima]

Hi Stan,


On Mar 15, 2005, at 10:05 AM, Stan Busk wrote:

> 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?

Can you give more details about what platform, what API (looks like 
V4RB) you are using, and what version of Valentina?

There were some UPDATE bugs but these can usually be solved by moving 
to the latest version of Valentina.

Also, it appears that myField may be a numeric field. If that is the 
case, then you should try saying myField=0 without quotes.


Best regards,
-Frank Schima