Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Distinguishing a table vs a view at runtime
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Distinguishing a table vs a view at runtime
Miscellaneous
Thread ID:
00458469
Message ID:
00458469
Views:
41
Because our programs run on several different platforms, sometimes the data will exist as a Fox table and sometimes it will exist in SQL Server. For example, sometimes there will be a Fox table called ELIGIBLE. Other times the table will be in SQL Server and there will be a remote view called ELIGIBLE. Within a program, I need to USE ELIGIBLE and then do an IF statement that determines whether the ELIGIBLE is a table vs a view.

Example:
USE ELIGIBLE
IF ELIGIBLE (is a table)
(do Fox table stuff)
ELSE
(do SQL Passthru stuff)
ENDIF

How do you check in an IF statement whether ELIGIBLE is a table vs a view?

Thanks.
Next
Reply
Map
View

Click here to load this message in the networking platform