Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Grid with cursor select problems
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement