General information
Category:
Coding, syntax & commands
Thanks for your answer but if the INSERT sould do what you said, then in the following example the "SKIP" should make every second record leave out.
Create Cursor temp (int1 i, num1 n(4,0))
DO WHILE recno() < 10
Insert Into temp (int1, num1) Values (RECNO(),RecNo()*10)
SKIP
ENDDO
It is because when the recno() is evaluated first and the INSERT fills the first record and moves the record pointer to the next one, the SKIP should moves the record pointer to the following record so the actual record pointer is now on the the third record. Am I thinking right?
No.
INSERT fills the first record and moves the record pointer to the next one
- VFP evaluate the INSERT VALUES
- go to the RECCOUNT()+1 position
- add a record with the values.
- the record pointer is not move
the SKIP should moves the record pointer to the following record so the
actual record pointer is now on the the RECCOUNT()+1 record.
Fa
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only