How to copy structure from a cursor to new cursor 1

[paispatin]

I have CURSOR1, I want to copy the CURSOR1 structure to new cursor name CURSOR2.

When I try this one, the new cursor always locked:

SELECT * FROM cursor1 INTO CURSOR cursor2

SELECT cursor2
zap

It' will return error : Can not update the cursor cursor2, since it is read-only

So, anyone could help me how to copy CURSOR1 structure to CURSOR2 and then I can use CURSOR2 to add or delete data inside CURSOR2.

Thank you in advance.

 

[ChrisRChamberlain]

paispatin

[COLOR=blue]SELECT * FROM cursor1 INTO CURSOR cursor2 [b]READWRITE[/b][/color]

FAQ184-2483 - answering getting answered.​

Chris
PDFcommander^tm.com
PDFcommander^tm.co.uk

 

[Mike Gagnon]

Try :

SELECT * FROM cursor1 WHERE .F. INTO CURSOR cursor2 READWRITE

No need to zap, since its already empty.


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[paispatin]

Yes Chris, I get it. Thank you for your help.

 

[paispatin]

Yes Mike, It's better than using zap.
Thank you very much.

 

[Stefan5627]

For anyone who’s interested, here’s another way:

Select cursor1
Afields( ablep)

Select 0
Create cursor cursor2 from array ablep


Stefan