VFP 愛用者社區

[yctsai]

1.請教各位先進,謝謝
2.我用VFP6.0中文版
3.起因: listbox 的 rowsource='tmp',而tmp檔是根據user的條件會產生的資料檔,因此listbox顯示tmp檔的內容
4.問題: tmp檔改變,listbox顯示也改變,非常好用,但是偶爾(也許30次出現1次)會出現 "無法存取選定的資料表格"
按確定後一切ok,經查MSDN是"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."
5.小弟研究1年,百思不得其解,望高手賜教,不勝感激

[marvin]

有沒有用 VFP9 的 Help 提到的方法試試 ?

Cannot access the selected table (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. This error can occur under the following conditions:

A table or cursor that is specified for the RowSource property of a ComboBox or ListBox control is closed.

If you want to close a table or cursor that is specified for the RowSource property of a ComboBox or ListBox control, perform either of the following actions prior to closing the table or cursor:


Set the RowSource property to an empty value ("").


-OR-


Release the form containing the ComboBox or ListBox control.


A SQL SELECT statement that recreates a table or cursor that is specified by the RowSource property is issued. When the SQL SELECT statement executes, Visual FoxPro closes then opens the table.

To avoid this error, set the RowSource property to an empty value (""), issue the SQL SELECT statement, and reset the RowSource property to its previous value.

[yctsai]

感謝!!原來vfp9 help有提到解決方法,我試試看

[bin1x]

光看那個訊息
我會想到
files 的開檔個數config
以及config.fpw好像可設定有關變數的size 及大小
以前是config.fp
最主要應該是開了檔案沒有關
但如果只有一個名字(tmp) 就算是select 產生出來應該會覆蓋
我覺得啦

[andywilliams]

Cannot access the selected table
=listbox Cannot access the tmp table
=listbox無法存取 tmp table
ex: zap,use..tmp be closed
sol: rowsource=""
sele tmp
zap
.....
rowsource="tmp"