Refactoring Delphi/Mysql project.

Standard VCL, interface don't have to be so nice but code very stable and well written, easy to understand and modify. Try to keep as little code as possible in the events, and the rest in separate procedures and functions. (1) Make a Delphi project that log into a Mysql server and displays all tables in a database. Let the user select a table. Then select a .dpr file, scans all the .pas / .dfm files in that project and lists all clientdatasets. (2) Let the user choose what Mysql table that is the "master", select what clientdataset is "master" and what clientdatasets thats is "klonedcursor" (cant write klone the with a c, freelancer blocks me) (3) Create a list of above with as many relations that is necessary. Put the data into a clientdataset and save it to a file. (4) Don't touch calculated or aggregate fields. (5) Create a list of all relations with a cds (clientdataset) connected to a Dbgrid (6) Let the user edit, delete and add fields, and fieldtypes in a Delphi VCL user inteface. Synk the edits into the mysq and the client datasets dfm files. (7) Project must handle several tables/relations in a database, not only one. (8) On every start of the program, control if there is anything out of sync, ask the user of how to correct and correct it (like filenames not same or same but of different types). Make sure You understand the project before You make a bid, ask for clarifications if something is unclear. I will assist a bit during the project, but not in every step all the time. Additional. The .pas files that holds the fieldnames of the cds must also be synced and so must the field name in mydac and unidac in the .pas files, and so must all database bindings to the user interface. Also, the program should work with or without clientdatasets, with or without mysql. There are three possible configurations: (1) Mysql-CDS (2) Only Mysql (3) Only CDS There is also not always that the CDS is in the same VCL form as the visual objects using it, it can also be in a another form like in a datamodule or in another delphi form. The user shall select what forms and data modules that are linked. When an edit if fields is done, the program should run as before without need for any manual editing. All code and rights will be my property.