Hi,
I have a valid piece of SQL that will run from command
window, etc. When I try and plug it into the recordsource
property on a grid, blammo! GPF. VFP v 5.0 August 21, 1996
version.
Is there a limit on the string size on the recordsource property?
Here's mine:
SELECT 1, CATALOGNAME FROM CATALOG, PART, PARTCAT WHERE PART.PARTID = GBKID AND PARTCAT.PARTID = PART.PARTID AND CATALOG.CATALOGID = PARTCAT.CATALOGID UNION SELECT 0, CATALOGNAME FROM CATALOG WHERE CATALOGID NOT IN (SELECT C.CATALOGID FROM PARTCAT C, PART D WHERE D.PARTID = GBKID AND C.PARTID = D.PARTID) ORDER BY 2 INTO CURSOR BKCATS

I use this in a grid, with an option box as the first column, and
a textfield as second. Checked boxes indicate the part is in
the catalog.