>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.
Look at the CURSORGETPROP() function. Specifically, the SourceType parameter.
George
Ubi caritas et amor, deus ibi est