Problems with UPDATE #1666

[Ruslan Zasukhin]

On 6/24/06 9:35 AM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

Hi Claudius, 

> Deleted is a Boolean. When I try following SQLs my application and
> viSQL crashes everytime without any error message.
> 
> Does anybody has same problem?
> 
> Update Buchungen SET Deleted='1' where RecID=1
> Update Buchungen SET Deleted='1' where RecID='1'
> Update Buchungen SET Deleted=1 where RecID=1
> Update Buchungen SET Deleted=1 where RecID='1'

 
> is it neccessary to use
> 
> myDatabase.Table.RecID=1
> myDatabase.Table.Deleted=true
> myDatabase.Table.UpdateRecord()
 
> it seems this works

1) our SQL parser exactly do not support for DB.TABLE.FIELD.
    but only TABLE.FIELD

2) your form also should work but without single quotes

      Update Buchungen SET Deleted=1 where RecID=1

I see your report in Mantis. We will test it.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]