Problems with UPDATE #1666

[Ruslan Zasukhin]

On 6/27/06 7:03 AM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

Hi Claudius,

>>>>> 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.
>> 
>> Wait, it seems you show REALBasic code, but not SQL code, right ?
> 
> yes. RB Code...

In RB code this will work of course.
I have told about SQL.

Btw, TIP: 
    in hot loops (if any) do not use such long chains of objects.


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