Troubles with DBF

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

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

.

[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

[Chris]

Hi Horst,

Ah, ok, glad you found the problem!

.

[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

[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

.

[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

[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

[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

[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