Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GetExpr - can it only see certain aliases
Message
 
 
To
26/10/2010 18:20:35
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01487027
Message ID:
01514751
Views:
44
>>Hi everybody,
>>
>>In the application we use GetExpr to allow to specify custom filter. This is called from a button in a form. Unfortunately, all tables and cursors that are opened in the form's DE, are visible in GetExpr dialog.
>>
>>Is there any way to hide the extra tables and only show the tables we want?
>>
>>Thanks in advance.
>
>I don't think that such an option exists explicitly. I would suggest you open a private datasession (perhaps with an object based on the Session class), specifically open the desired tables, and then use GETEXPR within the context of this data session.

I found that the way I implemented this (create a new session class and switching DS to this new object.SessionID) causes problems (can not access the table).

I'm wondering if there is a better way. I guess I will still need to instantiate a session based class, but I should not switch form's DS, I should instead invoke GetExpr as part of the class code. Or, possible, pass a reference of the class that invokes this session class - but this sounds a bit too complex....
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform