Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to Hide Cursor in Sql select in ComboBox
Message
 
To
15/03/2002 08:11:14
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00632222
Message ID:
00633778
Views:
18
Cetin,

Thnks for your help on Combo Boxex and File naming.

Gerard



>Gerard,
>It'd be OK. Cursor is actually created with a unique generated file name.
>Only you shouldn't try to create another cursor with same name in your form (it'd be used by combo only). If you use private datasession (recommended) you could use the same name on another form or part of your app but not within this form. If using default datasession be sure you don't use this name anywhere else and you don't launch another instance of this form.
>You'd quickly notice that when you get a 'Cannot access the cursor' or similar.
>With private datasession it's easy and you could open as many instances of this form :
>-In the same VFP session
>-Multiple VFP sessions
>-Multiple users
>-Combination of above
>w/o fear.
>
>When base data changes and you need a repopulation all you need is myCombo.requery()
>
>Cetin
>
>>Cetin, thanks for your reply.
>>
>>If I include the Into cursor MyCursor, and two people run this at the same time,
>>will this be ok i.e. will it cause any problems with similar cursor names ?
>>
>>Regards,
>>
>>Gerard
>>
>>
>>
>>
>>>>Hi.
>>>>I've set up a combo box with Row Source Type = 3(Sql) and RowSource = Select Myfield1,Myfield from Mytable
>>>>
>>>>This popilates combo fine but as I am going into form I can see a browse of the records selected.
>>>>
>>>>Is there a way to disable this. I ust want the records to be dumped into the combo for lookup purposes
>>>>
>>>>Regards,
>>>>
>>>>Gerard
>>>
>>>Gerard,
>>>Add destination.
>>>
>>>.Rowsource = 'select ... from .. into cursor crsCombo'
>>>Cetin
Previous
Reply
Map
View

Click here to load this message in the networking platform