xsharp.eu • Troubles with DBF
Page 1 of 4

Troubles with DBF

Posted: Sat Nov 27, 2021 9:00 pm
by Horst
Hallo

I updated to XS 2.9 from 2.7 and as a first i reindex the dbf's as it was written.

And now i have a problem with one DBF i know.
In the Zip's attachments you will see 2 Log file 's . one was running under 2.9 30! seconds and one with a old one XS2.6 Version not even one second .
if you look into the code its a append , witch needs a lot of time.

Also, when i wanna make a copy with dbAdministrator 3.27 the copy process stops after 34 Records.
Maybe my DBF is corrupt ?

How compatible is XS with Cavo dbf's ????
Is my DB broke ? Its in the Zip file

I am realy confused.
Horst

ps: before i was also trying to add a field to the DBF , but allways it crashed because a corrupt FTP. so i was making a VO prg to copy the file record by record like -> oDBnew:Fieldput(#XY , odbOld:Fieldget (#XY))
then it was possible to add a field with dbAdministrator.

Troubles with DBF

Posted: Sat Nov 27, 2021 11:23 pm
by Chris
Hi Horst,

Sorry to hear about those problems, but we will need to better understand them in order to fix them.
Could you please send a compilable sample reproducing the issues?

Regarding VO compatibility with dbfs, almost always if you see a behavior in X# that is different than the one in VO, then this must be a considered a bug in X# that we must fix. Except fot a few occasions where there is a problem with VO itself, but usually VO with dbfs is correct.

.

Troubles with DBF

Posted: Sun Nov 28, 2021 9:16 am
by Horst
Hallo Chris
While i was preparing a sample for you i found the bug.
oDbServer := _CryptServer { cFile, DBSHARED, DBREADONLY } ReadOnly.
and later i wanna make a Append and this append never works. In XS 2.9 its stops some seconds in XS 2.7. not.

Horst

Troubles with DBF

Posted: Mon Nov 29, 2021 12:12 am
by Chris
Hi Horst,

Ah, ok, glad you found the problem!

.

Troubles with DBF

Posted: Thu Dec 02, 2021 4:37 pm
by Horst
I changed from 2.6a to 2.9
Now an error like (dbf does not exist, or before the READONLY) opens a window and writes a voerror.log
before i was writing this error into a html and send it as response to the client and sends a mail to me.
like

CATCH ex AS Exception
cEmail := ex:ToString()
cEmail := cEmail + CRLF+Time ()+CRLF+ DeCryptIvo ( SubStr (cInputString,11, at ("&" ,cInputString)-1))
ologfile:WriteLog(cEmail)
cString := WriteErrorHtml (cCrash, {StrTran (cEmail,CRLF,"<br>")})
END TRY


how can i change back to the behavior of 2.6a in this case ? Because the window opens only on my develop pc

Horst

Troubles with DBF

Posted: Thu Dec 02, 2021 7:54 pm
by Chris
Hi Horst,

For the error dialog to show, you must have included a reference to XSharp.VO.dll, because the dialog is defined in there.

To handle the errors yourself, you can do something like this

Code: Select all

ErrorBlock({|error|HandleError(error)})

PROCEDURE HandleError(oError AS Error)
// you can get info about the error and handle it here
.

Troubles with DBF

Posted: Fri Dec 03, 2021 7:57 am
by robert
Horst,
In addition to what Chris said:
We changed this to make the error handling work a bit more like it did in Visual Objects,

Robert

Troubles with DBF

Posted: Tue Jan 25, 2022 4:55 pm
by Horst
Hallo
Since a moved from xSharp 2.6a to 2.9 i have troubles with the FTP files of my mostly updated database.
When i try to change the structure with the dbaLite tool its crashed and says the ftp is corrupt. SubCode 2006

When i go through the db, record by record, i can see all memo fields records.

Now i saw that you fixed a bug in xs2.10 with the CDX corruption #585. is it possible that you have a bug too on the ftp file ?

if i install 2.6a again , is there any major problem i will run into ??
Because this coud be the only way for me to test if the xs2.9 Version is making the troubles with the FTP files.

Horst

Troubles with DBF

Posted: Tue Jan 25, 2022 4:58 pm
by robert
Horst,
Reinstalling 2.6a should not be a problem.
If you keep seeing the issue then I would like to inspect the DBF+FPT files.
Btw: Issue 585 was not related to FPT files a all.

Robert

Troubles with DBF

Posted: Tue Jan 25, 2022 5:26 pm
by wriedmann
Hi Horst,
I would recommend to pay the FoX membership and use 2.10 where the DBFCDX issues are fixed (I'm using the DBFCDX RDD in several installations and can confirm that the issues are fixed).
And IMHO even open source developers need to pay their bills.
Wolfgang