Re: [Squirrel-sql-users] Query runs only when all of its SQL is selected

[John H. <jh...@im...>]

On Thu, 21 Nov 2013, Alex Malmyguine wrote:

> I have a query that runs against MS SQL 2012 only when all of its SQL is selected.
> If I tried to run it with no selection, it would throw and error:
>
> Error: The multi-part identifier "pid.PI_LINE_NUMBER" could not be bound.
> SQLState:  S0001
> ErrorCode: 4104
>
> What am I doing wrong?

That usually happens when there are blank lines embedded in the query.

-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jh...@im...    FALaholic #11174     pgpk -a jh...@im...
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
   Vista is at best mildly annoying and at worst makes you want to
   rush to Redmond, Wash. and rip somebody's liver out.      -- Forbes
-----------------------------------------------------------------------
  539 days since the first successful private support mission to ISS (SpaceX)