Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement