search

fulcrologic / fulcro-rad-sql

SQL Plugin for Fulcro RAD
MIT License
4 stars 12 forks source link

SQL Server: NEXTVAL vs NEXT VALUE FOR #13

Open danskarda opened 2 years ago

danskarda commented 2 years ago

My client uses (Azure) SQL Server so I want to add support in fulcro-rad-sql.

One of the issues I encountered was during insertion of new rows. It fails due to SQL syntax differences. It seems that ANSI standard is NEXT VALUE FOR sequence while PostgreSQL syntax is NEXTVAL(seq). Surprisingly MS SQL Server follows ANSI here.

Patch and more issues will follow.