Page History
Wiki Markup |
---|
{hiddendiv:style=display:none} DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY (EXCEPT INSIDE THE DIV BELOW WITH ID=DESCRIPTION), UNLESS YOU KNOW WHAT YOU'RE DOING. THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO EXTRACTAUTO CHANGESUPDATE FROM THE PAGECONTENT ANDTHROUGH MERGETHE THEM BACK INTO SERVOY SOURCE{hiddenDOC GENERATOR{div} {sub-sectiondiv:id=description|text=}{sub-sectiondiv}\\ {table:id=|class=servoy sSummary}{colgroup}{column:width=80px|padding=0px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Method Summary{th}{tr}{tbody}{tr}{td}[JSTableObject]{td}{td}[#createNewTable]\(tableName) Creates in this server a new table with the specified name.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#dropTable]\(tableName) Drops the table with the specified name from this server.{td}{tr}{tbody}{tbody}{tr}{td}[JSTableObject]{td}{td}[#getTable]\(tableName) Returns a JSTable instance corresponding to the table with the specified name from this server.{td}{tr}{tbody}{tbody}{tr}{td}[String]\[]{td}{td}[#getTableNames]\() Returns an array with the names of all tables in this server.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#isValid]\() Get valid state for the server.{td}{tr}{tbody}{tbody}{tr}{td}void{td}{td}[#reloadDataModel]\() Reloads the datamodel from the database, if changed externally or via rawSQL plugin.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#synchronizeWithDB]\(table) Synchronizes a JSTable instance with the database.{td}{tr}{tbody}{table}\\ {table:id=function|class=servoy sDetail}{colgroup}{column:width=100%|padding=0px}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Method Details{th}{tr}{tbody:id=createNewTable-String|class=node}{tr:id=name}{td}h6.createNewTable{td}{tr}{tr:id=sig}{td}{span:style=floatmargin-right: left; margin-right: 5px;}[JSTableObject]{span}{span:id=iets|style=float: left; font-weight: bold;}createNewTable{span}{span:id=iets|style=float: left;}\(tableName){span}{td}{tr}{builder-show:permission=edit}{tr:id=desprs}{td}{sub-section:createNewTable-String_des|trigger=button|text=}{sub-section}{sub-section:createNewTable-String_des|trigger=none|class=sIndent}Replace with description{sub-section*Parameters*\\{div:class=sIndent}\{[String]} tableName -- The name of the table to create. {div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sncret}{td}*SinceReturns*\\{sub-section:createNewTable-String_snc|trigger=button|text=}{sub-section}{sub-section:createNewTable-String_snc|trigger=none|class=sIndent} Replace with version info{sub-sectiondiv:class=sIndent}[JSTableObject] -- JSTableObject created table.{div}{td}{tr}{builder-show}{tr:id=prssam}{td}*ParametersSample*\\{sub-section:createNewTable-String_prs|trigger=button|text=}{sub-section}{sub-section:createNewTable-String_prs|trigger=none|class=sIndent}\{[String]} tableName -- The name of the table to create. {sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:createNewTable-String_ret|trigger=button|text=}{sub-section}{sub-section:createNewTable-String_ret|trigger=none|class=sIndent}[JSTableObject] -- JSTableObject created table.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:createNewTable-String_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:createNewTable-String_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:createNewTable-String_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:createNewTable-String_link|trigger=none}{sub-section}{divdiv:class=sIndent}{code:language=javascript} var server = plugins.maintenance.getServer("example_data"); if (server) { var table = server.createNewTable("new_table"); if (table) { var pk = table.createNewColumn("new_table_id", JSColumn.INTEGER, 0); pk.rowIdentifierType = JSColumn.PK_COLUMN; if (server.synchronizeWithDB(table)) application.output("New table created in the database."); else application.output("New table not created in database."); } else application.output("New table not created at all."); } {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=dropTable-String}{tr:id=name}{td}h6.dropTable{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[Boolean]{span}{span:style=font-weight: bold;}dropTable{span}{span}\(tableName){span}{td}{tr}{builder-show}{tr:id=samprs}{td}*SampleParameters*\\{sub-section:createNewTable-String_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:createNewTable-String_sam|trigger=none}{code:language=javascript} var server = plugins.maintenance.getServer("example_data"); if (server) { var table = server.createNewTable("new_table"); if (table) { var pk = table.createNewColumn("new_table_id", JSColumn.INTEGER, 0); pk.rowIdentifierType = JSColumn.PK_COLUMN; if (server.synchronizeWithDB(table)) application.output("New table created in the database."); else \{[String]} tableName -- The name of the table to drop. {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[Boolean] -- boolean success.{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} var server = plugins.maintenance.getServer("example_data"); if (server) { var result = server.dropTable("new_table"); if (result) application.output("New table not created in databaseTable dropped."); }else else application.output("NewTable table not created at alldropped."); } {code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=dropTablegetTable-String|class=node}{tr:id=name}{td}h6.dropTablegetTable{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[BooleanJSTableObject]{span}{span:id=iets|style=float: left; fontfont-weight: bold;}dropTablegetTable{span}{span:id=iets|style=float: left;}\(tableName){span}{td}{tr}{builder-show:permission=edit}{tr:id=desprs}{td}{sub-section:dropTable-String_des|trigger=button|text=}{sub-section}{sub-section:dropTable-String_des|trigger=none|class=sIndent}Replace with description{sub-section*Parameters*\\{div:class=sIndent}\{[String]} tableName -- The name of the table to retrieve. {div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sncret}{td}*SinceReturns*\\{sub-section:dropTable-String_snc|trigger=button|text=}{sub-section}{sub-section:dropTable-String_snc|trigger=none|class=sIndent} Replace with version info{sub-sectiondiv:class=sIndent}[JSTableObject] -- JSTableObject table.{div}{td}{tr}{builder-show}{tr:id=prssam}{td}*ParametersSample*\\{sub-section:dropTable-String_prs|trigger=button|text=}{sub-section}{sub-section:dropTable-String_prs|trigger=none|class=sIndent}\{[String]} tableName -- The name of the table to drop. {sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:dropTable-String_ret|trigger=button|text=}{sub-section}{sub-section:dropTable-String_ret|trigger=none|class=sIndent}[Boolean] -- boolean success.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:dropTable-String_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:dropTable-String_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:dropTable-String_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:dropTable-String_link|trigger=none}{sub-section}div:class=sIndent}{code:language=javascript} var server = plugins.maintenance.getServer("example_data"); if (server) { var table = server.getTable("employees"); if (table) { var colNames = table.getColumnNames() application.output("Table has " + colNames.length + " columns."); for (var i=0; i<colNames.length; i++) application.output("Column " + i + ": " + colNames[i]); } } {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getTableNames}{tr:id=name}{td}h6.getTableNames{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[String]\[]{span}{span:style=font-weight: bold;}getTableNames{span}{span}\(){span}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[String]\[] -- Array of String table names.{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:dropTable-String_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:dropTable-String_sam|trigger=none}{code:language=javascript} var server = plugins.maintenance.getServer("example_data"); if (server) { var resulttableNames = server.dropTablegetTableNames("new_table"); if (result) application.output("Table dropped"There are " + tableNames.length + " tables."); elsefor (var i=0; i<tableNames.length; i++) application.output("Table not dropped."); } {code}{sub-section" + i + ": " + tableNames[i]); } else { plugins.dialogs.showInfoDialog("Attention","Server 'example_data' cannot be found.","OK"); } {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getTable-String|class=nodeisValid}{tr:id=name}{td}h6.getTableisValid{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[JSTableObjectBoolean]{span}{span:id=iets|style=float: left; font-weight: bold;}getTableisValid{span}{span:id=iets|style=float: left;}\(tableName){span}{td}{tr}{builder-show:permission=edit}{tr:id=desret}{td}{sub-section:getTable-String_des|trigger=button|text=}{sub-section}{sub-section:getTable-String_des|trigger=none|class=sIndent}Replace with description{sub-section*Returns*\\{div:class=sIndent}[Boolean] -- boolean valid state.{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sncsam}{td}*SinceSample*\\{sub-section:getTable-String_snc|trigger=button|text=}{sub-section}{sub-section:getTable-String_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:getTable-String_prs|trigger=button|text=}{sub-section}{sub-section:getTable-String_prs|trigger=none|class=sIndent}\{[String]} tableName -- The name of the table to retrieve. {sub-section}{div:class=sIndent}{code:language=javascript} var server = plugins.maintenance.getServer("example_data"); if (!server.isValid()) { application.output("Server not valid!"); } {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=reloadDataModel}{tr:id=name}{td}h6.reloadDataModel{td}{tr}{tr:id=retsig}{td}*Returns*\\{sub-section:getTable-String_ret|trigger=button|text=}{sub-section}{sub-section:getTable-String_ret|trigger=none|class=sIndent}[JSTableObject] -- JSTableObject table.{sub-section{span:style=margin-right: 5px;}void{span}{span:style=font-weight: bold;}reloadDataModel{span}{span}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=seeret}{td}*Also seeReturns*\\{sub-section:getTable-String_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getTable-String_see|trigger=none}{sub-section}{div:class=sIndent}void{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linksam}{td}*External linksSample*\\{sub-section:getTable-String_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getTable-String_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getTable-String_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getTable-String_sam|trigger=none}{code:language=javascript} var server = plugins.maintenance.getServer("example_data"); div:class=sIndent}{code:language=javascript} var server = plugins.maintenance.getServer("example_data"); var result = plugins.rawSQL.executeSQL("example_data", null, 'CREATE TABLE raw_table (raw_table_id INTEGER)'); if (result) { application.output("Table created through rawSQL plugin."); if (server) { var table = server.getTablereloadDataModel("employees"); if (table) { var colNames = table.getColumnNames() application.output("Table has " + colNames.length + " columns."); for (var i=0; i<colNames.length; i++) application.output("Column " + i + ": " + colNames[i]); } } {code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getTableNames|class=node}{tr:id=name}{td}h6.getTableNames{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[String]\[]{span}{span:id=iets|style=float: left; font-weight: bold;}getTableNames{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:getTableNames_des|trigger=button|text=}{sub-section}{sub-section:getTableNames_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getTableNames_snc|trigger=button|text=}{sub-section}{sub-section:getTableNames_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getTableNames_prs|trigger=button|text=}{sub-section}{sub-section:getTableNames_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getTableNames_ret|trigger=button|text=}{sub-section}{sub-section:getTableNames_ret|trigger=none|class=sIndent}[String]\[] -- Array of String table names.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getTableNames_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getTableNames_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getTableNames_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getTableNames_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getTableNames_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getTableNames_sam|trigger=none}{code:language=javascript} var server = plugins.maintenance.getServer("example_data"); if (server) { var tableNames = server.getTableNames(); application.output("There are " + tableNames.length + " tables."); for (var i=0; i<tableNames.length; i++) application.output("Table " + i + ": " + tableNames[i]); } else { plugins.dialogs.showInfoDialog("Attention","Server 'example_data' cannot be found.","OK"); } {code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=isValid|class=node}{tr:id=name}{td}h6.isValid{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}isValid{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:isValid_des|trigger=button|text=}{sub-section}{sub-section:isValid_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:isValid_snc|trigger=button|text=}{sub-section}{sub-section:isValid_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:isValid_prs|trigger=button|text=}{sub-section}{sub-section:isValid_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:isValid_ret|trigger=button|text=}{sub-section}{sub-section:isValid_ret|trigger=none|class=sIndent}[Boolean] -- boolean valid state.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:isValid_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:isValid_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:isValid_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:isValid_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:isValid_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:isValid_sam|trigger=none}{code:language=javascript} var server = plugins.maintenance.getServer("example_data"); if (!server.isValid()) { application.output("Server not valid!"); } {code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=reloadDataModel|class=node}{tr:id=name}{td}h6.reloadDataModel{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}void{span}{span:id=iets|style=float: left; font-weight: bold;}reloadDataModel{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:reloadDataModel_des|trigger=button|text=}{sub-section}{sub-section:reloadDataModel_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:reloadDataModel_snc|trigger=button|text=}{sub-section}{sub-section:reloadDataModel_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:reloadDataModel_prs|trigger=button|text=}{sub-section}{sub-section:reloadDataModel_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:reloadDataModel_ret|trigger=button|text=}{sub-section}{sub-section:reloadDataModel_ret|trigger=none|class=sIndent}void{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:reloadDataModel_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:reloadDataModel_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:reloadDataModel_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:reloadDataModel_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:reloadDataModel_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:reloadDataModel_sam|trigger=none}{code:language=javascript} var server = plugins.maintenance.getServer("example_data"); var result = plugins.rawSQL.executeSQL("example_data", null, 'CREATE TABLE raw_table (raw_table_id INTEGER)'); if (result) { application.output("Table created through rawSQL plugin."); if (server) { server.reloadDataModel(); // All existing JSTableObject/JSColumn object references are invalid now! Use getTable to get new ones. var table = server.getTable("raw_table"); if (table) { var colNames = table.getColumnNames() application.output("Table has " + colNames.length + " columns."); for (var i=0; i<colNames.length; i++) application.output("Column " + i + ": " + colNames[i]); } } } else { application.output("Raw table creation failed: " + plugins.rawSQL.getException()); } {code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=synchronizeWithDB-JSTableObject|class=node}{tr:id=name}{td}h6.synchronizeWithDB{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}synchronizeWithDB{span}{span:id=iets|style=float: left;}\(table){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:synchronizeWithDB-JSTableObject_des|trigger=button|text=}{sub-section}{sub-section:synchronizeWithDB-JSTableObject_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:synchronizeWithDB-JSTableObject_snc|trigger=button|text=}{sub-section}{sub-section:synchronizeWithDB-JSTableObject_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:synchronizeWithDB-JSTableObject_prs|trigger=button|text=}{sub-section}{sub-section:synchronizeWithDB-JSTableObject_prs|trigger=none|class=sIndent}\{[JSTableObject]} table -- A JSTableObject instance that should be synchronized. {sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:synchronizeWithDB-JSTableObject_ret|trigger=button|text=}{sub-section}{sub-section:synchronizeWithDB-JSTableObject_ret|trigger=none|class=sIndent}[Boolean] -- boolean success.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:synchronizeWithDB-JSTableObject_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:synchronizeWithDB-JSTableObject_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:synchronizeWithDB-JSTableObject_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:synchronizeWithDB-JSTableObject_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show // All existing JSTableObject/JSColumn object references are invalid now! Use getTable to get new ones. var table = server.getTable("raw_table"); if (table) { var colNames = table.getColumnNames() application.output("Table has " + colNames.length + " columns."); for (var i=0; i<colNames.length; i++) application.output("Column " + i + ": " + colNames[i]); } } } else { application.output("Raw table creation failed: " + plugins.rawSQL.getException()); } {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=synchronizeWithDB-JSTableObject}{tr:id=name}{td}h6.synchronizeWithDB{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[Boolean]{span}{span:style=font-weight: bold;}synchronizeWithDB{span}{span}\(table){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[JSTableObject]} table -- A JSTableObject instance that should be synchronized. {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[Boolean] -- boolean success.{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{sub-section:synchronizeWithDB-JSTableObject_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:synchronizeWithDB-JSTableObject_sam|trigger=none}{code:language=javascript} var server = plugins.maintenance.getServer("example_data"); if (server) { var table = server.createNewTable("new_table"); if (table) { var pk = table.createNewColumn("new_table_id", JSColumn.INTEGER, 0); pk.rowIdentifierType = JSColumn.PK_COLUMN; if (server.synchronizeWithDB(table)) application.output("New table created in the database."); else application.output("New table not created in database."); } else application.output("New table not created at all."); } {code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table} |
Overview
Content Tools
Activity