Grid Dataprocessor not writing back to DB

Suite and Optimus Suite 5
#1

I’m having issues with the grid dataprocessor CRUD operations. The connector reads from the MySQL database just fine, but any updates are not being captured. The log only shows the select statements:

[code]====================================
Log started, 22/10/2013 10:26:16

SELECT id,bidPackage,description,noBidders,successfulBidder,quote,avgBid,estimate FROM buyout LIMIT 0,25

SELECT COUNT(*) as DHX_COUNT FROM buyout

Done in 0.021270990371704s[/code]

This is the table definition:

CREATE TABLE `buyout` ( `id` int(11) NOT NULL AUTO_INCREMENT, `projID` int(11) DEFAULT NULL, `bidPackage` varchar(40) NOT NULL DEFAULT '', `description` varchar(100) NOT NULL DEFAULT '', `noBidders` int(3) NOT NULL DEFAULT '0', `successfulBidder` varchar(100) NOT NULL DEFAULT '', `quote` decimal(19,2) NOT NULL DEFAULT '0.00', `avgBid` decimal(19,2) NOT NULL DEFAULT '0.00', `estimate` decimal(19,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`id`), UNIQUE KEY `IDX_buyout_1` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

Please find the demo attached. Thanks for your help!
demo.zip (843 KB)

#2

Anybody? I have modeled my grid and connectors to behave exactly like the samples and for the life of me I cannot get it to work.

#3

So I started digging into the documentation and I mistakenly called dhtmlxdataprocessor.js. If you’re using dhtmlx.js (dhtmlxSuite) you do not need to call it.