https://bugs.documentfoundation.org/show_bug.cgi?id=156238
Rafael Lima <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected], | |[email protected] --- Comment #3 from Rafael Lima <[email protected]> --- Hi, I have just run your script and it worked. Here's what I got as result: ------------< Python Shell >------------ >>> test1() /home/rafael/Downloads/test.odb Connection to Base successful query ='CREATE TABLE "tickers" ("id" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY, "ticker" VARCHAR(50) NOT NULL, "currency" VARCHAR(10) NOT NULL)' Query executed successfully query ='INSERT INTO "tickers" ("ticker", "currency") VALUES (\'a\', \'aa\')' Query executed successfully query ='SELECT "id" FROM "tickers" WHERE "ticker" = \'a\' ' Query executed successfully execute_read_query(connection, query) =((0,),) query ='SELECT "id" FROM "tickers" WHERE "ticker" = \'b\' ' Query executed successfully execute_read_query(connection, query) =() ------------ I simply opened the file, entered APSO Python sheel and ran "test1()". Note that if you run the script for a second time, it will crash because the ODB file will have been created. @JPL any input in this issue? -- You are receiving this mail because: You are the assignee for the bug.
