Here's a fun one.

[GrayCat]

I built a temp cursor with a select statement.
Then immediately copy to a text file on the next line.
My cursor temp.field looses it's value. Has the value after the select, but not after the copy.

I simply moved my copy to a different place, but what is this about?

 

[rgbean]

If what you are saying it's something like this:

SELECT *,0 as dummy from test INTO CURSOR mycursor
? mycursor.field1 && prints value from first record
COPY TO dummy.txt TYPE sdf
? mycursor.field1 && prints nothing

Then this is right. The Copy moves the record pointer in the cursor to EOF, and at that point none of the fields in the cursor have a value. Add GO TOP (or GO 1, or LOCATE) after the copy, and you'll get the first record's data.

Rick

 

[GrayCat]

Thank you so much. Thank makes perfect sense.