SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SA: 12.3.427 64-bit editor thows exception on open/close

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SA: 12.3.427 64-bit editor thows exception on open/close
Author Message
Mindflux



Joined: 25 May 2013
Posts: 805
Country: United States

Post SA: 12.3.427 64-bit editor thows exception on open/close Reply with quote
Execute: Error (1):
near "s": syntax error;

INSERT INTO documents(app_id, order_id, file_name, display_name, saved, opened, locked, pinned, process_id, conn_info, last_backup, last_SCS, state) VALUES(2, 1, '~220F851E.sql', 'SQLQuery1.sql', 0, 1, 0, 0, 12424, 'dbtype=1;dctype=2;connected=0;fmt_rules=Name's Custom T-SQL Style;snips_rules=Name's Snippets;rf_rules=SQL Server Refactoring;sql_ref=65536', '', '', '') RETURNING ID


If I had to guess it's because you aren't escaping the apostrophes in my snippet rules group..(bolded)
Fri May 05, 2023 9:52 am View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 805
Country: United States

Post Reply with quote
Can confirm if I take out the apostrophes, the error goes away.
Fri May 05, 2023 11:03 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
Thank you. I will log that issue. I believe your assessment is correct. in 12.3 the edited document change history is now saved to a database
Fri May 05, 2023 11:09 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.