this.recordsource = "myProjectSearch"

hth?

stuart

> -----Original Message-----

> From: Brian Robichaud [mailto:jbr@bretech.com]

> Sent: 31 August 1999 16:17

> To: Multiple recipients of ProFox

> Subject: RE: VFP6 -> delete a table... clarification?

>

>

> Thanks for the suggestion Cindy and Cliff.

>

> On your advice, I read up on cursors (I'm still an utter

> newbie when it

> comes to VFP & XBase in general, but I have to get the app

> built ;) ) and

> you are right... they are the right tool for this job... my

> only problem is:

>

> create cursor myProjectSearch ;

> (mystatus c (1), myrep L, myjobdate D,

> myloc c (50), mydesc c (50))

>

> INSERT INTO myProjectSearch

> (myStatus,myrep,myjobdate,myloc,mydesc) VALUES

> ('T',.F.,date(),'Here', ;

> 'Project Management Software Testing')

> SELECT myProjectSearch

>

> this.recordsource = myProjectSearch && <- this generates a "variable

> MYPROJECTSEARCH is not found" error

>

> If I comment out the recordsource line, the grid gets

> populated with values

> from another table.

>

> How do I let the recordsource know that it is an alias to a cursor?

>

>

>