[Gambas-user] Bug in Gambas mySQL & DELETE &

[HMB]

Byside the technical syntax problem, i have to say that this is not a good 
idea for handling, specialy deleting datarecords with this weak key. 'name' 
can allways have a dublette and you delete _every_ record matching to this 
sql-request. And even with a select you can get more than one record, but the 
program didn't handle this, so the user can never see the records behind the 
first one. A strong key is a unique one and can here maybe 'name' and 
'inserted_at' which is a timestamp field and filled when this record is 
inserted. (but even timestamp can be not unique ;) )

But as i think this is only an example and not used for a 'real' application, 
it doesn't matter...

Am Sonntag, 3. April 2005 01:09 schrieb LB Audio:
> Problem in mySQL
>
> Ex:
> ....Exec("Delete from table1 where name= 'My Company & Brothers' ")
>
> Problem in string &.