FireDAC.Comp.Client.TFDCustomCommand.SchemaName
| [–] Properties | |
|---|---|
| Type: property | |
| Visibility: public | |
| Source: FireDAC.Comp.Client.pas FireDAC.Comp.Client.hpp
| |
| Unit: FireDAC.Comp.Client | |
| Parent: TFDCustomCommand | |
Delphi
property SchemaName: String read FSchemaName write SetSchemaName;
C++
__property System::UnicodeString SchemaName = {read=FSchemaName, write=SetSchemaName};
Description
Identifies name of the schema for some kinds of the command.
The SchemaName identifies the name of the schema where the command object resides. The meaning depends on CommandKind and MetainfoKind:
- If CommandKind is in
[skStoredProc, skStoredProcWithCrs, skStoredProcNoCrs], then SchemaName specifies the name of the schema, where the procedure resides. - If MetainfoKind is not
mkNone, then SchemaName specifies the name of the schema, where the described object resides.
Example
//Example 1:
ADCommand1.SchemaName := 'SCOTT';
ADCommand1.CommandText.Text := 'PROC1';
ADCommand1.CommandKind := skStoredProc;
ADCommand1.Prepare;
ADCommand1.Params[0].AsInteger := 100;
ADCommand1.Params[1].AsString := 'Bill Gates';
ADCommand1.Execute;
//Example 2:
ADMetaInfoCommand1.SchemaName := 'ADDEMO';
ADMetaInfoCommand1.ObjectName := 'MY_TAB';
// or on Oracle just ADMetaInfoCommand1.ObjectName := 'ADDEMO.MY_TAB';
ADMetaInfoCommand1.MetaInfoKind := mkTableFields;
ADMetaInfoCommand1.Open;