In a mysql table I've a Field with the settings "not null" and default = "some text"
In Tersus I want to insert a record, but with Field not filled, it gives the following error:
"SQL Exection - error code:1048 error message: Column 'Field' cannot be null"
Message=Failed to execute SQL statement 'INSERT INTO tbcomcomp \(comp\,compmi\,Field\) VALUES \(?\,?\,?\)': ,Cause=Exception Type:Column 'Field' cannot be null\nValues:zxc\,zxczz\,null\) - - 1241524833716
I expected after changing the mandatory settings of Field and if empty Field was omitted in the SQL-statement.
JP
To use the full functionality of this web site, JavaScript needs to be turned on.
For best results, use the Firefox browser..
Copyright © 2003-2017 - Tersus Software Ltd., All rights reserved. Terms of Use License Graphic design by EmaraDesign