Page 2 of 2
USE a table over a network? (revised: not actually a network issue)
Posted: Mon Feb 17, 2020 5:21 pm
by kevclark64
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).
USE a table over a network? (revised: not actually a network issue)
Posted: Mon Feb 17, 2020 5:44 pm
by Karl-Heinz
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
USE a table over a network? (revised: not actually a network issue)
Posted: Mon Feb 17, 2020 5:51 pm
by robert
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
USE a table over a network? (revised: not actually a network issue)
Posted: Mon Feb 17, 2020 6:23 pm
by Karl-Heinz
Kevin 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
Hi Kevin
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