Collapse All
AnyDAC
ContentsIndexHome
PreviousUpNext
TADCustomCommand.SchemaName Property
TADCustomCommand Class  TADCustomCommand Members  uADCompClient Namespace  Example 1  Example 2  public  See Also  Send Feedback

Identifies schema name for some of command kinds.

Group

public

Links
TADCustomCommand Class, TADCustomCommand Members, uADCompClient Namespace, Example 1, Example 2, public, See Also
Description

The SchemaName identifies the name of the schema where resides command object. The meaning depends on CommandKind and MetainfoKind:

  • If CommandKind in [skStoredProc, skStoredProcWithCrs, skStoredProcNoCrs], then SchemaName specifies the name of the schema, where resides the procedure.
  • If MetainfoKind is not mkNone, then SchemaName specifies the name of the schema, where resides the describing object.
Syntax
property SchemaName: String;
See Also
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;
What do you think about this topic? Send feedback!