Collate settings

[DarrenWard]

I am trying to;

SET COLLATE TO "General"

to resolve a compatability problem between FPD2.6 and VFP6.0 but it does not seem to be supported, the only option I seem to have is "Machine" I have looked through the help files an there is nothing in FPD2.6, I can set the COLLATE to "General" in FPW2.6 but not the DOS version.

I have CODEPAGE=AUTO in my config.fp file.

Any ideas?

Dazz GuiltyMaggot - The best rock band in the world!

 

[rgbean]

Dazz,
It works for me in FPD 2.6a (x). My help file suggests that this was a feature "added" in the "a" release.

Rick

 

[DarrenWard]

Not sure what is heppening then.
Says I have FoxPro 2.6a (X) in the about but get;

Collating sequence 'General' not found.

I don't seem to have any Collate options availible apart from 'Machine'. This is the last part of a problem that I have had ongoing for months.

The post I made in the v3.0 and above forum regarding rebuilding the structure with collate='general' sorted out the .CDX incompatablity issue but the Rushmore will not work unless the collate is set to general in any version.

Dazz GuiltyMaggot - The best rock band in the world!

 

[rgbean]

Dazz,
Since I've never had a need to delve into this area before, my knowledge is &quot;non-existant&quot;. <g>

However, I just tried setting COLLATE to each of those &quot;languages&quot; on the list in the help file. These failed:
CZECH
GREEK
HUNGARY
POLISH
RUSSIAN
SOLVOK
These gave no error message:
MACHINE
GENERAL
DUTCH
ICELAND
NORDAN
SPANISH
SWEFIN
UNIQWT

Note: I am running this on XP Pro (SP1), and have &quot;every&quot; current version of FPD, FPW and VFP from 2.0 to 8.0 installed.

Rick

 

[DarrenWard]

Rick,
Thank you for your continual assitance on this issue, it really is appreciated.

I am obviously not getting the same functionality from my copy that you are from yours, do you know if there was some kind of patch for v2.6a that introduced this, I don't even have reference in my help files (fpd) to the collate command, is their a later .ESL file that can be used with the compiled code? I can not find anything on the web or MSN.

I can set the CODEPAGE=AUTO in the compiled programs config.fp but the COLLATE=General does nothing, thankfully the people that wrote the origninal code actually have a utility that allows you to execute FP command directly into it, so I can check what is going on.

On a slightly different issue, the .FXP (compiled program files?) seems like quite a neat way of doing things, only load the code for the module you are using, is this application building method still availible in VFP as I do not seem to be able to do it and my .exe is growing rapidely by the day.

Dazz GuiltyMaggot - The best rock band in the world!

 

[rgbean]

Dazz,
As far as I know there was only one FPD 2.6a. Mine was updated from 2.6 (as opposed to installing 2.6a), and my external date shows 7/15/1994 (1,412,560 bytes) for FOXDX260.ESL. (On the internal About, it shows 7/13/1994.)

In a VFP .EXE you can call .APPs and .FXPs, but this can quickly become a versioning nightmare if your user decides they like some earlier functionality and keeps good backups. In VFP 7.0, you can even compile .PRG files in the runtime to create new .FXPs.

We've got VFP .EXEs as large as 24MB - no problem. With the cost of CDs and high speed internet connections, it's not worth worrying about the size of a VFP application. While there are techniques to &quot;shrink&quot; these, even those can cost time from normal support or &quot;free&quot; time.

Rick

 

[DarrenWard]

Rick,
I got the same date information as you, I will put another call into microsoft and see if they can sort it out.

I saw a thread in the other forum recently on where you can buy old versions of FoxPro I may give that a go as I seem to be spending more and more time using FoxPro (am a VB programmer foremost) but am really enjoying it.

Thanks again.

Dazz GuiltyMaggot - The best rock band in the world!