Visual FoxPro 9.0 写入 FoxPro 2.6 表

发布于 2024-10-15 07:08:59 字数 286 浏览 3 评论 0原文

我正在尝试使用旧的物料清单系统将零件导出到会计系统,以便我可以消除办公室文书工作中的一些冗余。两者都是用 FoxPro 2.6 for Windows 编写的。我有一份 Visual FoxPro 9.0。我知道我可以毫无问题地读取 Visual FoxPro 9.0 中的表格。我可以在 VFP 9.0 中写入较旧的 2.6a 表而不损害它们吗?我最初尝试用 java 实现这个,但在我的研究中,似乎用 VFP 本地编写它会更容易。任何对此的见解将不胜感激。我也知道这是一个古老的系统,我正在尝试更新,但目前这是一个快速修复。稍后将对系统进行更全面的升级。

I'm trying to get an older Bill of Materials system to export parts to a Accounting system so that I can eliminate some redundancies in paperwork for an office. Both are written in FoxPro 2.6 for Windows. I have a copy of Visual FoxPro 9.0. I know I can read from the table in Visual FoxPro 9.0 without a problem. Can I write to the older 2.6a table without harming them in VFP 9.0? I originally tried to implement this in java but in my research, it seems like writing it natively in VFP would be easier. Any insight into this would be much appreciated. Also I know this is an ancient system I am trying to update but, it is a quick fix for now. Later there will be much more sweeping upgrades to the systems.

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(3

成熟的代价 2024-10-22 07:08:59

要为 Stuart 的答案添加更多细节,您可以修改表中的数据,而不将其格式更改为较新的 VFP9 格式。但是,有些操作会更改其格式,包括添加空支持、添加新字段类型之一的字段或将表添加到数据库。只要远离此类命令,就不会有任何问题。

VFP9 帮助主题“表文件结构(.dbc、.dbf、.frx、.lbx、.mnx、.pjx、.scx、.vcx)”有很多关于

To add a little more detail to Stuart's answer, you can modify the data in the table without changing its format to the newer VFP9 format. However, there are some operations that will change its format, including adding null support, adding a field of one of the new field types, or adding the table to a database. As long as you stay away from such commands, you shouldn't have any problems.

The VFP9 Help topic "Table File Structure (.dbc, .dbf, .frx, .lbx, .mnx, .pjx, .scx, .vcx)" has a lot of info about the

那小子欠揍 2024-10-22 07:08:59

是的,FoxPro 向后兼容,因此您可以写入旧表。如果需要复制,则需要指定类型:

COPY TO c:\mytable.dbf TYPE FOX2X

Yes, FoxPro is backwardly compatible so you can write to the older tables. If you need to make a copy you need to specify the type:

COPY TO c:\mytable.dbf TYPE FOX2X
2024-10-22 07:08:59

可能需要了解的是,并非所有数据类型都以 Fox2x 格式提供;这些字段类型将被重新映射。

在 FoxPro2.x 中,以下常见类型不存在并已更改:

Datetime -> Date
Integer  -> Numeric(11)
VarChar  -> Memo

It may be relevant to know that not all data types were available in the Fox2x format; These field types will be remapped.

In FoxPro2.x the following common types do not exist and are changed:

Datetime -> Date
Integer  -> Numeric(11)
VarChar  -> Memo
~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文