copy an table to an crusor of table

[MdVries]

how can i copy a table to a new table or crusor

i want to copy the notes to

 

[alvechurchdata]

COPY TO will copy data to a table. Use SQL to copy into a cursor:

SELECT ... INTO CURSOR ...

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[MdVries]

I am seaching for a way to copy a table without locking the source table.

I have troubles when i do an select to the source table.

what for code should i use

my source table is "partij"

and my dest "crs_partij" or "tmp_partij

 

[MdVries]

maybe i need an virtual table?

 

[Mike Lewis]

I am seaching for a way to copy a table without locking the source table.

By default, the source table is not locked when you use COPY TO.

However, if you have executed SET LOCK ON, that would cause the table to be locked. Check to see if that's the case. If so, just issue SET LOCK OFF.

Mike




__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[alvechurchdata]

I am seaching for a way to copy a table without locking the source table.

Both COPY TO ... and SELECT ... INTO ... will do this. I've just tried this with two instances of Fox 8 on screen.

I opened Customer.dbf shared in both
I issued an RLock() in one window and got a lock on a record
Tried COPY TO ... and SELECT ... INTO ... in the other window
Both worked with no problem.

Then I tried again with an FLock() on the whole file and that worked too.

The only way I could get a failure was to open customer.dbf exclusive in one window. Is this what you are doing?

Geoff Franklin

http://www.alvechurchdata.co.uk