SQL as rowsource in listbox VFP 5.0 
Author Message
 SQL as rowsource in listbox VFP 5.0

I have been using SQL queries like :
   SELE * from aliasname into table mylist1
as the rowsource in my listbox and combobox controls in forms using
Visual Foxpro 5.0 and everything has worked fine until now.  Suddenly
after going away from the form (in a multi-form formset) - that is,
hiding after showing and then showing the form again, I am geting :
    Cannot Access Selected Table
errors when I attempt to show the form again.   Have I outgrown the
number of sql tables I can have open at one time - maybe 20 or so, or
the number of listbox controls with SQL queries as their rowsource that
can be used in a formset?  I went and set up one query before loading
the formset to handle several listboxes that were using the same data
and the problem went away,  but these lists need to be up to date at all
times.

All I could find on the MS website KB about the issue was to not set
Itemtips to .T. when using datasession type 2.  I am using datasession
type 1 and Itemtips is set to .F. for all of these controls.

Any help or insights appreciated!
Stan Symms
Futzer Avenue Consulting



Thu, 15 Feb 2001 03:00:00 GMT
 SQL as rowsource in listbox VFP 5.0

this might be a bug, I don't really know because I don't use formsets and
use
pageframes instead and not had any such problems

but, the error message which like the itemtips problem (BTW was fixed
in 6.0) is related to the table that the listbox needs is not the selected
work area
when the form is shown again

as a workaround, unless you can find something better, would be to ensure
that the table that the listbox needs is the selected workarea when the form
is activated or reactivated using a flag to show that it is not the first
time or something like that

good luck

Quote:

>I have been using SQL queries like :
>   SELE * from aliasname into table mylist1
>as the rowsource in my listbox and combobox controls in forms using
>Visual Foxpro 5.0 and everything has worked fine until now.  Suddenly
>after going away from the form (in a multi-form formset) - that is,
>hiding after showing and then showing the form again, I am geting :
>    Cannot Access Selected Table
>errors when I attempt to show the form again.   Have I outgrown the
>number of sql tables I can have open at one time - maybe 20 or so, or
>the number of listbox controls with SQL queries as their rowsource that
>can be used in a formset?  I went and set up one query before loading
>the formset to handle several listboxes that were using the same data
>and the problem went away,  but these lists need to be up to date at all
>times.

>All I could find on the MS website KB about the issue was to not set
>Itemtips to .T. when using datasession type 2.  I am using datasession
>type 1 and Itemtips is set to .F. for all of these controls.

>Any help or insights appreciated!
>Stan Symms
>Futzer Avenue Consulting




Thu, 15 Feb 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Problem: SQL in listbox's RowSource??

2. VFP 5.0 Running Listbox

3. VFP 5.0 listbox help

4. Listboxes in VFP 5.0

5. vfp 5.0 listbox/view requery problem

6. Stored Procedure as rowsource for listbox problem

7. Stored Procedure problem as rowsource for listbox

8. MSAccess ADO data to MSWord Listbox rowsource problem

9. listbox rowsource stored procedure parameter

10. VB 5.0 and VFP 5.0 compatible?

11. VB 5.0 and VFP 5.0

12. VB 5.0 Data Bound Controls and VFP 5.0 Databases


 
Powered by phpBB® Forum Software