RecordSourceType = 1=Alias vice 0=Table?????

Just guessing.

Mr. Jerry Cotton, MCP

2nd Marine Aircraft Wing Aviation Budget Analyst

MCAS Cherry Point NC

(252)466-2320 (252)466-4806(FAX) (DSN=582)

mailto:cottonjp@2mawcp.usmc.mil

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

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

>Sent: Tuesday, August 31, 1999 11:17 AM

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

>

>

>