[Gambas-user] Primary Key missing?

[Caveat]

>    hConnection.Exec("create table test(id integer primary key, name
> varchar(10));")

> didn't i specify one creating
> the table?

Yes, you did indeed.  You specified id. :-)

So I'm wondering whether your Edit might not work better if you were to
try:

    hResult = hConnection.Edit("test", "id=&1", 1)
    hResult["name"] = "Adam"
    hResult.Update
    hResult.Commit


Regards,
Caveat