Not sure if anyone else has experienced this, but thought I would lay out my issue, and then the solution I found, in case anyone runs into it.
In the process of converting a desktop application from DBF to MySQL files, I had no problems exporting the data to a MySQL database, except for changing the primary keys to be integer instead of character, as others have said. I then created the active link tables in my database, ready to copy the forms to them. ( I decided to create new reports based on a SQLDataSource, instead of the ones based on the set, as they are much faster in my experience). Once this was done, I created a new set based on 5 tables, 3 of which were one-to-one links and two of which were one-to-many links.
When I attempted to create a new form connected to the set, I kept getting an error something like:
("Cannot find c:\mydirectory\.DDD").
I tried all kinds of things to see if I could get it to work, none of which worked. Finally, after several hours of treading water, and for no logical explanation that I could describe, I decided to try various combinations of tables in my set, and see what happens. What I discovered is that if I used only one-to-many links, I was able to create a form. If I used only one-to-one links, then I could also create a form. However, when both were there, I could NOT create the form, UNTIL I noticed the small checkbox labeled "Optimize Set" in the Set Editor. When I unchecked that box, for the one-to-one linked tables, I found that I could then include ALL the tables and from then on had no trouble creating a form against that set.
I am sure there are deeper issues here that I don't understand, but I thought it would be good to post this info, just in case anyone else has the same issue.
If anyone can explain what is going on and why it makes a difference, I would be interested in knowing more. A search on the forum for "Optimize Set" did not show anything.
By the way, I am using A5v10.5 .
Gordon
In the process of converting a desktop application from DBF to MySQL files, I had no problems exporting the data to a MySQL database, except for changing the primary keys to be integer instead of character, as others have said. I then created the active link tables in my database, ready to copy the forms to them. ( I decided to create new reports based on a SQLDataSource, instead of the ones based on the set, as they are much faster in my experience). Once this was done, I created a new set based on 5 tables, 3 of which were one-to-one links and two of which were one-to-many links.
When I attempted to create a new form connected to the set, I kept getting an error something like:
("Cannot find c:\mydirectory\.DDD").
I tried all kinds of things to see if I could get it to work, none of which worked. Finally, after several hours of treading water, and for no logical explanation that I could describe, I decided to try various combinations of tables in my set, and see what happens. What I discovered is that if I used only one-to-many links, I was able to create a form. If I used only one-to-one links, then I could also create a form. However, when both were there, I could NOT create the form, UNTIL I noticed the small checkbox labeled "Optimize Set" in the Set Editor. When I unchecked that box, for the one-to-one linked tables, I found that I could then include ALL the tables and from then on had no trouble creating a form against that set.
I am sure there are deeper issues here that I don't understand, but I thought it would be good to post this info, just in case anyone else has the same issue.
If anyone can explain what is going on and why it makes a difference, I would be interested in knowing more. A search on the forum for "Optimize Set" did not show anything.
By the way, I am using A5v10.5 .
Gordon