If the update flag is checked in Form Settings / Edit Fields then include this field in the UPDATE SQL command. If the new flag is checked then include this field in the INSERT INTO SQL command. If no flag checked then include this field only in the SELECT SQL command.
My problem is still unresolved: how can I remove certain fields from SQL command?
I have therefore developed even further and found the following: the problem of post #1, I have this on a production server (LAMP) with PHP 5.3 (app generated with SC 7.1.0013). I have this error not with PHP 5.4 on my development machine (WIN7, SC standard installation). The difference is: on my machine running the MS SQL server native client (DBMS Type = MSSQL Server NATIVE SRV in SC) and on the production machine i'am use DBMS Type = MSSQL Server.
I will set up a new server with PHP 5.4 and look again ...