TEXT column null
Posted: 14.09.2009, 14:05
hi everybody,
I'am using D7 and Zeos 6.6.5 to insert/update data to mysql 5 database, I use TZQuery and TZUpdateSQL component.
My code generate insert/update string for TZUpdateSQL dinamically reading from another db. This means TZUpdateSQL.InsertSQL.Text is like this: "INSERT INTO table1 (name, username, email, password, params) VALUES (:pname, :pusername, :pemail, :ppassword, :pparams)"
Next step my code set parameters and then call quey.Post;
The issue is about field 'params', it is TEXT column in mysql and NOT NULL.
I set value to 'timezone=0' but I get the error "Field params is required, but not supplied." in TZAbstractRODataset.InternalPost when Checkrequired is call.
Why this? If I set field value to ' ' in beforepost of TZQuery it work but it insert 'timezone=0' not ' ' like I expect.
Some ideas?
thanks
I'am using D7 and Zeos 6.6.5 to insert/update data to mysql 5 database, I use TZQuery and TZUpdateSQL component.
My code generate insert/update string for TZUpdateSQL dinamically reading from another db. This means TZUpdateSQL.InsertSQL.Text is like this: "INSERT INTO table1 (name, username, email, password, params) VALUES (:pname, :pusername, :pemail, :ppassword, :pparams)"
Next step my code set parameters and then call quey.Post;
The issue is about field 'params', it is TEXT column in mysql and NOT NULL.
I set value to 'timezone=0' but I get the error "Field params is required, but not supplied." in TZAbstractRODataset.InternalPost when Checkrequired is call.
Why this? If I set field value to ' ' in beforepost of TZQuery it work but it insert 'timezone=0' not ' ' like I expect.
Some ideas?
thanks