>>I have a list box in a container on a form. The rowsource type=2 and rowsource=sos (sos is a cursor that holds distinct(ordernumbrs) range from 1 to 5 records. actualy I have 4 of the same type list boxes pointing to 4 different cursors. The list has no code, list for viewing only. Everything was working fine. I DID NOT TOUCH ANY OBJECT OR CODE associated with this container or the cursors. Now I am getting an error that says the database can not be accessed. It does exsit and there is data there. I have the same container pointing to the same data same name same everything in a different program that still works. If i change the name of the cursor and change the rowsource to the new name (stupid) everything works like before. Duh
>
>Some possible ideas:
>
>1. Have you checked with the debugger to see if SOS is open in another datasession?
>
>2. Could you tell us exactly what command gives the error message? Requery, refresh, etc.
>
>3. Did you change any OTHER code on the form?
>
>Hope this gives you a new direction - sorry it's not a solution
>
>Barbara
Barbara
1.SOS is open in the default Datasession and there is data there.
2. I don't get an error when the form is init so the list box can see the cursor at that point.
The error show up when I make the container visible.
This.Parent.visible=.f. && make current container invisible
select distinct(slono) as slono from temphold order by slono into cursor sos
ThisForm.Shipto.visible=.t.
thisform.shipto.refresh
The Error shows its ugly head at that point and if I click on the ignore button on meesage box the container becomes visible without the listbox.
3. I know its hard to buy but NO NO NO. I had tested this program several times with no problems. I had only gone back to run the program to put some meaninful data in for another program to use the data that this program generates.
As I said earlier I did a work around by creating another cursor and pointing to that instead of SOS and all went back to normal.
Thanks and I'm still scratching my head.
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com