We have need to extract the info out of a proprietry database and transfer it to MySQL. Because the are quite a number of tables we want to dynamically extract the field names from the existing base(they are stored inside the file) and allocate those same names to the create stage and then loading the data in.
Things that I have read all suggest that you need to hand code the table and field names in. You can't use %s except for VALUES. Is it a matter of having to compile a string with all those parameters in first within the python code and then pass that to "loading function? Is this best done within dabo or at a python level? Once we have it in MySQL it is all dabo thereafter. -- Fraser Burns _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
