>>Here is the english version:
>>
>>I have a form which has a few medium sized tables in the dataenvironment (20,000 records). In one of the methods in the form I create a cursor with approx 200 records. When I try to access this cursor I get ERROR 1152:
>>
>>'You have attempted to select a table outside the 32K work area range or are attempting to reference a file variable in a table that is not open.'
>>
>>What does this mean - 'outside the 32K work area'.
>>
>>thanks, AL
>Allan,
>
>The answer may be found in the details of how you , "try to access this cursor". Can you show us the code you are using to access the cursor?
Here is the code for the valid method of combobox - cboProvince:
thisform.province = alltrim(provlist.lcode)
Wait window "Building a list of cities - please wait . . ." nowait
if file("citylist.dbf")
select City from citylist where alltrim(citylist.lcode) = alltrim(thisform.province) and ! empty(city) ;
group by city order by city into cursor ficity
use in citylist
else
select City from fifile where right(transit,1) = alltrim(thisform.province) and ! empty(city) ;
group by city order by city into cursor ficity
endif
select ficity
go top
thisform.cbocity.rowsourcetype = 2
thisform.cbocity.rowsource = "ficity"
thisform.cbocity.value = ficity.city
thisform.lblcity.visible = .t.
thisform.cbocity.enabled = .t.
thisform.cbocity.visible = .t.
thisform.cbocity.setfocus()
*** everything works fine the first time I access this combobox. I have a button containing a method called 'newsearch'. the first few lines of code in this method are supposed are:
if used("ficity")
use in ficity **** this is where I get error 1152
endif
I'm not sure what I'm doing wrong here.
AL
Al Williams
Anola MB, CANADA