TOPIC:

Hi all,
if someone is interested: the attached application contains a class to permit an object oriented access to DBF files without using any VO compatible class.
There is also some code showing how to use this class.
Wolfgang

P.S. of course I'm open to suggestions, bug fixes, enhancements

Hi Wolfgang,

After import DBServerApp.viaef into Xide 1.17 and compile I have tihis error message (in attachments.

Juraj

Hi Juraj,

strange.... you can remove this class from the application, it is not more needed. Or you can simply change the build type to "Text".

Wolfgang
P.S. I have XIDE 1.23 and X# 2.2a and there it compiles

Hi Wolfgang,

after remove this class I have next error message (in atachments) in Form1:CreateDBFile..

oFieldList := List<RDDFieldInfo>{}
oFieldList:Add( RDDFieldInfo{ "FIELDC", "C", 10, 0, 0 } )
oFieldList:Add( RDDFieldInfo{ "FIELDD", "D", 8, 0, 0 } )
oFieldList:Add( RDDFieldInfo{ "FIELDN", "N", 10, 2, 0 } )
oFieldList:Add( RDDFieldInfo{ "FIELDL", "L", 1, 0, 0 } )
oFieldList:Add( RDDFieldInfo{ "FIELDM", "M", 10, 0, 0 } )

when I delete last "0" , copilation is OK.

Juraj

Juraj,
The last X# build has added an extra parameter in the constructor: this is the Flags field for VFP which is used to indicate that a field is autonumber or binary.

Robert

Hi Wolfgang,

the Append() is incredible slow. Even when i change in your CreateDBFile() the loop to

FOR nI := 1 UPTO 100

it still takes 5,5 seconds to create and fill both dbfs. I couldn´t believe that, and created a test. When i run the TestAppend() with X# it takes indeed seconds ! to append 100 records. When i increase the loop upto 1000, VO appends 1000 records in less than 0,1 seconds. ...

can you confirm this behaviour ?

regards
Karl-Heinz

Hi Karl-Heinz,

this is really strange!
I have to check it out later today.
Basically the Append() method does the following:
So I don't see any cause why it could be so slow....

Wolfgang

Wolfgang,
yes, strange.
Took your code, imported Aef into Xide1.23, compiles, runs.
Click "Create DBF" - Bang, "konnte nicht auf eine Objectinstanz festgelegt werden".
looked in Code, find defaultpath for DBF is c: \temp, change to zu "D:\" (as i have no c:\temp)
recompile, run, create dbf
swap to explorer, to look, if true -> yes, - dbf and fpt written
come back to app -> apphang.
?
EDIT: coming back after writing this, i find a "DBF written" messagebox. Hit ok. Looking NOW into explorer, i see also a cdx file written. I'm rather sure, it wasn't there, when i first looked

Hi Karl,

the app doesn´t hang, but you have to wait ... or decrease the for loop as i did

The problem is not Wolfgang´s class, the problem is IMO the way a append currently works.

regards
Karl-Heinz

Hi Karl,

am i correct that you´re using win8.1 64bit, and you´re still facing the mentioned append speed issues ?

regards
Karl-Heinz

Karl-Heinz wrote: am i correct that you´re using win8.1 64bit, and you´re still facing the mentioned append speed issues ?

Yes and Yes

Yes and Yes

Yeah, Win8.1 the best Win OS ever ! When the support ends January 2023 i´ll also retire

Still love my Win7!

Chris wrote: Still love my Win7!

7 was ok and i kept it, until i saw ClassicShell for W8. Switched and possibly i'll follow Karl-Heinz with "retire" - or swap to *ix, as X# will run there

Win 10 is not so bad as you all are saying!

Ok, it is a bit different from W7/W8, but after all I feel it is better than both.

Wolfgang

wriedmann wrote: I feel it is better than both.

Well, my System runs. And runs. And it does, what it should and does not, what it should not. What more could i ask?

For me it's mainly a matter of control over our systems, unfortunately in W10 we have little anymore, MS can just do whatever it wants now. I know it's fighting a lost battle...

btw. Tomorrow will be another (Win10) day of horror - it's Patchday !

Karl-Heinz wrote: btw. Tomorrow will be another (Win10) day of horror - it's Patchday !

I am reading posts in the forum of the last few weeks. Reading this I've got 1 remark and 1 question.

Remark: <W10 users You can pretty safely use W10 if you run O&O ShutUp10 . www.oo-software.com/en/shutup10 It switches off all kind of unwanted things like Telemetry, forced updates. I usually run updates every 3-4 months only (by first allowing it on O&O ShutUp10) and feature updates at least 5-6 months after release. Occasionally one of the Telemetry settings appears reset (O&O will mention that if you open it) but that's all.

What I really love in W10 is the Alt - Windows key combination which allows you to select clipboard content of previous cuts/copies. I really use it all the day. And there are quite a few other (sometimes small) differences with W7/W8. I do use the W10 menu which has been much improved but still run Classic Shell to enable me quickly browsing through programs + the W10 menu can only be externally changed when an option has been added to the good old Start Menu directories anyway.

Question: I found Karl-Heinz 's remark of the speed of the append compared to VO disturbing. I have downloaded the sample but not yet tried it. Do others see the same slowness? If not, what could be the cause for Karl-Heinz ?

Dick