Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Command to use view?
Message
 
To
03/03/2010 17:04:31
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01452348
Message ID:
01452378
Views:
42
>>>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)
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?

"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare

"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform