On 17-4-2012 10:41, michael.vancann...@wisa.be wrote: > On Tue, 17 Apr 2012, Reinier Olislagers wrote: >> In sqldb, this: >> type TSchemaType = (stNoSchema, stTables, stSysTables, stProcedures, >> stColumns, stProcedureParams, stIndexes, stPackages); >> is used in the GetSchemaInfoSQL function: >> Does anybody know what stIndexes, stProcedureParams and stPackages >> should return and when they would be used? > > stIndexes: get a list of indexes from a table. > stPRocedureParams: get the parameters of a stored procedure > stPackages: list packages (Oracle and Firebird)
Thanks Michael. Function signature is GetSchemaInfoSQL(SchemaType : TSchemaType; SchemaObjectName, SchemaPattern : string) : string; ... assuming SchemaObjectName would be used similar to the existing code and would specify table name (stIndexes)/stored proc name (stProcedureParams)? I believe package names are unique within dbs in Oracle (don't know Firebird, IIRC, that's planned for the upcoming 3.0, right?), so no parameters required for stPackages? SchemaPattern doesn't seem to be used; perhaps meant as some kind of filter to limit the results? I'll implement at least stIndexes for MS SQL Server, perhaps ProcedureParams as well.. Later on the same for Sybase, perhaps Firebird. Thanks, Reinier _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
