Insert Record Error MS SQL2000

[mpwiedemann]

Hello,

I have a simple table that has an auto incremented primary key. I have set the Servoy dataprovider PK to 'managed by database'. I keep getting this error when creating a record.


java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 1: Incorrect syntax near ','. [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 1: Incorrect syntax near ','.

[Jan Aleman]

The primary key has to be managed by Servoy, you can have other auto increments be managed by the database but not the primary key. There is no generic way to get database increments back through JDBC currently so we can't support PK's managed by the database. We are looking at implementing database specific routines to be able to support this functionality.

[mpwiedemann]

Thanks Jan.