Interested in improving this site? Please check the To Do page.
mysql.getFieldNames
Retrieve a list of field names from the specified table
Syntax
mysql.getFieldNames(dbid, tableName)
Params
A database connection ID
Returns
A Frontier list containing a list of fields in the specified table
Examples
dialog.alert(getFieldNames(id, "names"))
» {"name", "occupation", "floating"}
Notes
This is implemented as a script using the “SHOW COLUMNS” SQL syntax