Can you tell me in the first place, why do you want to append random records to another table?
Instead of copying to a cursor, you can also copy to a table. To avoid multiuser conflicts, assign a table name with sys(2015). Unlike the cursor, the table has to be erased explicitly.
Or perhaps you can use dbf("Cursorname") - cursors do have a corresponding table on disk.
>hi,
>thank you for every things,
>
>this code mean i get 4500 records only at mytable,
>if yes,i want to insert all records to new table
>
>i try to that but i get error message.
>Cannot update the cursor "cursor", since it is read-only
>
>
>CREATE TABLE &lcTableName (char1 C(10), char2 C(70),char3 C(10), char4 C(10),char5 C(10), char6 C(40),char7 C(10), char8 C(10),char9 c(10), fld10 datetime(40),char11 C(10), char12 C(60),char13 C(50), char14 C(40),char15 C(10), char16 C(10),char17 C(10), char18 C(70),char19 C(10), char20 C(10),char21 C(10), char22 C(40),char23 C(10), char24 C(10),char25 C(10), char26 C(70),char27 C(10), char28 C(10) NOCPTRANS)
>
>select * from amar66 where rand() < 4500 / 100000
>
>APPEND FROM (newamar66).
>
>
>
>regards.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)