Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unique Cursor Names
Message
From
09/01/2001 05:28:14
Mark Hall
Independent Developer & Voip Specialist
Keston, Kent, United Kingdom
 
 
To
09/01/2001 04:45:17
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Miscellaneous
Thread ID:
00461047
Message ID:
00461057
Views:
19
>I have some classes that contain Listboxes and Comboboxes that use SELECT statements to obtain the lists.
>
>Whenever I use more than 1 class on a form, I would like it to SELECT into a unique cursorname to avoid any problems.
>
>So far, I've noticed you can't use SELECT INTO CURSOR (this.Name) as it errors, and I have tried writing a procedure called GetCursorName(), but it doesn't like that either.
>
>I know you can use PUBLIC variables to handle this, but I would rather not!
>
>Any ideas?
>Thanks
>Kev

Hi,

How about setting the RowSource property in the Init of the Listbox/combo then Requery() it.

i.e.
LOCAL lcCursor
lcCursor = GetUniqName()
THIS.RowSource = "SELECT * FROM Table INTO CURSOR " + lcCursor
THIS.Requery()
Regards
Mark

Microsoft VFP MCP
Menulib - OO Menus for VFP www.hidb.com/menulib
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform