Insert into cursor

[bon011]

Hi all,

I need to insert a new record into cursor on the end.
But it is always not in the end, why????

In table the new record is in the end but in the cursor no.

Any Idea?

 

[EzLogic]

obviously our cursor is readwrite, so, the append blank should always take you at the bottom of the cursor.

Ali Koumaiha
TeknoSoft Inc
Farmington Hills, Michigan

 

[skoko]

Do you have index created on cursor?

 

[rgbean]

As skoko hints at, if there is an active index on the RW cursor, then a new record will be added to the end of the cursor, but will "appear" to be where ever the index places it. You'll either need to create data that's logically "bigger" than the last record by setting the appropriate value(s) in the field(s) that the index uses, or use SET ORDER TO 0, and show the cursor in it's natural order.

Rick