Domino - r6 on machine running linuxMysql - on another machine running on linux
Current Status:
Domino works
Mysql works
unixODBC works
unixODBC on domino server connects to mysql machine.
isql on domino server connects.
domino decs and dcr connect to the mysql . No problem. All works.
On the MySQL server I have a very simple table with the following fields:
userID int not null auto_increment primary key
userName char(30).
I created a form using the domino designer (R6) and setup a data connection using DCR to the mysql server.
The form has two fields:
NotesID - number (float) (hidden field)
NotesName - text (notes char or what ever)
I set the NotesID field as external data source type KEY
I set the NotesName field as external data source type FIELD.
I updated notes with all the current values in my MySQL table. It worked. I can update the userName field in MySQL.
My Problem:
When entering data into the Notes form, the new data is added to the MySQL table. MySQL creates a uniquie userID because it is auto_increment and the userName is added. However Notes is not updating the NotesID KEY because it is not reading the insert back from MySQL so I cannot open the form in Notes to edit. I just get an error because the keys do not match. From logic this is correct. In Notes the NotesID field is hidden and has no value so Notes probably creates a local KEY with nothing in it. It passes the data to MySQL which then creates incremented number. But is it not passing it back. How can I acheive this or do I have do create PRIMARY KEYS by hand and remember the next incrementing number. Currently I have to deactivate the Notes DCR. Update the Notes locally stored data and restart the DCR activity before I can continue to edit the data stored on MySQL.
Note: I only want to use Notes to enter the data. I do not want to replicate, do backend to Notes updates or anything special. I used the same unixODBC with OpenOffice and it could handle the auto_increments. Any ideas???