I have version 6.0.0.270 and below script fails to format. P

Provides intelligent code completion for SQL Server editors.

I have version 6.0.0.270 and below script fails to format. P

Postby gvarol@corelogic.com » Fri Aug 09, 2013 1:58 pm

[Post text removed on request of the user]
gvarol@corelogic.com
 
Posts: 66
Joined: Wed Mar 09, 2011 8:43 pm
Location: USA

Script fails to format

Postby gvarol@corelogic.com » Fri Aug 09, 2013 2:32 pm

[Post text removed on request of the user]
gvarol@corelogic.com
 
Posts: 66
Joined: Wed Mar 09, 2011 8:43 pm
Location: USA

Postby Aaron Law » Fri Aug 09, 2013 4:00 pm

It looks like SQL Prompt is tripping up on this bit of code:
WITH (FORCESEEK (1 (CntyCd, CdVal)))

As a work around you can delete that bit of SQL, format everything and then reinsert it.
We are planning on improving some of the prompt parser over the next few weeks so i'll make sure adding support for this is on our list.

Thanks,
Aaron.
Aaron Law
 
Posts: 561
Joined: Fri Jun 28, 2013 9:56 am
Location: Red Gate Software

Re:

Postby gvarol@corelogic.com » Fri Aug 09, 2013 4:33 pm

[Post text removed on request of the user]
gvarol@corelogic.com
 
Posts: 66
Joined: Wed Mar 09, 2011 8:43 pm
Location: USA


Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests

cron