Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Determining which views are in use
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00186120
Message ID:
00186161
Views:
17
Jim,

Thanks, this was just what I was looking for.

Rob

>If you are using the DE you can try code like this;
>AMEMBERS(laCursors,Thisform.DataEnvironment)
>FOR lnCnt = 1 TO ALEN(laCursors,1)
> IF UPPER(EVALUATE( laCursors(lnCnt,1)+".BaseClass")) = "CURSOR"
> IF STR(CursorGetProp("SourceType",laCursors( lnCnt,1)),1,0) $ "12"
> * You have a view either remote or local
> ENDIF
> ENDIF
>ENDFOR
Previous
Reply
Map
View

Click here to load this message in the networking platform