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

[Charlie Reinl]

>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... 
 
Salut, 
 
for real unique keys make it like M$ use GUID or in Linux-spoken 
'uuidgen' (you need the package) 
I attached you my version I use for that. 
 
Amicalment 
Charlie  
 
> 
>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 &. 
> 
> 
> 
> 
>------------------------------------------------------- 
>SF email is sponsored by - The IT Product Guide 
>Read honest & candid reviews on hundreds of IT Products from real users. 
>Discover which products truly live up to the hype. Start reading now. 
>http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click 
>_______________________________________________ 
>Gambas-user mailing list 
>Gambas-user at lists.sourceforge.net 
>https://lists.sourceforge.net/lists/listinfo/gambas-user 
> 
> 
 
* Gesendet mit / Sent by: FEN-Webmail * http://www.fen-net.de *
-------------- next part --------------
A non-text attachment was scrubbed...
Name: gauuid-0.0.3.tar.gz
Type: application/x-tgz
Size: 1668 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20050404/bd70973b/attachment.bin>