I've the Pro Version 9.5.1 on Windows 10 and use MS SQL Server 2008 R2 Express.
I try to update data with inline edit, but after saving I get the Error:
Exception: Incorrect syntax near the keyword 'where'.
Here the generated update query:
SET LastRackId = 16263
WHERE ID = 1
I can't find any error.
The template is default:
When I copy the query and run it manually it works fine.
Whats wrong here?
Here the create table query:
CREATE TABLE ASS_JISFixdata
(ID INT NOT NULL IDENTITY,
MaxRacksTruck INT NOT NULL,
MaxRacksLine1 INT NOT NULL,
MaxRacksLine2 INT NOT NULL,
CONSTRAINT PK_ASS_JISFixdata PRIMARY KEY (ID));
I would like to use this feature.
I hope you can help.
Thanks and BR,
Please open Tools->Debug Window and enable debugging for DbVisualizer, and click the garbage can button to remove old log output. Perform the Save again and include the debug output in your reply.
So everything is fine now? If you edit the SQL templates you need to be very careful.