Problems with UPDATE #1666

[Claudius Sailer]

Hi Ruslan,

Am 26.06.2006 um 08:08 schrieb Ruslan Zasukhin:

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

*hmmm* I use always for Insert and complete Update of one record the  
way.

myDatase.Table.Field.value=XXXX
myDatabase.Table.InserRecord or UpdateRecord. And it worked always,  
but without SQLExecute or whatever.


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

thanks a lot. V4RB2.1 it worked ... V4RB2.3 it is broken...

bye


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!!! ]