servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClientservoy sSummary12%30%58%height: 30px;3Methods SummaryCreate a query builder for a data source.Create a query builder for a data source with given table alias.Get the column names of a datasource.Get the datasource string.Returns a foundset object for a specified datasource or server and tablename.An existing foundset under that name will be returned, or created if there is a definition (there is a form with a named foundset property with that name).Get a single record from a datasource.Get the table of a datasource.get a new foundset containing records based on a dataset of pks.get a new foundset containing records based on a QBSelect query.get a new foundset containing records based on an SQL query string.get a new foundset containing records based on an SQL query string with parameters.functionservoy sDetail2100%height:30px2Methods DetailscreateSelectname
sIndent A new JSFoundset for the datasource.clients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowgetFoundSetname
getFoundSet(name)
dessIndent
An existing foundset under that name will be returned, or created if there is a definition (there is a form with a named foundset property with that name).
If named foundset datasource does not match current datasource will not be returned (will return null instead).
prs
Parameters
sIndentnameThe named foundset to get for this datasource.ret
Returns
sIndentAn existing named foundset for the datasource.clients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow getRecordname
getRecord(pk)
dessIndent
Get a single record from a datasource.
For the sake of performance, if more records are needed,
don't call this method in a loop but try using other methods instead.
prs
Parameters
sIndentpkThe primary key of the record to be retrieved. Can be an array, in case of a composite pk.ret