To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67078 Issue #|67078 Summary|Using Base with PostgreSQL - listbox does not work pro |perly Component|Database access Version|OOo 2.0.2 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|canita
------- Additional comments from [EMAIL PROTECTED] Thu Jul 6 07:18:06 -0700 2006 ------- Using: OOo 2.0.2, Ubuntu Dapper, PostgreSQL 8.0 (8.0.7-2build1) and SDBC driver 0.7.2 I was testing OOo Base with different databases and drivers with this tutorial: http://www.oooforum.org/forum/viewtopic.phtml?t=25060 At the point when I have to put a listbox on the Employee form for the Department, the query does not seem to work. The SQL query is good, because it works through HSQLDB and I did everything the same way as with the native database engine, but it does not work. If I have no records in table Employee, the listbox shows <Autofield> and nothing else. When I have 1 Employee put in manually in the table, then I can change the Employees department through the form, but at the second row, there is <Autofield> again. Here is the postgres-log regarding fields Department and DepartmentID: 2006-07-06 16:08:27 CEST : 9987, idle - LOG: statement: SELECT * FROM "public"."Employee" WHERE 0 = 1 2006-07-06 16:08:27 CEST : 9988, idle - LOG: statement: SELECT * FROM "public"."Employee" WHERE 0 = 1 2006-07-06 16:08:27 CEST : 9989, idle - LOG: statement: SELECT * FROM "public"."Employee" 2006-07-06 16:08:27 CEST : 9990, idle - LOG: statement: SELECT * FROM "public"."Employee" WHERE 0 = 1 2006-07-06 16:08:27 CEST : 9991, idle - LOG: statement: SELECT "Department", "DepartmentID" FROM "public"."Department" WHERE 0 = 1 2006-07-06 16:08:27 CEST : 9992, idle - LOG: statement: SELECT "Department", "DepartmentID" FROM "public"."Department" 2006-07-06 16:08:27 CEST : 9993, idle - LOG: statement: SELECT "Department", "DepartmentID" FROM "public"."Department" WHERE 0 = 1 2006-07-06 16:08:27 CEST : 9994, idle - LOG: statement: SELECT "Department", "DepartmentID" FROM "public"."Department" WHERE "public"."Department"."DepartmentID" = '1' 2006-07-06 16:08:28 CEST : 9995, idle - LOG: statement: SELECT "Department", "DepartmentID" FROM "public"."Department" WHERE "public"."Department"."DepartmentID" = '2' 2006-07-06 16:08:28 CEST : 9996, idle - LOG: statement: SELECT "Department", "DepartmentID" FROM "public"."Department" WHERE "public"."Department"."DepartmentID" = '3' 2006-07-06 16:08:28 CEST : 9997, idle - LOG: statement: SELECT "Department", "DepartmentID" FROM "public"."Department" WHERE "public"."Department"."DepartmentID" = '2' 2006-07-06 16:08:28 CEST : 9998, idle - LOG: statement: SELECT "Department", "DepartmentID" FROM "public"."Department" WHERE "public"."Department"."DepartmentID" = '3' 2006-07-06 16:08:28 CEST : 9999, idle - LOG: statement: SELECT "Department", "DepartmentID" FROM "public"."Department" WHERE "public"."Department"."DepartmentID" = '4' 2006-07-06 16:08:28 CEST : 10000, idle - LOG: statement: SELECT "Department", "DepartmentID" FROM "public"."Department" WHERE "public"."Department"."DepartmentID" = '3' 2006-07-06 16:08:28 CEST : 10001, idle - LOG: statement: SELECT "Department", "DepartmentID" FROM "public"."Department" WHERE "public"."Department"."DepartmentID" = '4' 2006-07-06 16:08:28 CEST : 10002, idle - LOG: statement: SELECT "Department", "DepartmentID" FROM "public"."Department" WHERE "public"."Department"."DepartmentID" = '4' 2006-07-06 16:08:28 CEST : 10003, idle - LOG: statement: SELECT "Department", "DepartmentID" FROM "public"."Department" WHERE "public"."Department"."DepartmentID" = '4' I do not know much about databases, but it is weird that the cycle steps forward and backward. Could you please have a look at it? Thanx, Anita --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
