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

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

Thank you Dave,
Your suggestion was the answer.
I had left some remnant data in the code from other testing causing me
the problem.

Definitely nominate this for "most obscure feature" in SQR?

I appreciate your help.

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 10:42 AM
To: SQR-USERS@list.iex.net
Subject: Re: FW: record count must be a multiple of #block_size


Gosh, Lorraine,

I took your code and got the same error you reported.

I then moved the minus sign and the error went away.  Actually, since I
didn't have any data, I got a divide-by-zero error.

The error message points to the ,0) because it's the last line of the
statement.  SQR always does that, even if the error is somewhere above in
the same statement.

I'm running SQR v6.  What about you? Can someone else try this?

Dave


At 09:43 AM 9/16/2001 -0800, you wrote:
>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


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