CDX Visual Foxpro compatibility - SWEFIN
Posted: Wed Jun 01, 2016 6:01 am
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
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