MySQL and StarOffice

2001-04-25 Thread Andrei B.
I know this is a bit StarOffice specific, still, I already know of a similarity of functionality with M$ Access when talking to MySQL server. (table is required to have a primary key for inserts to work). Maybe it is a similar answer this time too. Is it possible to create a form for inputing

Re: MySQL and StarOffice database via ODBC

2001-03-28 Thread Miguel Angel Solórzano
At 05:03 28/03/2001 -0800, Andrei B. wrote: Hi! If your form disables the new insert button, means that the recordset data source isn't up datable. I didn't use StarOffice yet, but the same behavior I found with MS Access and the only work around that I found was to define a column as primary key

MySQL and StarOffice database via ODBC

2001-03-28 Thread Andrei B.
Hi, I am trying to link a MySQL database (linux) with a StarOffice client on Windows, with MyODBC installed. I created the database, tables, set up select,update,delete,insert privileges on all tables in it from the host running StarOffice. I can list tables, can insert data into them via