Product Logo

CNS Query

Query your databases without relationships.

Functions

CNSQuery_GetRecordData

NameCNSQuery_GetRecordData
Description

Note: This function is only available in FileMaker Pro 11 and above.

When using the new CNSQuery_ExecuteSQLEx function or the modified CNSQuery_FindRecords function, you can optionally specify that the results be stored internally in the plug-in. This function is used to retrieve those results. The first parameter is the Row or Record number of the result to look in. The second parameter is the Column or Field number of the result to look in.

Return TypeVaries
FormatCNSQuery_GetRecordData ( Row ; Column )
Required Parameters
Row
Column
Example
Example 1

Returns the value of the field in the first record of results in the 4th field.

CNSQuery_GetRecordData( 0 ; 4 )