insert into <table>... does not work

Question

insert into <table>... does not work

Closed this issue 4 years ago · 6 comments

Hi,
For me I get:
"Unknown problem generating insert." when I save a QueryFirstQuery file with "insert into

...". I have tried it for multiple tables with the same result. It is a .net core console application in VS2019. "Update

..." is working fine. The database is SQL server 2014.

Answer 1 · 2019-12-18T09:28:48.000Z

Just a hunch...can you make sure your tables have Primary Keys.

Answer 2 · 2019-12-18T10:35:28.000Z

Hi, all the tables have primary keys (not auto_increment) but they are multi column primary keys, could that be the issue?

Answer 3 · 2019-12-18T14:53:51.000Z

Most likely. The 'auto' insert generator needs to know which column to use as the return value's name and data type. It does this by looking for the identity column. Otherwise, just construct the insert statement manually and not try to auto generate it.

Answer 4 · 2019-12-19T01:11:00.000Z

oy oy oy. I haven't looked at this for a while, and the generation is done with SQL, when I would be much more comfortable doing it in C#. I will have a look at this v.soon. Thanks for raising the issue.

Answer 5 · 2020-04-29T00:54:53.000Z

This is completely rewritten in the 1.1.0 release.

Answer 6 · 2020-04-29T07:08:26.000Z

I see market place has been updated, awesome, thanks! 👍