read write cursors 2

[Gilesy]

Hi All,

I am trying to create a read write cursor. Having searched these threads, sombody suggested the following:

SELECT * FROM v_products INTO CURSOR lcresult NOFILTER
USE lcresult IN 0 AGAIN ALIAS myTable
SELECT myTable && this will be readwrite

SO, i do this:
Select * FROM maintbl ;
WHERE maintbl.account= laccount AND !DELETED() INTO CURSOR temptbl nofilter
Use temptbl in 0 Again alias wkngtbl

And I get an error "temptbl.DBF not found"

I'm not creating a DBF so I don't understand this! Can any body shed any light on this?

Thank You

 

[Olaf Doschke]

Use temptbl searches a file temptbl.dbf, but thatis just the alias name. You need to Use dbf("temptbl") in 0 again.

Since VFP7 you can Select ... Into Cursor ... Readwrite.

Bye, Olaf.

 

[Mike Gagnon]

Try using this syntax

 Use dbf('temptbl') in 0 Again alias wkngtbl

[b][i]Mike Gagnon [/i][/b]

[i]If you want to get the best response to a question, please check out FAQ184-2483 first.[/I]
[url=http://www.mcrgsoftware.com/RefoxPage/English/MainFrameset_E.htm] ReFox XI (www.mcrgsoftware.com)[/url]

 

[Gilesy]

That's it! Thanks guys!!

Gilesy