Frank Schönheit - Sun Microsystems Germany wrote:
Hi Bob,I've got a fairly straightforward table in a MySQL 5.0 database that looks like this:CREATE TABLE invoice (ID INTEGER NOT NULL PRIMARY KEY, Customer INTEGER NOT NULL REFERENCES Customer, DateSubmitted DATE NOT NULL, Amount DECIMAL(10,2) NOT NULL, Notes VARCHAR(512) NULL)I'm having a number of problems with getting OpenOffice's Base to do the right thing with this table, but the most frustrating is that when I create a form based on the table, then go to insert a new row using that form, I get an error message complaining that the Amount column cannot be NULL, even though I'm entering a value for that column.Cannot reproduce with OOo 2.4, Windows XP, MySQL ODBC Driver 3.51, MySQL server 5.0.37 (running on a different machine). I suppose there's something in the way you setup your form - care to create a minimal example form, working on the table above?
I've attached an .odb with such a form.
Also, please mention the exact version of your ODBC driver.
See below.
A workaround you could try is to uncheck the "Form data input checks for required fields" in the "Edit / Database / Advanced Settings" dialog.
I'll test that and let you know if it works, but to reiterate -- I've already got a workaround (by moving the tables to PostgreSQL), so at this point I'm just trying to help track down a problem that might cause other OOo users problems (and, I suppose, possibly myself as well if I ever find myself in a situation where switching to another DBMS isn't an available options).
The other problems might be clues to what's causing the first problem, or they may be unrelated (by improbable coincidence). In the 2.3 OOo on Ubuntu, when I invoke the form wizard, the list of fields offered for inclusion on the form omits the Amount column (but the form wizard in OOo 2.0 on WinNT includes it). Also, both installations show the Amount column as "Text (fix) [ char ]" when I bring up Edit on the table definition,Cannot reproduce, with the same setup as above.
Let's start with these two bugs, as I encounter them during the process of creating the form in the wizard. I have upgraded OOo on the test Windows XP machine to the latest release version on the OOo web site (2.4.0). Whereas with the older (2.0) version of OOo on Windows I reported that the form wizard included the Amount column in the list of columns available for inclusion in the form, now that column is not present on that list in the newer version of OOo (though I can add the column to the form by hand after the form has been created, because the dropdown list for the data source in the column properties window includes the column again). And the OOo table property display still shows the wrong column type for the Amount colum. The ODBC driver is version 3.51.10 (dated 2004-10-25). The ODBC driver on the Linux machine is version number 3.51.11-6.1. The MySQL server is version "5.0.32-Debian_7etch5-log Debian etch distribution."
What additional information can I supply that would be helpful? -- Bob Kline http://www.rksystems.com mailto:[EMAIL PROTECTED]
oo24-base-test.odb
Description: application/vnd.sun.xml.base
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
