bah.database feature request

BlitzMax Modules Forums/Brucey's Modules/bah.database feature request

The forum is locked. These are the original blitzbasic.com forums, kept so they can still be read. No new topics, replies or edits can be made here. To join in, head over to the Blitz3D+ forums.

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
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?