>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.

Well, you can use the Select-Statement at Form.load Event!!

Then, set the grid1.recordsource = BKCATS in Form Designer!!
^__^; bkcats is only lened 6!! Sure enough la!!

Because event fire seq. :

Form.load
form.txt1.init
form.txt2.init
form.init
....
but for release is different!!
form.destory
form.txt1.destory
form.txt2.destory
form.unload
....

For more detail, try Event trace in Debug!! ^_^;