System.Data.SqlClient.SqlException: 'Incorrect syntax near the keyword 'FUNCTION'.'

Question

System.Data.SqlClient.SqlException: 'Incorrect syntax near the keyword 'FUNCTION'.'

J L 26

I followed all the steps in the c# procedure "Create a Windows Forms user control that supports simple data binding" and it worked fine.
Then I did the same, but instead of one Usercontrol I created four, and whenever I click on the Save button (created automatically) I get the message

System.Data.SqlClient.SqlException: 'Incorrect syntax near the keyword 'FUNCTION'.'

I appreciate any help.

Viorel 125.8K Reputation points

2022-11-20T19:46:16.063+00:00

If you wrote an SQL query or script that contains FUNCTION (or there is a column called "FUNCTION") , then show some details.
J L 26 Reputation points

2022-11-21T12:53:22.777+00:00

Thanks. It seems the problem is connected to the table. There is a column called "FUNCTION" and that may not be a good idea. When I try with a different database it doesn't give me that error on saving, but it doesn't save any changes.

1 answer

Your answer

Viorel 125.8K Reputation points

2022-11-20T19:46:16.063+00:00

If you wrote an SQL query or script that contains FUNCTION (or there is a column called "FUNCTION") , then show some details.
J L 26 Reputation points

2022-11-21T12:53:22.777+00:00

Thanks. It seems the problem is connected to the table. There is a column called "FUNCTION" and that may not be a good idea. When I try with a different database it doesn't give me that error on saving, but it doesn't save any changes.

Answer 1

Viorel 125.8K

Try avoiding special names, or use "[ ]" if you write SQL commands manually. For example: select [FUNCTION] from MyTable.

J L 26 Reputation points

2022-11-21T13:10:41.293+00:00

Thanks a lot.

Share via

System.Data.SqlClient.SqlException: 'Incorrect syntax near the keyword 'FUNCTION'.'

1 answer

Your answer