Problem with sql statement

[Ruslan Zasukhin]

on 10/14/03 17:37, SoftIl at softil at onlinehome.de wrote:

Hi Carsten,

> Hi,
> I get an exception ("Expected '='" or in Valentina Studio: kernel error 625)
> if I try the following sql statement:
> 
> "UPDATE arbeitsverhaeltnisse SET bezeichnung = 'sonstiges',kennzeichen =
> '1',key = '2', WHERE (record_id = 'b79191df-44d0-4958-b97c-fbcdffbb')"
> 
> 
> Fields param:
> 
> bezeichnung = VarChar/50
> kennzeichen = Byte
> key         = UShort
> record_id   = string/32
> 
> Where is the mistake?

If kennzeichen is byte then you do not need wrap by quotes

    kennzeichen = 1

The same for key.

Check if this help

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------