NULL Values and Numeric Formats with NET Connector

Suite and Optimus Suite 5
#1

basicly i step into 2 problems:

1st. NULL Values
MS_SQL numeric Databasefield Allow NULL yes

Send by dataprocessor UPDATE Table SET FieldName =‘’ WHERE ID=‘234’
Where it shoulkd be FieldName = NULL

In this case The SQL Server will report a convert error.

2nd. Numeric Values
The Server will expect values with Dot separator 100.5
Send by dataprocessor UPDATE Table SET FieldName =‘100,5’ WHERE ID=‘234’
In this case The SQL Server will also report a convert error.

Do i miss something or must i realy convert all cases in the BeforeProcessing?

With best regards,
Uwe Janke

#2

(1)
You can use beforeUpdate event handler on server side to replace empty values with nulls.
docs.dhtmlx.com/connector__net__ … pdate.html
By default if you have an empty cell in the client side grid, it will be sent to server side as empty string

(2)
Dataprocessor doesn’t reformat values. It send them as they was entered by user.
If user has typed number with comma delimiter - it will be sent with comma.
If you are using grid - check edn column type, that can be combined with number formatting functionality ( it shows the formatted value, but send back to server the valid number )