On Monday 09 October 2006 9:33 am, Mansour wrote: > Fred, Thank you for helping: > What you said it true if I am editing a local DB, and not a remote MySQL > (at least in case). > as you can see from the screen shot I sent , there is nothing appears > when I choose Integert [Integer]. > on the other hand, let's say I have a filed called ID and and I 've set > it to Integer[Integer], there's nothing shows > up for auto increment, and if I click save, it goes auto matically to > Integer[ Int ] !!! > > I htought It might be the MySQL driver I am using, jdbc, but then I > tried all the availabe versions: > mysql-connector-java-3.0.17-ga-bin.jar > mysql-connector-java-3.1.13-bin.jar > mysql-connector-java-5.0.3-bin.jar > > and no change. Do you think it's a bug ?? > I have uninstalled OOo that comes with Fedora 4, and installed teh > latest RPM from openoffice.org, but no luck. > Then I decided to use unixODBC with MyODBC, and stuck there in a very > long process. Couldn't get them to work > and connect for some reason. Please let me know if you have any idea. > The funny part is that when I create tables through the wizard, I can > set auto increment. And yes I agree with about > using MySQL directly. I know it's faster, but not every body is > comfortable with it, I have few beginners that came from Microsoft world > and need them to use OO. If it's up to me, I would use direct SQL commands.
now that I know you have a terminal..(good for you not winblows). can you logon to the remote systems (where your db resides) and see what permissions you have on the db or the table in question.. perhaps you don't have ALTER privileges on the table... Since you indicate that you can set update if you are creating a new table.. I makes me wonder.. I would not be looking at the driver.. It is unlikely the culprate.. I have altered tables from inside OO however I had ALL privileges on the db and the table.. I owned it and it was on a remote server... If you don't have access to mysql is there an admin around that can look at the privilege table.. Typically I set the entire schema inside mysql then use OO for forms to read and write the db.. and it works really cool.. a nice very quick interface.. let us know.. Fred I just re-read you note.. it could be the privilege table has different permissions.. are you accessing with [EMAIL PROTECTED] with mypassword.. ? I think you need to find out privileges on the table.. > > Fred Moore wrote: > >On Sunday 08 October 2006 11:25 pm, Mansour wrote: > >>Re: [users] Re: Auto Increment in MySql > > > >I just took a screenshot and sent it directly.. you should get it.. Fred > > > >--------------------------------------------------------------------- > >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]
