>Thank you. Something like:
>
>CursorGetProp( "SourceName", alias() )
>
>returns the view's alias. That is part of what I am currently using. Without some hard coded list of view aliases I still can't make the determination of whether it's a Table, View, or Cursor.
>
CursorGetProp('SourceType', ALIAS()) returns a numeric variable that distinguishes the type of record source for an alias. From the VFP Help on CursorGetProp():
SourceType N 1 – Specifies that the data source is a local SQL view.
2 – Specifies that the data source is a remote SQL view.
3 – Specifies that the data source is a table.
Read-Only.
A Cursor is not a member of a DBC(), nor is a free table, so I don't know what referencing such aliases will return, but it's a start point.