>>>>>hello
>>>>>i kno the usetable('table') and use [table] command lets u work with tables not in the DE. but is there one for Views as well?
>>>>
>>>>Yes, same commands for view (you can add NODATA option, though). Check Help for USE command.
>>>
>>>its the same?i subsittued the name of a table with one of a view...and that didnt work out
>>
>>You need to have open, or specify the database too.
>>
>>OPEN DATABASE myDB
>>USE myView
>>
>>OR
>>
>>USE myDB!myView
>>
>>(And if there are dependent tables outside the DB, you should open them first)
>>
>>(Assuming the DB is in the FP path)
>
>Neither of those commands work both tell me
>file MYDB.dbc does not exist

If the dbc isn't in your current path it won't find it.

Try OPEN DATABASE GETFILE()

then find your database.