In recent weeks I've posted a few things to this list try to get help for several issues I have with a MySQL db and OOo m110+. I have now discovered the root of all my problems ... unsigned.
This simple little option has caused havoc for me testing m110+. Here are a few symptoms:
* A primary key was a simple counter, set to int(6) with unsigned. Select "MAX(Row)" would simply give back NULL.
* One db has several fields set to int(1) and unsigned and are controlled by tick boxes on a form. Changing the tick box and saving would fail and you'd get an error message saying your SQL was invalid.
* Creating a new record from scratch with an unsigned field to be updated would fail (invalid message too).
The simple work around is to remove Unsigned from all these fields (ironically I only added Unsigned to them as in an early 1.1 release the tick boxes were setting the field to be either -1 or 0 which would give blank or a grey-ed out tick).
If anyone's interested the IZ number is 51846 http://qa.openoffice.org/issues/show_bug.cgi?id=51846 P h i l l --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
