Accessing cursor created by SQLPREPARE

[steinkebunch]

I'm using VFP6 to retrieve remote data from some Oracle tables. I can successfully retrieve the data into MyCursor using the command

SQLPREPARE(nConnectionHandle, cSQLCommand, "MyCursor&quot

However, when I try to use further code to manipulate MyCursor, such as

Use DBF("MyCursor&quot

or

Use ("MyCursor&quot

I get errors "File is in use." and "File Mycursor.dbf is not found" respectively. I guess since MyCursor is opened exclusively, the first error makes sense. I'm obviously missing something on how I am allowed to use a cursor created from a remote table. How can I use the cursor so that I can manipulate it (delete records, etc). Thanks in advance.

 

[spayne]

Instead of saying USE("MyCursor&quot, try SELECT("MyCursor&quot

-Steve

 

[ramani]

In the place of "USE" change it to "SELECT"
SELECT (MyCursor)
ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com

 

[GrigoreDolghin]

Hello.

The cursor is a temporary file on your hdd. It has a temporary name (something like 2ndf000a.tmp).

If you want to gain access to the cursor (for example, to obtain a writable copy of it), you have to use the following sintax:

USE DBF("mycursor&quot AGAIN in 0 ALIAS MySecondCursor

MySecondCursor is a writable copy. Anyway, the sintax you need is USE DBF("mycursor&quot.

Hope this helps.

Grigore Dolghin
Class Software
Bucharest, Romania

 

[jonscott8]

Just for clarification, SQLPREPARE() is not used to retrieve result sets. It simply passes the SQL command to the backend database for compilation. You must still issue SQLEXEC() to execute the SQL command(s).

SQLPREPARE(nConnectionHandle, cSQLCommand, "MyCursor&quot
SQLEXEC(nConnectionHandle)
WAIT WINDOW TRANS(RECCOUNT('MyCursor'))+' Records Returned.'

SET DELETED OFF
COUNT FOR DELETED() TO lnDeleted
WAIT WINDOW TRANS(lnDeleted)+' Records Marked for Deletion.'

DELETE ALL
COUNT FOR DELETED() TO lnDeleted
WAIT WINDOW TRANS(lnDeleted)+' Records Marked for Deletion.' Jon Hawkins

The World Is Headed For Mutiny,
When All We Want Is Unity. - Creed