| Table Head (thead) |
|---|
| Table Row (tr) |
|---|
| | Table Head (th) |
|---|
| | Method Details |
|
|
| Table Body (tbody) |
|---|
| id | executeSQL-String_String_String |
|---|
| | Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
executeSQL |
|
| Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
| Span |
|---|
| (serverName, tableName, sql) |
|
|
| Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
| Div |
|---|
| | Execute any SQL, returns true if successful. |
|
|
| Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
Parameters | Div |
|---|
| {String} serverName - the name of the server
{String} tableName - the name of the table
{String} sql - the sql query to execute |
|
|
| Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
Sample | Div |
|---|
| | Code Block |
|---|
| /****************************************************************************
WARNING! You can cause data loss or serious data integrity compromises!
You should have a THOROUGH understanding of both SQL and your backend
database (and other interfaces that may use that backend) BEFORE YOU USE
ANY OF THESE COMMANDS.
You should also READ THE DOCUMENTATION BEFORE USING ANY OF THESE COMMANDS
Note that when server names have been switched (databasemanager.switchServer),the
real server names must be used here, plugins.rawSQL is not transparent to switched servers.
****************************************************************************/
var country = 'NL'
var done = plugins.rawSQL.executeSQL("example_data","employees","update employees set country = ?", [country])
if (done)
{
//flush is required when changes are made in db
plugins.rawSQL.flushAllClientsCache("example_data","employees")
}
else
{
var msg = plugins.rawSQL.getException().getMessage(); //see exception node for more info about the exception obj
plugins.dialogs.showErrorDialog('Error', 'SQL exception: '+msg, 'Ok')
}
// Note that when this function is used to create a new table in the database, this table will only be seen by
// the Servoy Application Server when the table name starts with 'temp_', otherwise a server restart is needed. |
|
|
|
|
| Table Body (tbody) |
|---|
| id | executeSQL-String_String_String_ObjectArray |
|---|
| | Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
executeSQL |
|
| Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
| Span |
|---|
| (serverName, tableName, sql, sql_args) |
|
|
| Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
| Div |
|---|
| | Execute any SQL, returns true if successful. |
|
|
| Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
Parameters | Div |
|---|
| {String} serverName - the name of the server
{String} tableName - the name of the table
{String} sql - the sql query to execute
{Object[]} sql_args - the arguments for the query |
|
|
| Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
Sample | Div |
|---|
| | Code Block |
|---|
| /****************************************************************************
WARNING! You can cause data loss or serious data integrity compromises!
You should have a THOROUGH understanding of both SQL and your backend
database (and other interfaces that may use that backend) BEFORE YOU USE
ANY OF THESE COMMANDS.
You should also READ THE DOCUMENTATION BEFORE USING ANY OF THESE COMMANDS
Note that when server names have been switched (databasemanager.switchServer),the |
|
|
|
|
real server names must be used here, plugins.rawSQL is not transparent to switched servers.
****************************************************************************/
|
|
|
|
|
//Execute any SQL, returns true if successful.
var country = 'NL'
var done = plugins.rawSQL.executeSQL("example_data","employees","update employees set country = ?", [country])
if (done)
{
//flush is required when changes are made in db
plugins.rawSQL.flushAllClientsCache("example_data","employees")
}
else
{
var msg = plugins.rawSQL.getException().getMessage(); //see exception node for more info about the exception obj
plugins.dialogs.showErrorDialog('Error', 'SQL exception: '+msg, 'Ok')
}
|
|
|
|
|
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=48FCA812-9C3F-40A7-B1CA-8F06F7755A57}{tr:id=name}{td}h6.executeStoredProcedure{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[JSDataSet]{span}{span:id=iets|style=float: left; font-weight: bold;}executeStoredProcedure{span}{span:id=iets|style=float: left;}\(serverName, procedureDeclaration, arguments[, IODirectionality[, maxNrReturnedRows){span}{td}{tr}{tr:id=des}{td}{sub-section:48FCA812-9C3F-40A7-B1CA-8F06F7755A57_des|text=|trigger=button}{sub-section}{sub-section:48FCA812-9C3F-40A7-B1CA-8F06F7755A57_des|trigger=none|class=sIndent}Execute a stored procedure.{sub-section}{td}{tr}{tr:id=prs}{td}*Parameters*\\{sub-section:48FCA812-9C3F-40A7-B1CA-8F06F7755A57_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:48FCA812-9C3F-40A7-B1CA-8F06F7755A57_prs|trigger=none}serverName
procedureDeclaration
\[arguments[\]
\[IODirectionality[\]
maxNrReturnedRows
{sub-section}{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:48FCA812-9C3F-40A7-B1CA-8F06F7755A57_ret|text=|trigger=button}{sub-section}{sub-section:48FCA812-9C3F-40A7-B1CA-8F06F7755A57_ret|trigger=none|class=sIndent}[JSDataSet]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:48FCA812-9C3F-40A7-B1CA-8F06F7755A57_see|text=|trigger=button}{sub-section}{sub-section:48FCA812-9C3F-40A7-B1CA-8F06F7755A57_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:48FCA812-9C3F-40A7-B1CA-8F06F7755A57_see|text=|trigger=button}{sub-section}{sub-section:48FCA812-9C3F-40A7-B1CA-8F06F7755A57_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:48FCA812-9C3F-40A7-B1CA-8F06F7755A57_sam|text=|trigger=button}{sub-section}{sub-section:48FCA812-9C3F-40A7-B1CA-8F06F7755A57_sam|class=sIndent|trigger=none}{code:language=javascript}
/****************************************************************************
WARNING! You can
// Note that when this function is used to create a new table in the database, this table will only be seen by
// the Servoy Application Server when the table name starts with 'temp_', otherwise a server restart is needed. |
|
|
|
|
| Table Body (tbody) |
|---|
| id | executeStoredProcedure-String_String_ObjectArray_NumberArray_Number |
|---|
| | Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
executeStoredProcedure |
|
| Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
| Span |
|---|
| | executeStoredProcedure |
| Span |
|---|
| (serverName, procedureDeclaration, arguments, inOutDirectionality, maxNumberOfRowsToRetrieve) |
|
|
| Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
| Div |
|---|
| | Execute a stored procedure. |
|
|
| Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
Parameters |
|
| Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
Sample | Div |
|---|
| | Code Block |
|---|
| /****************************************************************************
WARNING! You can cause data loss or serious data integrity compromises!
You should have a THOROUGH understanding of both SQL and your backend
database (and other interfaces that may use that backend) BEFORE YOU USE
ANY OF THESE COMMANDS.
You should also READ THE DOCUMENTATION BEFORE USING ANY OF THESE COMMANDS
Note that when server names have been switched (databasemanager.switchServer),the
|
|
|
|
|
real server names must be used here, plugins.rawSQL is not transparent to switched servers.
****************************************************************************/
|
|
|
|
|
//Executea stored procedure.
var maxReturnedRows = 10; //useful to limit number of rows
var procedure_declaration = '{?=calculate_interest_rate(?)}'
|
|
|
|
|
varargs=new Array()
args[0] = java.sql.Types.NUMERIC
args[1] = 3000
// direction, a 0 for input data, a 1 for output data
var typesArray = [1, 0];
// define the types and |
|
|
|
|
directionin this case 0vartypesArray=new Array();
typesArray[0]=1;
typesArray[1]=0;
var datasetpluginsrawSQLexecuteStoredProcedure(controller.getServerName(), procedure_declaration, args, typesArray,maxReturnedRows);
exampletocalcastrangetotalglobal_total = 0;
for( var i = 1 ; i <= dataset.getMaxRowIndex() ; i++ )
{
global_total = global_total + dataset.getValue(i,1);
}
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=AC4BEE64-885C-4306-9994-955977681C53}{tr:id=name}{td}h6.flushAllClientsCache{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}flushAllClientsCache{span}{span:id=iets|style=float: left;}\(serverName, tableName){span}{td}{tr}{tr:id=des}{td}{sub-section:AC4BEE64-885C-4306-9994-955977681C53_des|text=|trigger=button}{sub-section}{sub-section:AC4BEE64-885C-4306-9994-955977681C53_des|trigger=none|class=sIndent}Flush cached database data. Use with extreme care, its affecting the performance of clients!{sub-section}{td}{tr}{tr:id=prs}{td}*Parameters*\\{sub-section:AC4BEE64-885C-4306-9994-955977681C53_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:AC4BEE64-885C-4306-9994-955977681C53_prs|trigger=none}serverName
tableName
{sub-section}{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:AC4BEE64-885C-4306-9994-955977681C53_ret|text=|trigger=button}{sub-section}{sub-section:AC4BEE64-885C-4306-9994-955977681C53_ret|trigger=none|class=sIndent}[Boolean]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:AC4BEE64-885C-4306-9994-955977681C53_see|text=|trigger=button}{sub-section}{sub-section:AC4BEE64-885C-4306-9994-955977681C53_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:AC4BEE64-885C-4306-9994-955977681C53_see|text=|trigger=button}{sub-section}{sub-section:AC4BEE64-885C-4306-9994-955977681C53_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:AC4BEE64-885C-4306-9994-955977681C53_sam|text=|trigger=button}{sub-section}{sub-section:AC4BEE64-885C-4306-9994-955977681C53_sam|class=sIndent|trigger=none}{code:language=javascript}
/******no output-parameters defined, the last select-result in the procedure will be returned.
// When one or more output-parameters are defined, the dataset will contain 1 row with the output data.
var dataset = plugins.rawSQL.executeStoredProcedure(databaseManager.getDataSourceServerName(controller.getDataSource()), procedure_declaration, args, typesArray, maxReturnedRows);
var interest_rate = dataset.getValue(1, 1); |
|
|
|
|
| Table Body (tbody) |
|---|
| id | flushAllClientsCache-String_String |
|---|
| | Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
flushAllClientsCache |
|
| Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
| Span |
|---|
| (serverName, tableName) |
|
|
| Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
| Div |
|---|
| | Flush cached database data. Use with extreme care, its affecting the performance of clients! |
|
|
| Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
Parameters |
|
| Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
Sample | Div |
|---|
| | Code Block |
|---|
| /****************************************************************************
WARNING! You can cause data loss or serious data integrity compromises!
You should have a THOROUGH understanding of both SQL and your backend
database (and other interfaces that may use that backend) BEFORE YOU USE
ANY OF THESE COMMANDS.
You should also READ THE DOCUMENTATION BEFORE USING ANY OF THESE COMMANDS
Note that when server names have been switched (databasemanager.switchServer),the
real server names must be used here, plugins.rawSQL is not transparent to switched servers.
********************************************************************** |
|
|
|
|
WARNING! You can cause data loss or serious data integrity compromises!
You should have a THOROUGH understanding of both SQL and your backend
database (and other interfaces that may use that backend) BEFORE YOU USE
ANY OF THESE COMMANDS.
You should also READ THE DOCUMENTATION BEFORE USING ANY OF THESE COMMANDS
Note that when server names have been switched (databasemanager.switchServer),the
real server names must be used here, plugins.rawSQL is not transparent to switched servers.
****************************************************************************/
//Flush cached database data. Use with extreme care, its affecting the performance of clients!
var country = 'NL'
var done = plugins.rawSQL.executeSQL("example_data","employees","update employees set country = ?", [country])
if (done)
{
//flush is required when changes are made in db
plugins.rawSQL.flushAllClientsCache("example_data","employees")
}
else
{
var msg = plugins.rawSQL.getException().getMessage(); //see exception node for more info about the exception obj
plugins.dialogs.showErrorDialog('Error', 'SQL exception: '+msg, 'Ok')
}
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=9D9BFF1C-4787-4986-9EF0-B2A3AFD4471A}{tr:id=name}{td}h6.getException{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[ServoyException]{span}{span:id=iets|style=float: left; font-weight: bold;}getException{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:9D9BFF1C-4787-4986-9EF0-B2A3AFD4471A_des|text=|trigger=button}{sub-section}{sub-section:9D9BFF1C-4787-4986-9EF0-B2A3AFD4471A_des|trigger=none|class=sIndent}If the result from a function was false, it will return the exception object.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:9D9BFF1C-4787-4986-9EF0-B2A3AFD4471A_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:9D9BFF1C-4787-4986-9EF0-B2A3AFD4471A_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:9D9BFF1C-4787-4986-9EF0-B2A3AFD4471A_ret|text=|trigger=button}{sub-section}{sub-section:9D9BFF1C-4787-4986-9EF0-B2A3AFD4471A_ret|trigger=none|class=sIndent}[ServoyException]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:9D9BFF1C-4787-4986-9EF0-B2A3AFD4471A_see|text=|trigger=button}{sub-section}{sub-section:9D9BFF1C-4787-4986-9EF0-B2A3AFD4471A_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:9D9BFF1C-4787-4986-9EF0-B2A3AFD4471A_see|text=|trigger=button}{sub-section}{sub-section:9D9BFF1C-4787-4986-9EF0-B2A3AFD4471A_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:9D9BFF1C-4787-4986-9EF0-B2A3AFD4471A_sam|text=|trigger=button}{sub-section}{sub-section:9D9BFF1C-4787-4986-9EF0-B2A3AFD4471A_sam|class=sIndent|trigger=none}{builder-show:permission=edit}{code:language=javascript}
{code}{builder-show}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=CA12B197-B764-4A3C-B8E9-DC463A3B51D4}{tr:id=name}{td}h6.notifyDataChange{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}notifyDataChange{span}{span:id=iets|style=float: left;}\(serverName, tableName, pksDataset, action){span}{td}{tr}{tr:id=des}{td}{sub-section:CA12B197-B764-4A3C-B8E9-DC463A3B51D4_des|text=|trigger=button}{sub-section}{sub-section:CA12B197-B764-4A3C-B8E9-DC463A3B51D4_des|trigger=none|class=sIndent}Notify clients about changes in records, based on pk(s). Use with extreme care, its affecting the performance of clients!{sub-section}{td}{tr}{tr:id=prs}{td}*Parameters*\\{sub-section:CA12B197-B764-4A3C-B8E9-DC463A3B51D4_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:CA12B197-B764-4A3C-B8E9-DC463A3B51D4_prs|trigger=none}serverName
tableName
pksDataset
action
{sub-section}{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:CA12B197-B764-4A3C-B8E9-DC463A3B51D4_ret|text=|trigger=button}{sub-section}{sub-section:CA12B197-B764-4A3C-B8E9-DC463A3B51D4_ret|trigger=none|class=sIndent}[Boolean]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:CA12B197-B764-4A3C-B8E9-DC463A3B51D4_see|text=|trigger=button}{sub-section}{sub-section:CA12B197-B764-4A3C-B8E9-DC463A3B51D4_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:CA12B197-B764-4A3C-B8E9-DC463A3B51D4_see|text=|trigger=button}{sub-section}{sub-section:CA12B197-B764-4A3C-B8E9-DC463A3B51D4_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:CA12B197-B764-4A3C-B8E9-DC463A3B51D4_sam|text=|trigger=button}{sub-section}{sub-section:CA12B197-B764-4A3C-B8E9-DC463A3B51D4_sam|class=sIndent|trigger=none}{code:language=javascript}
******/
var country = 'NL'
var done = plugins.rawSQL.executeSQL("example_data","employees","update employees set country = ?", [country])
if (done)
{
//flush is required when changes are made in db
plugins.rawSQL.flushAllClientsCache("example_data","employees")
}
else
{
var msg = plugins.rawSQL.getException().getMessage(); //see exception node for more info about the exception obj
plugins.dialogs.showErrorDialog('Error', 'SQL exception: '+msg, 'Ok')
}
// Note that when this function is used to create a new table in the database, this table will only be seen by
// the Servoy Application Server when the table name starts with 'temp_', otherwise a server restart is needed. |
|
|
|
|
| Table Body (tbody) |
|---|
| | Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
getException |
|
| Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
| Div |
|---|
| | If the result from a function was false, it will return the exception object. |
|
|
| Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
Sample | Div |
|---|
| | Code Block |
|---|
| /****************************************************************************
WARNING! You can cause data loss or serious data integrity compromises!
You should have a THOROUGH understanding of both SQL and your backend
database (and other interfaces that may use that backend) BEFORE YOU USE
ANY OF THESE COMMANDS.
You should also READ THE DOCUMENTATION BEFORE USING ANY OF THESE COMMANDS
Note that when server names have been switched (databasemanager.switchServer),the
real server names must be used here, plugins.rawSQL is not transparent to switched servers.
****************************************************************************/
var country = 'NL'
var done = plugins.rawSQL.executeSQL("example_data","employees","update employees set country = ?", [country])
if (done)
{
//flush is required when changes are made in db
plugins.rawSQL.flushAllClientsCache("example_data","employees")
}
else
{
var msg = plugins.rawSQL.getException().getMessage(); //see exception node for more info about the exception obj
plugins.dialogs.showErrorDialog('Error', 'SQL exception: '+msg, 'Ok')
}
// Note that when this function is used to create a new table in the database, this table will only be seen by
// the Servoy Application Server when the table name starts with 'temp_', otherwise a server restart is needed. |
|
|
|
|
| Table Body (tbody) |
|---|
| id | notifyDataChange-String_String_JSDataSet_Number |
|---|
| | Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
notifyDataChange |
|
| Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
| Span |
|---|
| (serverName, tableName, pksDataset, action) |
|
|
| Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
| Div |
|---|
| | Notify clients about changes in records, based on pk(s). Use with extreme care, its affecting the performance of clients! |
|
|
| Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
Parameters |
|
| Table Row (tr) |
|---|
| | Table Cell (td) |
|---|
Sample | Div |
|---|
| | Code Block |
|---|
| /****************************************************************************
WARNING! You can cause data loss or serious data integrity compromises!
You should have a THOROUGH understanding of both SQL and your backend
database (and other interfaces that may use that backend) BEFORE YOU USE
ANY OF THESE COMMANDS.
You should also READ THE DOCUMENTATION BEFORE USING ANY OF THESE COMMANDS
Note that when server names have been switched (databasemanager.switchServer),the
|
|
|
|
|
real server names must be used here, plugins.rawSQL is not transparent to switched servers.
****************************************************************************/
|
|
|
|
|
//Notify clients about changes in records, based on pk(s). Use with extreme care, its affecting the performance of clients!1SQL_ACTION_TYPES.DELETE_ACTION //pks deleted
//var action = |
|
|
|
|
2SQL_ACTION_TYPES.INSERT_ACTION //pks inserted
//var action = |
|
|
|
|
3SQL_ACTION_TYPES.UPDATE_ACTION //pks updates
var pksdataset = databaseManager.convertToDataSet(new Array(12,15,16,21))
var ok = plugins.rawSQL.notifyDataChange(databaseManager.getDataSourceServerName(controller. |
|
|
|
|
getServerNamegetDataSource()), 'employees', pksdataset,action) |
|
|
|
|
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table} |