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)
See also http://docwiki.embarcadero.com/VCL/en/SqlExpr.TSchemaType
Where also stUserNames is added (may be, that this would be good add
also in FPC)
And Delphi supports also (beside GetTableNames, GetProcedureNames,
GetFieldNames)
GetIndexNames
http://docwiki.embarcadero.com/VCL/XE2/en/SqlExpr.TSQLConnection.GetIndexNames
and others like GetPackageNames, GetProcedureParams (where
implementation across SQL-connectors may be problematic)
L.
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal