Using Servoy_202006
the following code works without error but the MySQL database is not updated:
function onAction$updateUsers( event )
{
/** @type {JSFoundSet} */
var fs = datasources.db.qfi.t_user.getFoundSet( );
application.output('fs: ' + fs );
var fsUpdater = databaseManager.getFoundSetUpdater( fs );
application.output('fsUpdater: ' + fsUpdater);
var a = fsUpdater.setColumn( 'featuresfixesviewed', 0 );
application.output('setColumn a: ' + a);
var b = fsUpdater.performUpdate( );
application.output('performUpdate b: ' + b);
}
Console output:
fs:
fsUpdater: com.servoy.j2db.dataprocessing.JSFoundSetUpdater@70e9c4cf
setColumn a: true
performUpdate b: true
In the interactive console fs is:
=>fs
{_records_:,_selection_:0,alldataproviders:["id","accessbusinessid","accesscount","accesslevel","active","airtax","allowproductcontrol","amountdisplay","batterylevy","clearfinancialrep1id","crosscompanycopy","displaytypecashdeals","displaytypefinancedeals","displaytypeleasedeals","docfeecash","docfeefinance","docfeelease","dtdmssalespersonid","dtdmssalespersontype","emailaddress","etchingid","featuresfixesviewed","financepmtsperyear","firstname","fk_businessid","fk_companyid","fk_financebankid","fk_leasebankid","fk_taxcodeid","frontlineuserid","gapid","insalgorithm","insapplicantah","insapplicantci","insapplicantlife","insapplicantloe","inscompany","inscompanyloe","insdisretrofinance","insdisretrolease","insnamefinance","insnamefinanceloe","insnamelease","insnameleaseloe","lastaccess","lastname","leasepmtsperyear","levyonusedunits","licencefee","loginname","lubricousername","maintenanceid","otherfee1","otherfee2","otherfiid","othertax1","othertax2","password","propackid","rebate1","rebate2","salgapprogramid","salgappromocode","securityid","showunitcosts","spallowdeletecontact","spallowdeletedeal","spallowdeleteunit","spshowalldeals","tirelevy","tirewheelid","unitcategory","userqprintaccess","useservoy","warrantyid"],allnames:,length:0,multiSelect:false}
This is correct for the t_user table,
The return values say there is no problem but the column in the t_user table is not changed!
Can you help?
thanks,
Terry