RE: [sqr-users] sub-query question

["Bob Stone" <bstone@fastenal.com>]

dont line it up on the lefthand side.  It thinks that each thing on the left 
hand side is a new column/expression.  ident.  if that doesn't work, you can 
just use a subquery inside the table (nest a procedure).  

begin-select
spriden_id,
(select pebempl_pidm
        from pebempl
        where pebempl_pidm = spriden_pidm)  &pidm

from spriden
end-select 

-------------------------nest procedure
begin-select
spriden_id
  let $spriden_id = &spriden_id
  do get-peb-id( $spriden_id, $peb_id)

from spriden
end-select 

!procedure GET-PEB-ID:  used to get the pebid.
begin-procedure get-peb-id($sprid_in , :$peb_id_out)
begin-select
select 
pebempl_pidm
  let $peb_id_out = &pebempl_pidm
from pebempl
where pebempl_pidm = sprid_in
end-select
end-proceddure



-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of Amy
Eldridge
Sent: Tuesday, August 09, 2005 3:00 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] sub-query question



This is a fake query to illustrate my question.

I'm using a sub-query like this:

begin-select
spriden_id,
(select pebempl_pidm from pebempl where pebempl_pidm = spriden_pidm)  &pidm

from spriden
end-select

but I want to wrap the sub-query like this:

begin-select
spriden_id,
(select pebempl_pidm
from pebempl
where pebempl_pidm = spriden_pidm)  &pidm

from spriden
end-select
Why wrap it, you ask?  My sub-query is really long and I don't want to make 
it all one line stretching out to infinity.  In addition, SQR will only 
allow a line to be so long and my sub-query one big line exceeds 
that.  Thus, I want to wrap it.

When writing the above as a SQL query, wrapping is not a problem but when I 
try to wrap it in SQR, though, it is giving me an error:

Error on line 14:
    (SQR 3727) SQL expression not ended, perhaps parentheses not balanced.
from pebempl

It does not like that return after the "select pebempl_pidm".

Yes, I can use a separate procedure instead of the sub-query - I have lots 
of alternatives so don't pass alternative suggestions along, please.

I'm just curious if wrapping the subquery is possible.

Thanks in advance.

Amy Eldridge
Systems Analyst
Miami University (nope, the one in Ohio)

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users