Child pages
  • rawSQL

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Cache
indextrue
refresh100d
showRefreshtrue
iddoc
titleRefresh page
showDatetrue
retryEnable

servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClient

servoy sSummary12%30%58%height: 30px;3Methods SummaryExecute any SQL, returns true if successful.Execute any SQL, returns true if successful.Execute a stored procedure, return all created result sets.Execute a stored procedure.Flush cached database data.If the result from a function was false, it will return the exception object.Notify clients about changes in records, based on pk(s).

functionservoy sDetail2100%height:30px2Methods DetailsexecuteSQLname

executeSQL(serverName,

tableName,

sql)

dessIndent
Execute any SQL, returns true if successful.
prs

Parameters

sIndentserverNamethe name of the server
tableNamethe name of the tablesqlthe sql query to executeret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
executeSQLname

executeSQL(serverName

, tableName

, sql, sql_args)

dessIndent
Execute any SQL, returns true if successful.
prs

Parameters

sIndentserverNamethe name of the server
tableNamethe name of the tablesqlthe sql query to executesql_argsthe arguments for the queryret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
executeStoredProcedurename

executeStoredProcedure(serverName, procedureDeclaration, arguments, maxNumberOfRowsToRetrieve)

dessIndent
Execute a stored procedure, return all created result sets.
prs

Parameters

sIndentserverName ;procedureDeclaration ;arguments ;maxNumberOfRowsToRetrieve ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
executeStoredProcedurename

executeStoredProcedure(serverName, procedureDeclaration, arguments, inOutDirectionality, maxNumberOfRowsToRetrieve)

dessIndent
Execute a stored procedure.
prs

Parameters

sIndentserverName ;procedureDeclaration ;arguments ;inOutDirectionality ;maxNumberOfRowsToRetrieve ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
flushAllClientsCachename

flushAllClientsCache(serverName, tableName)

dessIndent
Flush cached database data. Use with extreme care, its affecting the performance of clients!
prs

Parameters

sIndentserverName ;tableName ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
getExceptionname

getException()

dessIndent
If the result from a function was false, it will return the exception object.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
notifyDataChangename

notifyDataChange(serverName, tableName, pksDataset, action)

dessIndent
Notify clients about changes in records, based on pk(s). Use with extreme care, its affecting the performance of clients!
prs

Parameters

sIndentserverName ;tableName ;pksDataset ;action ;
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow