Hi Dragan,
You're right, I should have specified no active index. I was addressing the original question. Here is the code. What index is active?
Create Cursor temp (int1 i, num1 n(4,0))
DO WHILE recno() < 10
Insert Into temp (int1, num1);
Values (RECNO(),RecNo()*10)
ENDDO
>>Hi Tamás,
>>
>>From help on INSERT
>>Appends a new record to the
end of a table that contains the specified field values. I
think that the current record stays the same.
>
>It adds it to the physical end of table, but if there's an active index, it may not be at eof() at all, depending on the current key value, because the record will be wherever the key value puts it in the current order. The recno() will be equal to recc() on an unbuffered cursor, or negative on a buffered one.
Regards,
Mike
"We try to solve the problem by rushing through the design process so that enough time is left at the end to uncover the errors that were made because we rushed through the design process."
- Glenford Myers
If you're going through hell, keep going. - Walt Disney
