>Dear Sir,
>
>I want to append records between given numbers.
>For example the values must between FirstNo=50 and LastNo=175
>How is it possible?
>
>range1=10
>FirstNo=50
>LastNo=175
>
>CLOSE DATABASES
>CREATE TABLE Random (cValue N(3))
>FOR nItem = 1 TO range1 && Append number of records in range1
> APPEND BLANK
> REPLACE cValue WITH 1 + 100 * RAND( )
>ENDFOR
>
>Please Help

range1=10
FirstNo=50
LastNo=175

CREATE TABLE Randoms (nValue N(3))
Rand(-1)
FOR nItems = 1 TO range1
  Insert into randoms values (Rand()*(m.LastNo-m.FirstNo)+m.FirstNo)
ENDFOR

Cetin