Page 1 of 1

CDX Visual Foxpro compatibility - SWEFIN

Posted: Wed Jun 01, 2016 6:01 am
by Victorio
Hi,

After many many experiments I still have no solution for compatibility with Visual Foxpro.
(compatibility is neccessary because I will connect to other VFP information system)

First several facts :
I have DBF file with CDX, created with VFP 9. In it is TAG with collation and in header tag is "SLOVAK", so this is not supported with Xbase++

I can open DBF file with this CDX, can sort and search but not work with order by character fields, listing in browser do not work, only stay on same record and show on all rows same content.

After REINDEX by my Xbase application everything works fine, sorting, also search... but in CDX change "SLOVAK" to SWEFIN ??? Why ? , always SWEFIN, I can change collation to ASCI, SYSTEM, GERMAN, AMERICAN,,,, always SWEFIN. SWEFIN is some default settings ?

I read than 100% compatibility is only with ANSI mode, then I tryed SET CHARSET TO ANSI, and also SET CHARSET TO OEM.
nothing help.

Also I tryed create COLLAT_USER with out country sorting (Janko Thank's), but any effect.

It shows no problem with collation, but problem with CDX file and reading from it.

Thanks for any help !!!

Victorio

Re: CDX Visual Foxpro compatibility - SWEFIN

Posted: Wed Jun 01, 2016 6:35 am
by rdonnay
Which version of Xbase++ are you using?

If what you are saying is true, then Alaska's entire campaign towards bringing the VFP community to Xbase++ is in trouble.

Have you sent that email to Alaska tech support?

Re: CDX Visual Foxpro compatibility - SWEFIN

Posted: Wed Jun 01, 2016 6:58 am
by Victorio
Xbase 2.0 build 554.
I sended email to alaska, but they wanted from me CID number for support. And no other answer from there.
Because I bought Xbase++ in december 2014, I have not valid (payed) support (more than 12 months..)

(I think about pay for support later , because I am "small" developer, and some other investment can be after pay for my actually application ;) )

I still think, that it is only some my internal problem, or problem with missing national support for Slovakia (collation tables and other). Also can be problem with system settings on PC, do not know.

Re: CDX Visual Foxpro compatibility - SWEFIN

Posted: Wed Jun 01, 2016 7:08 am
by Cliff Wiernik
Alaska has been responsive with support questions. Current build is 685. However, we have also kept our subscription current.

Cliff

Re: CDX Visual Foxpro compatibility - SWEFIN

Posted: Wed Jun 01, 2016 7:25 am
by Victorio
Ok Cliff,
Is possible, that this problem will be in new version solved ?

what is different between limited and no limited support ?

Thanks ,

Re: CDX Visual Foxpro compatibility - SWEFIN

Posted: Wed Jun 01, 2016 12:19 pm
by Cliff Wiernik
I don't know the difference or if any problems have been fixed in the current version. You would have to contact Alaska.

Re: CDX Visual Foxpro compatibility - SWEFIN

Posted: Sun Jun 12, 2016 10:51 am
by Victorio
Hi,
I have still trouble with Visual Foxpro CDX compatibility. Today I analysed content of CDX file and do not understand, what is in it.
I have 2 indexes, first created with VFP 9 application, this not work with Xbase++ application.
And second same but only "reindex" with Xbase++ app, and after this in Xbase works.
In DBF are text field, where is names.
This names was readable in CDX created with Xbase, but not readable in VFP index.

What is different ? VFP use some encrypting of data in CDX ?
Can be this by settings of SET COLLATION
In indexes was used index key UPPER(LEFT(vla,30)), no any special functions.

I also examine both modes VFOXPRO and also FOXPRO2X, both names was readable. Only VFP9 CDX is not readable.

If problem is not in Xbase++, then must be some special mode in VFP application, where collation SLOVAL has some encryption. :think: