Re: No rows? SQR lets me down.

[Aya Fall <afall@NS.SYMPATICO.CA>]

Hi Christopher:

I think it would help a little better if you specified your platform.
The date format might also be a problem.

Aya.

Wanko, Christopher wrote:
>
> SQR returns no rows from this query.  In SQL, the WHERE clause against
> this
> particular table should return 1064 rows (or a count thereof).
>
> What's missing?
>
> -Chris
>
> --------------------------------------------
> Begin-Setup
>  Use max_db
>
>  Declare-Layout Default
>   Orientation=Landscape
>   Paper-Size=(11,8.5)
>   Top-Margin=0.5
>   Bottom-Margin=0.5
>   Left-Margin=0.5
>   Right-Margin=0.5
>   Line-Height=1       ! Define a 1 by 1 point grid for
>   Char-Width=1        ! precise print positioning
>  End-Declare
> End-Setup
>
> Begin-Program
>  Do Main
> End-Program
>
> Begin-Procedure Main
>  Move 0 To #_1ROW_COUNT
> Begin-Select
> wonum  (10,1,7)
>  Add 1 To #_1ROW_COUNT
> >From  workorder
> Where wopm1 LIKE 'IL9301'
> AND wo6 >= '1/1/1998'
> and wo6 <  '5/1/1998'
> End-Select
>  If #_1ROW_COUNT > 0
>   Print #_1ROW_COUNT             (10,1) Edit 99999na
>  End-If
> End-Procedure
>
> Begin-Heading 34
>  Date-Time (10,1) 'Mon DD YYYY'
>  Page-Number (10,699)
>  Print 'Wonum'                   (32,1,5) Underline  Bold
> End-Heading