VFP 愛用者社區

[jun02]

請教各位
我有一個系統是在Fox 2.6下開發的,我己用VFP改寫,但在VFP6或FOX 2.5b中開啟 DBF檔時會呈現亂碼,請問我要如何解決,期望各位相助,謝謝

[RORI]

foxpro 2.6 為英文版，建議先至foxpro 2.5B中文版中開啟並重新BULID後
再至VFP中改寫，或許可以解決，如真不行，那只有在foxpro 2.5B中文版中
另開TABLE後再APPEND進來了

[jun02]

謝謝您的回覆,我用2.5b rebuild 也無解,我有約200個dbf而且不在同一目錄下,如果只能用Append 那可慘了,不知誰還有其它方法

[syntech]

我猜是 因為 codepage 的關係,

聽說(help) 在 vfp 的 \tools\cpzero\cpzero.prg 可以用來校正 table的 codepage,
可以試看看

==================
Cpzero.prg
See Also Example

Located in the Visual FoxPro Tools\Cpzero folder, Cpzero.prg removes the code page mark from any file that has a table file structure. After removing the mark, Cpzero applies another mark that you specify.

Typically, you use Cpzero with files from other platforms or earlier versions of FoxPro. If these files do not have code page marks when you open them, Visual FoxPro prompts you for a code page. If you specify the wrong code page, however, the data in the files won't display properly. To correct the code page, use Cpzero.

Syntax

DO Cpzero [WITH "filename"[, codepage_number]]

Arguments

filename

Specifies the name of the file and must be delimited with single or double quotation marks. If filename is not included, a Locate File dialog box is displayed.

codepage_number

Specifies the desired code page number. If it is not included, the Code Page dialog box is displayed.

Note Before you run Cpzero on a table, make sure it is closed.

[RORI]

在FOXPRO 2.5B 中撰寫GEN DBF 程式
(有範例可循)，200個DBF應不算什麼