This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
This is extremely pedantic. Sorry.
I'm trying to isolate a test case for you guys, so I created the simplest Entity I could: no columns except the Id column. And I'm using the IdentityColumn IdentityGenerator. And I'm using Sql Server. When I create my entity and save it, the TraceLogger reports this SQL:
INSERT INTO TestEntities
And this throws the Exception: "Incorrect syntax near ')'."
Doing some investigation it seems that Sql Server doesn't like this syntax (but I was able to execute it in MySQL). It would prefer insert into TableName Default values Here's the post I found that in: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=91812
Of course, in real life who else would create such a ridiculous entity, on Sql Server using an identity column generator? This is not a real problem. And the workaround is simple: create a nullable dummy field that you don't even have to populate. But I found the bug, so I should report it. |
|
|
|
