--- Peter Jensen <[EMAIL PROTECTED]> escribió:
> Hello,
>
> I hope that this is the right place for this Question / I'm allowed
> to ask
> here.
>
> This Code should update a small MySQL-Table:
> http://web6.vs251197.vserver.de/u_mysql.pas
>
> If i change an entry, then the whole column in the DB is updated to
> this
> value, not only the row/column where i changed the value in the
> Grid.
>
> Example :
> Before Changing:
> http://web6.vs251197.vserver.de/before_change_adm.sql
>
> Now I change the Row No 1/ ColumnNo1 from "aaa" to "kkk" and leave
> the prog.
> After restarting the prog, thie ist the result
>
> After Changing:
> http://web6.vs251197.vserver.de/after_change_adm.sql
>
> Why are all entries of column 1 changed, not only the entry of
> RowNo 1?
> Any Help ??
>
> P. Jensen
>
> _________________________________________________________________
> To unsubscribe: mail [EMAIL PROTECTED] with
> "unsubscribe" as the Subject
> archives at http://www.lazarus.freepascal.org/mailarchives
>
Probably SQLDB is doing something like update xxx set country='kkkk'
where country='aaaa';
As there seems to be no way to distiguish one record from other, I
guess it would be best if you can add a unique key field to your
table.
Jesus Reyes A.
____________________________________________________________________________________
¡Sé un mejor fotógrafo!
Perfecciona tu técnica y encuentra las mejores fotos.
http://mx.yahoo.com/promos/mejorfotografo.html
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
