S87 and XP sorting problems 1

[sjorsp]

Hi,

I have a problem.

I have a small program that just sorts a database (with sort commando) the file is less then 300kb big.

When i use it sometimes it just crashes without any reason.
some times it helps to add some empty records to solve the problem but most times it doesn't

Any idea's?????

Greetings,
George

 

[GriffMG]

In Summer 87 there is a problem with the indexing routine (which is related to the sort). It appears to be a 'boundary' checking error - particularly when large numbers of similar index keys are produced.

I suggest you sort on a slightly longer key.

So if your current sort is a 20 char field called MyField add another (pointless and unnecessary) field:

i.e.

sort ... MyField

change to

sort ...  MyField + MyOtherField

Regards

Griff
Keep [Smile]ing

 

[sjorsp]

Thanks Griff, i tried it but it doesn't seem to work. I made the sorting keys longer and shorter but still my sorting routine gets stuck.

The only solution that works most times is having the empty records.

Any more suggestions?

Greetings,
George

 

[GriffMG]

The only other ideas I have are to check your memory settings to make sure you turn off any extended/expanded memory, that there is enough hard disc space and you can open enough files - in fact, that would be my next port of call.

Check your file handle settings, they are managed differently in NT/2K/XP to 95/98.

Good luck

Regards

Griff
Keep [Smile]ing

 

[sjorsp]

Thanks again Griff,

I highered the files to 200 in the config.nt. At first that didn't do the trick so i googled a bit more and found that cmd (the xp dosbox) is different then command.com.

So when i use command.com and then start my sort it works if i do it in cmd it doesn't.

I will keep testing but it seems to solve my problem.

Greetings,
George

 

[GriffMG]

Good for you!

Hope you nail it down.

Martin

Regards

Griff
Keep [Smile]ing

 

[pbsd]

Try running the program from a shortcut using the XP compatibility mode for Win95 or Win98 applied to the shortcut. I think this selects "command.com" automatically for you when it opens the command shell.