Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
RowsourceTYPE
Message
 
To
26/08/2003 14:09:42
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00823528
Message ID:
00823535
Views:
20
>Hi timothy,
>
>>Is it good practice to have a combobox's rowsourcetype set to fields when the rowsource is a cursor? I am getting cannot "access selected table" frequently and thought this may be a possible cause.
>
>Well it is a good practice. However when doing a
SELECT ... FROM .... INTO CURSOR MyCursorBoundToCombo
, you might get this specific error as for one moment the cursor is closed and recreated again. To workarround the issue
>
>
THISFORM.MyComboBox.Rowsource = ""
>SELECT ... FROM .... INTO CURSOR MyCursorBoundToCombo
>THISFORM.MyComboBox.RowSource = "MyCursorBoundToCombo.Field1, Field2"
>
>HTH
>
Walter, That is basically what I have:
thisform.mycombobox4.rowsource=''
select * from office3 into cursor whichoff where not 'BO' $ office order by office nofilter
thisform.mycombobox4.rowsource='whichoff'
thisform.mycombobox4.selected(1)=.t.

Must be some other cause to why I get that pesky message.
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform