USE a table over a network? (revised: not actually a network issue)

kevclark64 · Post by **kevclark64** » Mon Feb 17, 2020 5:21 pm

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).

Karl-Heinz · Post by **Karl-Heinz** » Mon Feb 17, 2020 5:44 pm

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

robert · Post by **robert** » Mon Feb 17, 2020 5:51 pm

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

Karl-Heinz · Post by **Karl-Heinz** » Mon Feb 17, 2020 6:23 pm

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