Brian

a Cursor is created in memory only so to refrence any cusror call on the

dbf() function

example

this.recordsource = dbf('myProjectSearch')

if you were to look at the dbf() return value, Fox crates a temporay

table in the temp dir (as default or specified with set temp) with a sys

generated name that will be different each time a cursor is created

create curs mycurs(fld1 c(12))

?dbf('mycurs') yeilds C:WINDOWSTEMPW5C3006I.TMP

HTH

Allan

allan_lindgren@starkey.com

Brian Robichaud wrote:

>

> 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

[snip]

--

If you offer me a penny for my thoughts,

and I give you my two cents worth,

Who gets the change?