problem with cursor files

[fluppe689]

Hello Experts,

This will probably easy but i don't know the answer

I have 2 cursor files coming from 2 selects.

I want to do the following
replace in cursor file 1, record 1, zone 3 with zone5 from cursor file 2 record 1
and then the same whit record 2 from file 1 with record 2 from file 2, ...


Wfg,

Filip

 

[bborissov]

Put READWRITE clause at the end of the SELECT

Borislav Borissov
VFP9 SP2, SQL Server

 

[fluppe689]

Hello Borislav,

That is not my problem.
My problem is how to replace zone xxx from cursor file 1, RECORD ONE with zone yyy from cursor file 2, RECORD ONE and then from file 1 RECORD TWOO with file 2 RECORD TWOO, RECORD 3(file1) with RECORD 3(file 2)

So my problem is basically how to find record number in cursor file


Wfg,

Filip

 

[Mike Lewis]

So my problem is basically how to find record number in cursor file

Exactly the same as in any other table.

You can use GO to go to a specific record, and RECNO() to find the record number of the current record.

Mike



__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[fluppe689]

Mike, Boris

Thank you very much, I should have known this, using allways go bottom and go top!!!

Wfg,


Filip

 

[Dan Freeman]

It sounds to me like this is a perfect use for SET RELATION TO RECNO().

Select Cursor1
Set Relation to Recno() into Cursor2
Replace all cursor1.zone3 with cursor2.zone5
Set Relation To