>>>>VFP9: yes, VFP8: no.
>>>>
>>>Yes and the random problem can be solved in VFP9 in one insert command.
>>
>>I'm curious about how to solve also the random problem in one insert command(so how to insert randomly 300 records of the other table). Do you have any example code? I need it for something I want to do.
>>
>only VFP9
>
>
>INSERT INTO targettable ;
>SELECT S.* FROM sourcetable S join (SELECT TOP 300 PK,RAND() FROM sourcetable ORDER BY 2) X ON X.PK=s.PK
>
>
Nice, thanks.
If it's not broken, fix it until it is.
My Blog