>Hello,
>
>>>My application need to create this temporary cursor, then change some data.
>>2. Select * .... Into Cursor tmp
>>USE (Dbf()) again alias tmpUpdatable
>It will produce error if cursor doesn't exist on your harddrive (but dbf()
>will report that the file does exist.) I spent some time tried to convince
>VFP to create cursor on harddrive (Force clause in SQL, selecting .t. as
>Dummy) but VFP doesn't want to waste my harddrive ;)
Vladimir, I've not had a problem with this.
USE dbf('tmp') again in 0 alias MyCursor
works fine, even when file('tmp.dbf') is .F. - no record on the hard disk. I use this technique regularly, and haven't had any trouble, whether or not the file is written to disk.