Page History

Wiki Markup
{hidden}
DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY, UNLESS YOU KNOW WHAT YOU'RE DOING.
		THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO EXTRACT CHANGES FROM THE PAGE AND MERGE THEM BACK INTO SERVOY SOURCE{hidden}
{sub-section:description|text=}{sub-section}\\{table:class=servoy sSummery}{colgroup}{column:width=80px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Method Summary{th}{tr}{tbody}{tr}{td}[Boolean]{td}{td}[#next]\()
Go to next record in this updater, returns true if successful.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#performUpdate]\()
Do the actual update in the database, returns true if successful.{td}{tr}{tbody}{tbody}{tr}{td}void{td}{td}[#resetIterator]\()
Start over with this iterator 'next' function (at the foundset selected record).{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#setColumn]\(name, value)
Set the column value to update, returns true if successful.{td}{tr}{tbody}{table}\\{table:class=servoy sDetail}{colgroup}{column:width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Method Details{th}{tr}{tbody:id=F4AA090CDBA6DD60-1B7AB300-4B884536-8F3EB5F7-C8B2E12F6DBB0CEAF8F15AC0}{tr:id=name}{td}h6.next{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}next{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:F4AA090CDBA6DD60-1B7AB300-4B884536-8F3EB5F7-C8B2E12F6DBB0CEAF8F15AC0_des|text=|trigger=button}{sub-section}{sub-section:F4AA090CDBA6DD60-1B7AB300-4B884536-8F3EB5F7-C8B2E12F6DBB0CEAF8F15AC0_des|trigger=none|class=sIndent}Go to next record in this updater, returns true if successful.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:F4AA090CDBA6DD60-1B7AB300-4B884536-8F3EB5F7-C8B2E12F6DBB0CEAF8F15AC0_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:F4AA090CDBA6DD60-1B7AB300-4B884536-8F3EB5F7-C8B2E12F6DBB0CEAF8F15AC0_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:F4AA090CDBA6DD60-1B7AB300-4B884536-8F3EB5F7-C8B2E12F6DBB0CEAF8F15AC0_ret|text=|trigger=button}{sub-section}{sub-section:F4AA090CDBA6DD60-1B7AB300-4B884536-8F3EB5F7-C8B2E12F6DBB0CEAF8F15AC0_ret|trigger=none|class=sIndent}[Boolean] -- true if proceeded to next record, false otherwise{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:F4AA090CDBA6DD60-1B7AB300-4B884536-8F3EB5F7-C8B2E12F6DBB0CEAF8F15AC0_see|text=|trigger=button}{sub-section}{sub-section:F4AA090CDBA6DD60-1B7AB300-4B884536-8F3EB5F7-C8B2E12F6DBB0CEAF8F15AC0_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:F4AA090CDBA6DD60-1B7AB300-4B884536-8F3EB5F7-C8B2E12F6DBB0CEAF8F15AC0_see|text=|trigger=button}{sub-section}{sub-section:F4AA090CDBA6DD60-1B7AB300-4B884536-8F3EB5F7-C8B2E12F6DBB0CEAF8F15AC0_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:F4AA090CDBA6DD60-1B7AB300-4B884536-8F3EB5F7-C8B2E12F6DBB0CEAF8F15AC0_sam|text=|trigger=button}{sub-section}{sub-section:F4AA090CDBA6DD60-1B7AB300-4B884536-8F3EB5F7-C8B2E12F6DBB0CEAF8F15AC0_sam|class=sIndent|trigger=none}{code:language=javascript}
controller.setSelectedIndex(1)
var count = 0
var fsUpdater = databaseManager.getFoundSetUpdater(foundset)
while(fsUpdater.next())
{
	fsUpdater.setColumn('my_flag',count++)
}
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=6D428E59A9475C84-008C23ED-4A0642F8-91AAAD6D-E82893D9EF7AD19A4283F205}{tr:id=name}{td}h6.performUpdate{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}performUpdate{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:6D428E59A9475C84-008C23ED-4A0642F8-91AAAD6D-E82893D9EF7AD19A4283F205_des|text=|trigger=button}{sub-section}{sub-section:6D428E59A9475C84-008C23ED-4A0642F8-91AAAD6D-E82893D9EF7AD19A4283F205_des|trigger=none|class=sIndent}Do the actual update in the database, returns true if successful.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:6D428E59A9475C84-008C23ED-4A0642F8-91AAAD6D-E82893D9EF7AD19A4283F205_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:6D428E59A9475C84-008C23ED-4A0642F8-91AAAD6D-E82893D9EF7AD19A4283F205_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:6D428E59A9475C84-008C23ED-4A0642F8-91AAAD6D-E82893D9EF7AD19A4283F205_ret|text=|trigger=button}{sub-section}{sub-section:6D428E59A9475C84-008C23ED-4A0642F8-91AAAD6D-E82893D9EF7AD19A4283F205_ret|trigger=none|class=sIndent}[Boolean] -- true if succeeded, false if failed.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:6D428E59A9475C84-008C23ED-4A0642F8-91AAAD6D-E82893D9EF7AD19A4283F205_see|text=|trigger=button}{sub-section}{sub-section:6D428E59A9475C84-008C23ED-4A0642F8-91AAAD6D-E82893D9EF7AD19A4283F205_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:6D428E59A9475C84-008C23ED-4A0642F8-91AAAD6D-E82893D9EF7AD19A4283F205_see|text=|trigger=button}{sub-section}{sub-section:6D428E59A9475C84-008C23ED-4A0642F8-91AAAD6D-E82893D9EF7AD19A4283F205_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:6D428E59A9475C84-008C23ED-4A0642F8-91AAAD6D-E82893D9EF7AD19A4283F205_sam|text=|trigger=button}{sub-section}{sub-section:6D428E59A9475C84-008C23ED-4A0642F8-91AAAD6D-E82893D9EF7AD19A4283F205_sam|class=sIndent|trigger=none}{code:language=javascript}
//There are 3 types of possible use with the foundset updater
//1) update entire foundset
var fsUpdater = databaseManager.getFoundSetUpdater(foundset)
fsUpdater.setColumn('customer_type',1)
fsUpdater.setColumn('my_flag',0)
fsUpdater.performUpdate()

//2) update part of foundset, for example the first 4 row (starts with selected row)
var fsUpdater = databaseManager.getFoundSetUpdater(foundset)
fsUpdater.setColumn('customer_type',new Array(1,2,3,4))
fsUpdater.setColumn('my_flag',new Array(1,0,1,0))
fsUpdater.performUpdate()

//3) safely loop through foundset (starts with selected row)
controller.setSelectedIndex(1)
var count = 0
var fsUpdater = databaseManager.getFoundSetUpdater(foundset)
while(fsUpdater.next())
{
	fsUpdater.setColumn('my_flag',count++)
}
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=34E8B9E4C448A006-79EB5F65-4D234BA7-AA45B40C-25AF562AAF27F51CB5579BE3}{tr:id=name}{td}h6.resetIterator{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}void{span}{span:id=iets|style=float: left; font-weight: bold;}resetIterator{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:34E8B9E4C448A006-79EB5F65-4D234BA7-AA45B40C-25AF562AAF27F51CB5579BE3_des|text=|trigger=button}{sub-section}{sub-section:34E8B9E4C448A006-79EB5F65-4D234BA7-AA45B40C-25AF562AAF27F51CB5579BE3_des|trigger=none|class=sIndent}Start over with this iterator 'next' function (at the foundset selected record).{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:34E8B9E4C448A006-79EB5F65-4D234BA7-AA45B40C-25AF562AAF27F51CB5579BE3_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:34E8B9E4C448A006-79EB5F65-4D234BA7-AA45B40C-25AF562AAF27F51CB5579BE3_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:34E8B9E4C448A006-79EB5F65-4D234BA7-AA45B40C-25AF562AAF27F51CB5579BE3_ret|text=|trigger=button}{sub-section}{sub-section:34E8B9E4C448A006-79EB5F65-4D234BA7-AA45B40C-25AF562AAF27F51CB5579BE3_ret|trigger=none|class=sIndent}void{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:34E8B9E4C448A006-79EB5F65-4D234BA7-AA45B40C-25AF562AAF27F51CB5579BE3_see|text=|trigger=button}{sub-section}{sub-section:34E8B9E4C448A006-79EB5F65-4D234BA7-AA45B40C-25AF562AAF27F51CB5579BE3_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:34E8B9E4C448A006-79EB5F65-4D234BA7-AA45B40C-25AF562AAF27F51CB5579BE3_see|text=|trigger=button}{sub-section}{sub-section:34E8B9E4C448A006-79EB5F65-4D234BA7-AA45B40C-25AF562AAF27F51CB5579BE3_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:34E8B9E4C448A006-79EB5F65-4D234BA7-AA45B40C-25AF562AAF27F51CB5579BE3_sam|text=|trigger=button}{sub-section}{sub-section:34E8B9E4C448A006-79EB5F65-4D234BA7-AA45B40C-25AF562AAF27F51CB5579BE3_sam|class=sIndent|trigger=none}{code:language=javascript}
controller.setSelectedIndex(1)
var count = 0
var fsUpdater = databaseManager.getFoundSetUpdater(foundset)
while(fsUpdater.next())
{
	fsUpdater.setColumn('my_flag',++count)
}
fsUpdater.resetIterator()
while(fsUpdater.next())
{
	fsUpdater.setColumn('max_flag',count)
}
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=CC55F9DF28B54483-5436A986-4C934DF7-82579F89-373CDEE830E172CF6E065EC3}{tr:id=name}{td}h6.setColumn{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}setColumn{span}{span:id=iets|style=float: left;}\(name, value){span}{td}{tr}{tr:id=des}{td}{sub-section:CC55F9DF28B54483-5436A986-4C934DF7-82579F89-373CDEE830E172CF6E065EC3_des|text=|trigger=button}{sub-section}{sub-section:CC55F9DF28B54483-5436A986-4C934DF7-82579F89-373CDEE830E172CF6E065EC3_des|trigger=none|class=sIndent}Set the column value to update, returns true if successful.{sub-section}{td}{tr}{tr:id=prs}{td}*Parameters*\\{sub-section:CC55F9DF28B54483-5436A986-4C934DF7-82579F89-373CDEE830E172CF6E065EC3_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:CC55F9DF28B54483-5436A986-4C934DF7-82579F89-373CDEE830E172CF6E065EC3_prs|trigger=none}name -- The name of the column to update.
value -- The new value to be stored in the specified column.
{sub-section}{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:CC55F9DF28B54483-5436A986-4C934DF7-82579F89-373CDEE830E172CF6E065EC3_ret|text=|trigger=button}{sub-section}{sub-section:CC55F9DF28B54483-5436A986-4C934DF7-82579F89-373CDEE830E172CF6E065EC3_ret|trigger=none|class=sIndent}[Boolean] -- true if succeeded, false if failed.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:CC55F9DF28B54483-5436A986-4C934DF7-82579F89-373CDEE830E172CF6E065EC3_see|text=|trigger=button}{sub-section}{sub-section:CC55F9DF28B54483-5436A986-4C934DF7-82579F89-373CDEE830E172CF6E065EC3_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:CC55F9DF28B54483-5436A986-4C934DF7-82579F89-373CDEE830E172CF6E065EC3_see|text=|trigger=button}{sub-section}{sub-section:CC55F9DF28B54483-5436A986-4C934DF7-82579F89-373CDEE830E172CF6E065EC3_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:CC55F9DF28B54483-5436A986-4C934DF7-82579F89-373CDEE830E172CF6E065EC3_sam|text=|trigger=button}{sub-section}{sub-section:CC55F9DF28B54483-5436A986-4C934DF7-82579F89-373CDEE830E172CF6E065EC3_sam|class=sIndent|trigger=none}{code:language=javascript}
//There are 3 types of possible use with the foundset updater
//1) update entire foundset
var fsUpdater = databaseManager.getFoundSetUpdater(foundset)
fsUpdater.setColumn('customer_type',1)
fsUpdater.setColumn('my_flag',0)
fsUpdater.performUpdate()

//2) update part of foundset, for example the first 4 row (starts with selected row)
var fsUpdater = databaseManager.getFoundSetUpdater(foundset)
fsUpdater.setColumn('customer_type',new Array(1,2,3,4))
fsUpdater.setColumn('my_flag',new Array(1,0,1,0))
fsUpdater.performUpdate()

//3) safely loop through foundset (starts with selected row)
controller.setSelectedIndex(1)
var count = 0
var fsUpdater = databaseManager.getFoundSetUpdater(foundset)
while(fsUpdater.next())
{
	fsUpdater.setColumn('my_flag',count++)
}
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}
Child pages

Versions Compared

Old Version 2

New Version 3

Key
