What's wrong with

create cursor c_mycursor (name c(30), age n(3))

select name, age from mytable into mycursor

select c_mycursor

append from dbf('mycursor')

then you can

index on name tag name
index on age tag age additive

and allow the users to switch between the two (no so easy with a select statement)

append blank
zap
..... any other table functions


David.

>select name, age from mytable into mycursor
>
>select mycursor
>append blank -> error cannot update cursor !!
>
>What to do !! i need to insert a few rows
>
>Thank to you ALL
>
>João