Is status a 1-character field?
-myron kirby-
===========================
>Hi all...
>
>I have a pageframe on a form. (VFP 5.0 SP3) On one of the pages, I have a grid. In the init event for the page, i have the following...
>
>*
>with this.grdgrid1
>.recordsourcetype = 4
>.recordsource = "SELECT sonum, promdate, partno, ordqty, ordwt, ordlen, status FROM bronze!so " + ;
> "WHERE partno = partno.partno and status $ 'OP' " + ;
> "INTO cursor tCommited"
>
>.columncount = 7
>.column1.header1.caption = "S.O. No."
>.column2.header1.caption = "Promised"
>.column3.header1.caption = "Part No."
>.column4.header1.caption = "No. Bars"
>.column5.header1.caption = "Est. Lbs"
>.column6.header1.caption = "Length"
>.column7.header1.caption = "Status"
>.refresh
>endwith
>*
>
>The table PARTNO is pointing to a valid partnumber that has records in the SO table, i.e. status = 'O'.
>
>The grid comes back empty. If I remove the clause "and status $ 'OP' " then I get a grid with what I'd expect.
>
>Is there an issue with compound where clauses on cursor selects? If i enter the command at the command line, It works great! Any ideas or workarounds will be greatly appreciated.
>
>-Swen