hello,
prooving my sqlite code, i have several buttons on a form, whose subs
should do the same work in different ways (one just using Exec() method,
the other does all work with the gambas objects (editing fields etc.)).
after this code:
Button2_Click:
DIM hResult AS Result
hConnection.Exec("create table test(id integer primary key, name
varchar(10));")
hConnection.Exec("insert into test(name) values(\"Aaron\");")
hConnection.Exec("insert into test(name) values('Zacharias');")
'1|Aaron
'2|Zacharias
i have another button which should edit this table:
DIM hResult AS Result
hResult = hConnection.Edit("test", "name=&1", "Aaron")
hResult["name"] = "Adam"
hResult.Update()
but in the line where the Edit()-function is used, i get the error that
there is no primary key in my table but didn't i specify one creating
the table?
by the way... i found that i wasn't able to even find a command to edit
a record in terminal; i wanted to proof if the sqlite3 program with the
same commands would tell me the same...
regards,
tobi
------------------------------------------------------------------------------
Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
Tap into the largest installed PC base & get more eyes on your game by
optimizing for Intel(R) Graphics Technology. Get started today with the
Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs.
http://p.sf.net/sfu/intelisp-dev2dev
_______________________________________________
Gambas-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/gambas-user
