General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Distinguishing a table vs a view at runtime
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only