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.SetParamTypesValues

Sets all parameters for a query in one call.

Parameters

Parameter	Description	Example
Command	The command reference number gained with SQL.NewCommand.	$Command
Type	Pass one type parameter for each value. Type can be Default, Null, Unknown, Integer, Double, Text, Container, Boolean, Short, UShort, Long, ULong, Date, Time or TimeStamp.	"Integer"
Value	Pass one parameter for each parameter.	"Hello"

Result

Returns OK or error.

Description

Examples

Set 4 parameters:

MBS( "SQL.SetParamTypesValues"; $Command; "Text"; "Bob"; "Text"; "Miller"; "Date"; $BirthDay; "BLOB"; MyTable::PersonPicture )

Export row

# create command
Set Variable [$Command; Value:MBS("SQL.NewCommand"; $Connection; "INSERT INTO 'Test' (FirstName, LastName, Birthday, NumberOfOrders, TotalSales) VALUES (:1,:2,:3,:4,:5)")]
# fill all parameters
Set Variable [$result; Value:MBS("SQL.SetParamTypesValues"; $Command; "Text"; SQLite fun::FirstName; "Text"; SQLite fun::LastName; "Date"; SQLite fun::Birthday; "Integer"; SQLite fun::NumberOfOrders; "Double"; SQLite fun::TotalSales)]
# Run it
Set Variable [$result; Value:MBS("SQL.Execute"; $Command)]
# Cleanup
Set Variable [$result2; Value:MBS("SQL.Commit"; $Connection)]
Set Variable [$result2; Value:MBS("SQL.FreeCommand"; $Command)]

See also

• FM.NULL
• SQL.Commit
• SQL.Execute
• SQL.FreeCommand
• SQL.NewCommand
• SQL.SetParamValue
• SQL.SetParamValues

Created 21st April 2015, last changed 21st April 2015

SQL.SetParamOption   -   SQL.SetParamUnknown

Feedback: Report problem or ask question.