This is more on guidance rather than a solution. I'm using MySql with many tables with no SQL Linking. Most data was referenced from data in tables. Over time, some of my data has been scrambled and I have a few records in child databases with no parents.
I downloaded dbForge and started looking at linking the tables with parent child relationships to try and fix this. Once I started running my app, I got crashes all over the place. Not in edit mode. In the past, I had grids on the main page and all editing was done on child forms. On going into the form, I set edit on and on exiting, posted the data. All worked. Now with relationships on as defined in the database diagram, the app is crashing. Without too much investigation at this point, it looks like background updates are happening at times when tables are not in edit mode. It gives me an error on just returning to the parent form and not on a database access line. Short of always having the tables in edit mode, I have 2 options, leave off all external SQL table relationships and do more coding in Delphi to check for data integrity or use relationships and find a better way of making it all work. Any suggestions ? Thanks Wallace. 03 3237449 _______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: [email protected] Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to [email protected] with Subject: unsubscribe
