SQLExecute failures

[Stan Busk]

Hi,

V4RB 1.11 from September 29. I have downloaded the current one from the 
Paradigma site. also labeled as 1.11 but December 19. I have tried and 
now it works. It is not the first time a version includes fixes but the 
version number is not changed and the release note not updated either, 
RUSLAN! :)

Thanks Trevor and Franks for your hints,

Stan


> 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
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
>