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