FCL-DB: New Method to List Db Objects with Schema Name
Original Reporter info from Mantis: dgaspary @dgaspary
-
Reporter name: Daniel Gaspary
Original Reporter info from Mantis: dgaspary @dgaspary
- Reporter name: Daniel Gaspary
Description:
The Patch creates the Following (public) method:
function GetObjectNames(ASchemaType: TSchemaType): TSqlObjectIdentifierList; virtual; //(Really needed / is useful to be virtual?)
The new type TSqlObjectIdentifier is a TCollectionItem with SchemaName and ObjectName properties.
The method is a modified copy of GetDBInfo. (Maybe a new common method could be created to avoid duplication of code).
I have created also an array to describe the "object" names of each TSchemaType: TSchemaObjectNames.
The items of this array could be replace wherever today we have "table_name", "column_name", etc..
This happens in all units with classes that inherit from TSqlConnection.
Additional information:
http://lists.freepascal.org/pipermail/fpc-pascal/2014-June/042119.html
Mantis conversion info:
- Mantis ID: 26254
- Version: 2.7.1
- Fixed in version: 3.1.1
- Fixed in revision: 33127 (#9de8ad93)
- Target version: 3.0.2