Visual FoxPro 9.0 写入 FoxPro 2.6 表
我正在尝试使用旧的物料清单系统将零件导出到会计系统,以便我可以消除办公室文书工作中的一些冗余。两者都是用 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 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
要为 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
是的,FoxPro 向后兼容,因此您可以写入旧表。如果需要复制,则需要指定类型:
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:
可能需要了解的是,并非所有数据类型都以 Fox2x 格式提供;这些字段类型将被重新映射。
在 FoxPro2.x 中,以下常见类型不存在并已更改:
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: