Param 37 not supported

[Erva_Mikko]

Have in SQL Server field type Decimal(18,2). Using RemoteDB.

When trying to post record where field value has changed, get ODBC error Param 37 not supported.

Tried to change display and edit formats in dataset to "0.00" but it didn't help.

[wlandgraf (Wagner Landgraf)]

Which database-access component are you using to connect to SQL Server? Have you tried to update your SQL Server client in the computer where your RemoteDB server is located, to see if it solves the issue?

[Erva_Mikko]

Using native MSSQL. Just updated Sql Server Client, it solved this AutoInc problem few days ago

RemoteDB / AutoInc field

Installed this to development pc. Compiled RemoteDB server app again and downloaded it to EC2 instance. Same error continues. Tested what value id field has before post and it's null. Tested also to add it to '-1' but same error continues.

Problem exist also when RemoteDB is running in development machine at localhost. In development machine is also Sql Server Client just updated.

[wlandgraf (Wagner Landgraf)]

Could you please then provide exact steps and/or sample project so we can consistently reproduce it on our side?

[Erva_Mikko]

Send you in mail both server and client projects

[wlandgraf (Wagner Landgraf)]

Thank you for the projects. They were very useful. We could reproduce and fix the issue. Next RemoteDB update will include the fix.

[Erva_Mikko]

Great! Thanks :)