HI all,
AM using latest ASP.NET maker 2018
database paostgresql
example of table structure
CREATE TABLE IF NOT EXISTS employee_contract_information (
id varchar(50) PRIMARY KEY NOT NULL,
contract_type varchar(50) ,
is_consultant BOOLEAN ,
);
Also I have not customisations on this table whatesoever
When I setup above table, BY default it will choose checkbox as default edit tag for "is_consultant BOOLEAN", it even sets user select options for it as [1=Yes, 0=No] which is ok, when I generate both Add & edit page works fine.
BUT Then I change the edit tag to use Select (mainly because I want user to see the Yes or No labels which is not available when using checkbox) and I sometimes edit the Yes or No labels to oother proper descriptions.
Now when I generate the add & edit page. I cant save anymore, since It generates exeception "An unhandled exception occurred while processing the request.
FormatException: String was not recognized as a valid Boolean.".
How I noticed this is if I leave all boolean controlls to checkbox everything works by when I change them to selects even if its only one of them, it generates above error
NOTE: I know the db is ok,coz I was using alot of similar dbs in phpmaker and set to select as well and I dont have the same problem.
I tracked it down to the line "int result = command.ExecuteNonQuery();", I tried to enable debug mode to see the query but since it fails before it wont show me the insert sql like it normally does for successfull inserts, It shows the exception isntead, so I dont know how the value looks in the query.