Brucey,
Could you add a GetTableInfo(tableName:String) method to bah.database?
It should return a data structure containing the TQueryField's of the given table.
Every driver could overload the method and perform the proper query to retrieve the table information.
MySQL
SQLite
I don't know what the correct queries would be for the other databases.
Would this be possible?
Could you add a GetTableInfo(tableName:String) method to bah.database?
It should return a data structure containing the TQueryField's of the given table.
Every driver could overload the method and perform the proper query to retrieve the table information.
MySQL
DESCRIBE `tablename`
SQLite
pragma table_info(`tablename`)
I don't know what the correct queries would be for the other databases.
Would this be possible?