USE a table over a network? (revised: not actually a network issue)
- kevclark64
- Posts: 127
- Joined: Thu Aug 15, 2019 7:30 pm
- Location: USA
USE a table over a network? (revised: not actually a network issue)
Robert, it seems that X# might be reading the entire contents of the DBC when a table in a DBC is opened. This seems to be the case because opening a table in a container with thousands of tables takes several minutes. Opening a table in a container with only about 100 tables happens pretty quickly. In Foxpro the numbers of tables in the DBC does not affect the time to open a particular table, so I'm not sure what the benefit of reading the entire DBC would be (assuming that is what the program is doing).
-
- Posts: 774
- Joined: Wed May 17, 2017 8:50 am
- Location: Germany
USE a table over a network? (revised: not actually a network issue)
Hi Robert,
It´s not about DBC files, it´s about pure DBFs that can´t be opened since the last build via the "dbfvfp" driver. I have already opened a ticket to reproduce the exception
https://github.com/X-Sharp/XSharpPublic/issues/326
The same happens with DBFs created by DBMax or by my FP-DOS
regards
Karl-Heinz
It´s not about DBC files, it´s about pure DBFs that can´t be opened since the last build via the "dbfvfp" driver. I have already opened a ticket to reproduce the exception
https://github.com/X-Sharp/XSharpPublic/issues/326
The same happens with DBFs created by DBMax or by my FP-DOS
regards
Karl-Heinz
USE a table over a network? (revised: not actually a network issue)
Kevin,
That is right. and will be changed in one of the next builds. That is why we described the DBC support as incomplete.
And I had no idea that people would have a DBC with thousands of tables. That does not make much sense to me to be honest.
Robert
That is right. and will be changed in one of the next builds. That is why we described the DBC support as incomplete.
And I had no idea that people would have a DBC with thousands of tables. That does not make much sense to me to be honest.
Robert
XSharp Development Team
The Netherlands
robert@xsharp.eu
The Netherlands
robert@xsharp.eu
-
- Posts: 774
- Joined: Wed May 17, 2017 8:50 am
- Location: Germany
USE a table over a network? (revised: not actually a network issue)
Hi KevinKevin Clark wrote:
The following line works with no problem:
use "ignatius2foxpromasterlistdbasetest-file2.dbf" new shared
It works as well to open from a local drive using a drive letter:
use "e:fpd26sqltest.dbf" new shared
i think it depends on by which tool a DBF was created.
attached are two dbfs
I´m pretty sure both dbfs will open within your VFP environment.
But are you able to open both with X# and the "DBFVFP" driver ?
regards
Karl-Heinz
- Attachments
-
- testdbfs.ZIP
- (288 Bytes) Downloaded 73 times