FireDAC.Comp.Client.TFDCustomCommand.SchemaName

From RAD Studio API Documentation
Jump to: navigation, search

Delphi

property SchemaName: String read FSchemaName write SetSchemaName;

C++

__property System::UnicodeString SchemaName = {read=FSchemaName, write=SetSchemaName};

Properties

Type Visibility Source Unit Parent
property public
FireDAC.Comp.Client.pas
FireDAC.Comp.Client.hpp
FireDAC.Comp.Client TFDCustomCommand

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;

See Also