Strange error in insert

BIZ TMS Aurelius
1

Hello,
during the phase of insertion in the tables of a postgres db I encounter this problem:
this exception is raised:
[FireDAC] [Phys] [PG] [libpq] ERROR: syntax error at or near "ON"

The postgres log report:
"STATEMENT: SET NOCOUNT ON;
DECLARE @AureliusOutputTbl TABLE (ID INT);
INSERT INTO doctor.name (
version, tax_code, surname, date_of_birth, name, if_homocodia, if_web, gender, title, if_external_professional, if_external_professional_registration, medical_id_online_registration, pec_per_registration, first_city_id, municipality_id, nation_id, province_id)
OUTPUT INSERTED.id INTO @ AureliusOutputTbl
VALUES (
$ 1, $ 2, $ 3, $ 4, $ 5, $ 6, $ 7, $ 8, $ 9, $ 10, $ 11, $ 12, $ 13, $ 14, $ 15, $ 16, $ 17);
SET NOCOUNT OFF;
SELECT ID From @AureliusOutputTbl;
ERROR: syntax error at or near "ON" at character 13"

This error is raised for all tables I attempt to write, searches do not raise errors.

I have many projects made with Aurelius and Postgres and it is the first time that I have errors like this

Regards

2

My guess is that you have incorrectly set your connection dialect as MSSQL, not Postgres. Such statement (SET NOCOUNT ON) is used for MS SQL Server databases.

3

Thanks for the tip, check it out now.!!

1 Like