hi,
thank you for reply, and advice.



>Index on rand(), copy the next 300 records to another table, and then append from that table.
>
>>hi,
>>sorry to bother you again,
>>i try to append random records as under ,not works
>>

>>total = 300
>>RAND(-1)
>>INDEX ON RAND() TO SYS(2023)+'\RANDOM'
>>*COPY TO moh111 NEXT &total
>>APPEND FROM rami3 for  upper(allt(sec_txt))=="ÞØÇÚ ÇáÔÄæä ÇáÝäíÉ æÇáÊÒæíÏ" NEXT &total
>>
>>SET INDEX TO
>>ERASE SYS(2023)+'\RANDOM'
>>

>>
>>thanks
>>>With all due respect Mohammed but did you even spend 2 seconds to try and understand why?
>>>
>>>>hi,
>>>>thank you for reply
>>>>i get error message
>>>>Command contains unrecognized phrase/keyword
>>>>
>>>>thanks.
>>>>>>hi all,
>>>>>>
>>>>>>any idea , help
>>>>>>i try to append new records to mytable, as under
>>>>>>
>>>>>>

>>>>>>Select * from rami3 ;
>>>>>> where inList( upper(allt(sec_txt)), "ÞØÇÚ ÇäÙãÉ ÇáãÚáæãÇÊ                                   ") ;
>>>>>> append blank;
>>>>>>   into table rami4 nofilter
>>>>>>

>>>>>>thanks
>>>>>
>>>>>You are mixing your SELECT with your APPEND. Rather do something like:
>>>>>
>>>>>

>>>>>SELECT rami4
>>>>>APPEND FROM rami3 WHERE inList( upper(allt(sec_txt)), "ÞØÇÚ ÇäÙãÉ ÇáãÚáæãÇÊ")
>>>>>