>>>>>>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.


oh yea it works but i moved it so the orginal code works man you guys >all