[Gambas-user] Primary Key missing?

[Jorge Carrión]

Try with sqliteman (Ubuntu repositories). It's a graphic environment good
enough for that operations...

For edit a record in terminal you have to use alter table command...

Good Luck.

2010/11/25 tobias <tobiasboe1 at ...20...>

> 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
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>