Paul McNett wrote: > Ricardo Aráoz wrote: >> I've got an example here (after each query there is an output and a >> comment) : > > Ricardo, I was surprised that the field was 'menu.Name' instead of > 'Name'. I started a wiki page that has sample code to attempt to > recreate your structure and run some tests of the output: > > http://trac.dabodev.com/wiki/RicardoSQLiteOddity > > You can log in and edit that page adding your tests. I always use the > '<tablename>.<fieldname> as <aliasname>' syntax, so I haven't run into > this problem before. > > Paul > Hi Paul, I'm a bit dumb. I registered and then went to the page, but couldn't find a way to edit it (I'll have to take the time and learn/check doc). Anyway, not enough time right now so I'm sending you here a dump of the tables. Notice that in my tests I'm not using sqlite directly but through a dabo cursor. ------------------------------------------------------------------------------------------------- BEGIN TRANSACTION; CREATE TABLE "Menu" ( "MenuId" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "Name" INTEGER NOT NULL, "Hidden" INTEGER NOT NULL, "Disabled" INTEGER NOT NULL ); INSERT INTO "Menu" VALUES(1,'root',1,1); INSERT INTO "Menu" VALUES(2,'Hijo',0,0); INSERT INTO "Menu" VALUES(3,'OtroHijo',0,0); INSERT INTO "Menu" VALUES(4,'Hijo-1',0,0); INSERT INTO "Menu" VALUES(5,'Hijo-1-1',0,0); INSERT INTO "Menu" VALUES(6,'Hijo-1-2',0,0); INSERT INTO "Menu" VALUES(7,'OtroHijo-1',0,0); INSERT INTO "Menu" VALUES(8,'Hijo-2',0,0); DELETE FROM sqlite_sequence; INSERT INTO "sqlite_sequence" VALUES('Menu',8); INSERT INTO "sqlite_sequence" VALUES('MenuOpt',2); CREATE TABLE "Path" ( "Id" INTEGER NOT NULL, "AncestorId" INTEGER NOT NULL ); INSERT INTO "Path" VALUES(2,1); INSERT INTO "Path" VALUES(3,1); INSERT INTO "Path" VALUES(4,2); INSERT INTO "Path" VALUES(4,1); INSERT INTO "Path" VALUES(5,4); INSERT INTO "Path" VALUES(5,2); INSERT INTO "Path" VALUES(5,1); INSERT INTO "Path" VALUES(6,4); INSERT INTO "Path" VALUES(6,2); INSERT INTO "Path" VALUES(6,1); INSERT INTO "Path" VALUES(7,3); INSERT INTO "Path" VALUES(7,1); INSERT INTO "Path" VALUES(8,2); INSERT INTO "Path" VALUES(8,1); CREATE TABLE "MenuOpt" ( "MenuOptId" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "MenuId" INTEGER NOT NULL, "Name" TEXT NOT NULL, "Hidden" INTEGER NOT NULL DEFAULT (0), "Disabled" INTEGER NOT NULL DEFAULT (0), "OutDir" TEXT NOT NULL DEFAULT ('.\'), "Execute" TEXT, "Help" TEXT, "Obs" TEXT, "Order" INTEGER NOT NULL DEFAULT (999999) ); INSERT INTO "MenuOpt" VALUES(1,4,'Alguna Opcion',0,0,'.\',NULL,'Help para alguna opcion',NULL,999999); INSERT INTO "MenuOpt" VALUES(2,4,'Otra Opción',0,0,'.\',NULL,'help para Otra Opcion',NULL,999999); COMMIT; -------------------------------------------------------------------------------------------------
_______________________________________________ Post Messages to: Dabo-users@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/49af1b33.80...@gmail.com
