Hi,

How about you try check your configuration for this particular configuration table 
Configure Form > Advanced > Configure Database Wizard > Advanced > Save data To (Database Wizard)

Database Wizard Form Data Store

Cheers!

Hi Ginger,

What kind of setting need to be done here? as my setting now is nothing extra set here. 

thanks.

Hi,
click to enlarge

Check that the table and column for the Save Data To is  being set properly.
This is to make sure that the form is ADDING and SAVING  data to the specified column in the specified table.

Let me know how it goes!

Hi Ginger,

The  Save Data To is  being set properly, the table and key column is correct.

Read, Update and Delete action working fine, just the Add action hitting the error 

org.joget.plugin.enterprise.DatabaseWizardStoreBinder - com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '`'.

I had try using MYSQL as my database with same DatabaseWizard setting, it work fine to all actions including ADD, only when i try on using MSSQL as database, it cause the error.

so does it mean the joget plugin enterprise DatabaseWizardStoreBinder had a syntax during generate INSERT SQL into MSSQL database?

Thanks

I see. Interesting. Might as well the plugin is not supporting mssql syntax ,MSSQL does not support backticks ( ) for quoting identifiers; instead, square brackets must be used. ([]).

Can I know the version of your mssql?
Just to check the compatibility. 
You can maybe check from here :  https://dev.joget.org/community/display/KBv5/Custom+Database+Configuration#CustomDatabaseConfiguration-RunningonOtherDatabases:~:text=Restart%20Joget.-,Running%20on%20Other%20Databases,-Joget%20also%20allows .

Version : SQL Server 2022

For now only compatibility until 2019 version?