I think the best way is to have a session polling the paradox system for changes and [via ODBC] mirror the changes to the mysql database. The problem i'm having is the none of the Paradox tables are timestamped, so...
Is there a way to interrogate a Paradox table to find recent changes without having to create a timestamp on each table?
I have created a test PDX V7 Table with a timestamp field on it, when changing data in the table the timestamp didn't show any value, does this have to be stamped within the code, or does the system automatically do it? [if so then why didn't it show up?]
Has anyone else done something like this?
Thanks for any help.