Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 9.3   9.4   9.5   10.0   10.1   10.2   10.3   10.4   10.5   10.6    Statistic    FMM    Blog  

SQL.CommandText

Gets the command text associated with the command object.

Component Version macOS Windows Linux Server FileMaker iOS SDK
SQL 2.6 Yes Yes Yes Yes Yes
MBS( "SQL.CommandText"; Command )   More

Parameters

Parameter Description Example
Command The command reference number gained with SQL.NewCommand. $Command

Result

The command text or error message.

Description

Gets the command text associated with the command object.

Examples

Query command:

Set Variable [ $con ; Value: MBS( "SQL.NewConnection" ) ]
Set Variable [ $cmd ; Value: MBS( "SQL.NewCommand"; $con; "SELECT * FROM Table" ) ]
Show Custom Dialog [ MBS( "SQL.CommandText"; $cmd ) ]

See also

Created 18th August 2014, last changed 25th November 2017


SQL.Close   -   SQL.CommandType

Feedback: Report problem or ask question.




Links
MBS FileMaker tutorial videos

Start Chat