You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Problem with query

2 replies [Last post]
krisvamsi2005's picture
User offline. Last seen 7 years 15 weeks ago. Offline
Joined: 03/11/2008
Posts: 17

Hi,

I have a problem with a query in a delivered SQR which looks some thing like this
begin-select
field1
field2
.
.
FROM [PS_JRNL_HEADER_FS A, PS_JRNL_LN_FS B,:$HEADER_AND_LINE_REC] [$Rec_Alt_Account]
where ;

Could any help me understand how the From clause works here

Many Thanks,
Vamsi

Thanks,
Vamsi Krishna

oddsnends's picture
User offline. Last seen 11 years 4 days ago. Offline
Joined: 03/28/2008
Posts: 16
Re: Problem with query

Which delivered SQR is this? I'm on HR but cannot find the string '$HEADER_AND_LINE_REC' in searching through the delivered sqr's and sqc's.

Normally the []'s will substitute/interpret an actual value for the $ variable. The colon (:) in front of the variable normally is a returned/passed value from a function though I have never seen it used in a from clause before. If you can provide the sqr I'll take a look at it some more.

krisvamsi2005's picture
User offline. Last seen 7 years 15 weeks ago. Offline
Joined: 03/11/2008
Posts: 17
Re: Problem with query

Hi oddnsends,

This is an SQR in finance. The delivered finance sqr is fin2002.sqr

Thanks,
Vamsi Krishna