given:
Database: MSSQL
Form (editable grid)
Form Settings / Fields / <myfieldname> / Generell Settings / Disabled Field => insert / update mode
Bug: the INSERT INTO instruction contains the field name <myfieldname> …
Not sure if this is a bug, it says that the field is disabled, so not editable on your form. Might be unclear what the function should be?
Not sure if this is a bug either. Is it changing your current field value?
regards,
Bernhard Bernsmann
It has to do with reserved field names …
In my develop enviroment (SC / Win7) i use the DBMS Type “MSSQL Server NATIVE SRV PDO”. Here it works without problems. In the production environment (Debian, PHP 5.4.4) is the DBMS Type “MSSQL Server” and INSERT INTO running with reserved field names to an error …
I find no way certain fields exclude from UPDATE or INSERT INTO commands.
[QUOTE=RHS;24143]
I find no way certain fields exclude from UPDATE or INSERT INTO commands.[/QUOTE]
No one with a solution/workaround? Is not unusual that you do not want write to all fields …
No, look at the comment after “Disabled Field”: “Disable the field on some event”. That’s a bug and not a “feature” …
I don’t think it makes sense to argue over Netmake’s meaning of “Disabled”. 
The standard behaviour is, when you submit a form all fields of that form are updated/inserted no matter if they are disabled or hidden.
You have a little influence what value is inserted by choosing the appropriate option in section Database Value at the field settings.
If you want to change the standard behaviour the only solution / workaround is to create your own update / insert button.
That’s at least the way I do it.
Just my 2 cts.
jsb
Hello,
I will contact our bugs team regarding this issue.
regards,
Bernhard Bernsmann
Yes, unfortunately …
[QUOTE=jsbinca;24463]The standard behaviour is, when you submit a form all fields of that form are updated/inserted no matter if they are disabled or hidden.
[/QUOTE]
I ask myself why under Form Settings / Edit Fields the column “Read-only” is present? Probably Netmake do not know also … such clear things nerves.