$sqlCurrentResultSet

Sets the name of the sql result set of the last executed sql select statement.

Syntax	$sqlCurrentResultSet{result_set_name}
Documentation	Sets the name of the sql result set of the last executed sql select statement: Parameters: result_set_name, the name of the result set of the last executed sql select statement. The name of the result set defaults to the value 'Default'.
Examples
$// creates table test, test1 $sql {create table test (ID varchar, lastName varchar, name varchar)} $sql {create table test1 (name varchar, content varchar)} $// inserts values into table test, test1 $sql {insert into test values ('1', 'Smith', 'John')} $sql {insert into test values ('2', 'Hopkins', 'Jack')} $sql {insert into test values ('3', 'Gore', 'Mary')} $sql {insert into test1 values ('Mary', 'cinema 10pm')} $sql {insert into test1 values ('Jack', 'meeting 9am')} $// sets the sql-resultset to the name outside for table test $sqlCurrentResultSet{outside} $// selects all from table, query transaction $sqlQuery {select * from test} $// loops parameter 2 for each record $while {$sqlResultSet{next}} { // outputs cell 3 $set{name}{$sqlResultSet{getCell}{3}} $get{name} $// sets the sql-resultset to the name inside for table test1 $sqlCurrentResultSet{inside} $// selects from table where name=variable, query transaction $sqlQuery{select * from test1 where name='$get{name}'} $// while next record where name=variable, output cell 2 $while{$sqlResultSet{next}} { - $sqlResultSet{getCell}{2} } $// sets the sql-resultset to the name outside $sqlCurrentResultSet{outside} } Result: sets sqlCurrentResultSet "outside" for table "test", and sqlCurrentResultSet "inside" for table "test1" returns cell 3 of table "test" and cell 2 of table "test1" of the records where name = cell 3 ot table "test": Jack - meeting 9am Mary - cinema 10pm
Group	SQL
Minimum required transaction-mode:	NONE
Required scripting permission of the developer	PERMISSION_FL_EXPERT
Minimum parameters	0
Maximum parameters	1