[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] easy question??

Don, you are correct.  I had confused the code with the following older
syntax, which does still work.

let $Table =  'PS_ADDRESSES A'

Begin-Select
A.ADDRESS1
A.CITY
A.COUNTY
A.STATE
A.POSTAL

    Show $Table ':  ' &A.ADDRESS1 '  ' &A.CITY  '   '  &A.COUNTY '   '
&A.STATE  '  ' &A.POSTAL


FROM [PS_PAY_CHECK A :  $Table]
WHERE  A.emplid = $Emplid
End-Select



Thanks,
 
Bruce


-----Original Message-----
From: Don Mellen [mailto:donm@ontko.com] 
Sent: Monday, August 18, 2003 10:40 AM
To: 'sqr-users@sqrug.org'
Subject: RE: [sqr-users] easy question??


Bruce,

I think you may have deleted the wrong line.  I've seen 

  FROM [$LedgerClause] AA,

work, and I've seen 

  FROM [$LedgerClause],   !where $LedgerClause = 'PS_table AA'

work.  I have never seen  

  FROM [$LedgerClause AA],

work, nor did it when I tested it, just to make sure.

On Fri, 15 Aug 2003, Bruce Kelling wrote:

> I have seen both of the following used successfully.  Add the -s flag 
> to sqr command line to show cursers. FROM [$LedgerClause AA],
> FROM [$LedgerClause] AA,
> 
> 
> Bruce
> 
> 
> -----Original Message-----
> From: the dragon [mailto:ceprn@hotmail.com]
> Sent: Friday, August 15, 2003 1:49 PM
> To: sqr-users@sqrug.org
> Subject: [sqr-users] easy question??
> 
> 
> If I want to assign an alias to a dynamic table in the form, where do 
> I put
> the alias designation??
> 
> FROM [$LedgerClause AA],
> FROM [$LedgerClause] AA,
> FROM [$LedgerClause], where $LedgerClause = 'PS_table AA'

-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"

_______________________________________________
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