Re: FW: record count must be a multiple of #block_size

[Ambrosio Lorraine RDOG <Lorraine.Ambrosio@TECKCOMINCO.COM>]

Dave,

If I understand you correctly, I moved the  minus sign(-) to the beginning
of the next line but I'm still
getting the same error which seems to be pointing to .... , 0)...

let     #record_num = (#file_dtl_entries + (2 * #batch_#) + 2)
if      mod(#record_num, #block_size) != 0
        let     #block_count = 100
                        round(  (#record_num
                              - mod(#record_num, #block_size) +
                                #block_size) /
                                #block_size
                           , 0)
else
        let     #block_count = round(#record_num / #block_size, 0)
end-if

Thanks,
Lorraine A. Ambrosio
DBA/Systems Developer
Red Dog Operations
Teck Cominco Metals Ltd.

Phone:  (907)426-9143
FAX:    (907)426-2177
Email: lorraine.ambrosio@teckcominco.com


-----Original Message-----
From: David Donnelly [mailto:Dave@ISISBIO.COM]
Sent: Sunday, September 16, 2001 9:26 AM
To: SQR-USERS@list.iex.net
Subject: Re: FW: record count must be a multiple of #block_size


Dear Lorraine,

In the infancy of SQR, a statement had to be on one line.  Or, you could
continue it by ending the first line with a hyphen.

Move the "hyphen" (minus sign) from the end of the fourth line to the next
line.

Shall we nominate this for "most obscure feature" in SQR?

Dave




At 07:08 AM 9/16/2001 -0800, you wrote:
> > -----Original Message-----
> > From: Ambrosio Lorraine   RDOG
> > Sent: Saturday, September 15, 2001 5:38 PM
> > To:   'SQR-USERS@list.iex.net'
> > Subject:       record count must be a multiple of #block_size
> >
> >
> >
> >       I sure would appreciate some help with this.
> >       I'm modifying an old program (pre: 1998, written prior to current
> > version)
> >
> >       I get an SQR 4013 - missing operator in expression error with the
> > following code.
> >
> >       let     #record_num = (#file_dtl_entries + (2 * #batch_#) + 2)
> >       if      mod(#record_num, #block_size) != 0
> >               let     #block_count =
> >                              round(  (#record_num -
> >                                      mod(#record_num, #block_size) +
> >                                      #block_size) /
> >                                      #block_size
> >                                  , 0)
> > *** missing operator in expression
> >       else
> >               let     #block_count = round(#record_num / #block_size, 0)
> >       end-if
> >
> >       Thanks very much,
> >
> >       Lorraine A. Ambrosio
> >       DBA/Systems Developer
> >       Red Dog Operations
> >       Teck Cominco Metals Ltd.
> >
> >       Email: lorraine.ambrosio@teckcominco.com
> >


Dave Donnelly           <dave@isisbio.com>
ISIS BioComp            phone (909) 677-2446      fax (781) 207-5533