Problems with UPDATE #1666

[Claudius Sailer]

Hi,

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

thanks


Claudius

-- 
iMac CD 2GHz / MacOS X 10.4de / RB 2006r2/ Valentina 2.3
Homepage    http://www.ClaSai.de
iChat        ryhoruk
RealBasic ListBoxes: [ I feel the need...the need for speed!!! ]