Search the Gambas Mailinglists

... MySQL I found 13.2.3 CREATE DATABASE Syntax CREATE DATABASE [IF NOT EXISTS] db_name [create_specification [, create_specification] ...] create_specification: [DEFAULT] CHARACTER SET charset_name | [DEFAULT] COLLATE collation_name and a example with create...

... with the > > same commands would tell me the same... > Use sqlite, specify the name of the database on the command line... $ sqlite mytest.db SQLite version ... ".help" for instructions sqlite> create table test(id integer primary key, name text); sqlite> insert into test (id, name) values (1, "Aaron"); sqlite>...

... is the faulty query, and the corrected one, I mention in the thread: > > > --=|Set the inherits key in Classes. (Faulty)|=-- > > UPDATE wk_classes > SET inherits_id = > ( > SELECT A.id > FROM wk_classes AS A > WHERE A.name = wk_classes.inherits_name > ) > ; > --=|Set the inherits key in...

... it is possible to close the dialog and have both printer.file > >> and printer.name set. > >> > >> === correction === > >> it is bugged. > >> I made a simple ... where setup() is called and just after return > >> the values of .file and .name are printed. It is so easy to get them > >> both set... > >> > >> -- BUT...

... set GB[%s] mysql[%s]\n", > > > GB.System.Charset(), mysql_character_set_name(conn)); >>> > > > before and after string > > > <<< set_character_set(db); >>>. > > > Compiled only this driver, copied it to /usr/lib/gambas2. Run my > > > program. Result: > > > <<< Character set GB[UTF-8] mysql[latin1] > > > Character set GB[UTF-8] mysql[latin1] >>> > >...

... way, postgresql "doesn't really care" whether the table has a primary key set or not. Nor does it care whether a delete or an update query uses a unique row ... it? Well, not at all really. It relies on the WHERE clause to identify the set of rows to be operated on and that is all. If such a clause identifies...

... Under postgresql > it is the execution of one SQL command: > UPDATE horse SET name='Cherry Zontop', namechanged=TRUE, oldname='Lemon > Liniment' WHERE name='Lemon Liniment'; > > * I have simplified the story a fair bit, there are around 18 underlying > tables that have the horse name as the foreign key or as part of the > foreign key. > > postgres, because it...

... Either I missed it, either > it's a PolicyKit thing. > Anyway, you can set the DBus.Name property before doing any other DBus call, to choose the name you want. Regards, -- Benoît Minisini Previous message (by thread): [Gambas-user] Dbus unique name seems incorrect Next message (by thread): [Gambas-user] Dbus unique name...

... Either I missed it, either >> it's a PolicyKit thing. >> > > Anyway, you can set the DBus.Name property before doing any other DBus > call, to choose the name you want. > > Regards, > > -- > Benoît Minisini > > ----[ ... ]---- Previous message (by thread): [Gambas-user] Dbus unique name seems incorrect Next message (by thread): [Gambas-user] Dbus unique name...

... Under postgresql > it is the execution of one SQL command: > UPDATE horse SET name='Cherry Zontop', namechanged=TRUE, oldname='Lemon > Liniment' WHERE name='Lemon Liniment'; > > * I have simplified the story a fair bit, there are around 18 underlying > tables that have the horse name as the foreign key or as part of the > foreign key. > > postgres, because it...