Re: new to sqr

[Sam Spritzer <SSpritzer@GW.CTG.COM>]

John...
You might want to consider purchasing "SQR in Peoplesoft and other applications" by Galina and Vlad Landres.  You can find this excellent book at Amazon.
Sam

<<< John Haberin <jhaberin@AMRE.COM>  1/11 11:45a >>>
thank you for the tip




"Love, Kristin" <KLove@MSA.COM> on 01/11/2000 11:28:07 AM

Please respond to sqr-users@list.iex.net

To:   SQR-USERS@list.iex.net
cc:    (bcc: John Haberin/AmericanRe)
Subject:  Re: new to sqr




You have to move your commands that you are running in your Begin-Select
paragraph in at least one space, or it thinks its part of the SELECT.

Handy tip: run with the -S flag, and the parse of your SQL will appear in
the log file

HTH
:) Kristin

> -----Original Message-----
> From: John Haberin [SMTP:jhaberin@AMRE.COM]
> Sent: Tuesday, January 11, 2000 11:07 AM
> To:   SQR-USERS@list.iex.net
> Subject:      new to sqr
>
> Hi I am new to the sqr environment and I was following a example in the
> sqr
> manual and received this error message.
> (SQR3728) SQL expresion  not ended , perhap missing &name from ps_job.
> Here is
> the code.
>  Sqr run ok when comment out the do Print_Job from precedure Select_Job. I
> can
> not figure out what this error message means.
> Thank You.
> John-Haberin Amre- Insurance
>
> Begin-Program
> DO Init-DateTime
> DO Get-Current-DateTime
>   Do Select_Dates
> Do Main
>  ! let $first_time_sw = 'Y'
>  ! do Select_Report_Criteria
> End-Program
>
> !*********************************************
>   Begin-Procedure Main
> !*********************************************
> Do Select_JOB($from_num_dt , $to_num_dt)
> End-Procedure Main
>
> !*******************************************************************
> Begin-Procedure Select_Job($frm_parm_date, :$to_parm_date)
>
> !*********************************************************************
> show 'to_date selectjob = ' $to_parm_date
> show 'from date select job = ' $frm_parm_date
>
> Begin-Select
> EMPLID ( 1,2,11)
> !b.name  ( 1,15,40)
> DEPTID  ( 1,57,10)
        move this in->Do Print_Job
> From  ps_Job
> Where EFFDT  Between to_date($frm_parm_date, 'YYYYMMDD') AND
> to_date($to_parm_date, 'YYYYMMDD')
> End-Select
> !Show     ' Emplid = ' &EMPLID
> !Show 'dept = ' &DEPTID
> End-PROCEDURE Select_Job
> !******************************************************
> Begin-Procedure Print-Job
> Print &DEPTID ( 1,1)
> Print &EMPLID (, 2)
> End-Procedure Print-Job