Sort on File with Memo field

This forum is for eXpress++ general support.
Post Reply
Message
Author
omni
Posts: 554
Joined: Thu Jan 28, 2010 9:34 am

Sort on File with Memo field

#1 Post by omni »

Roger,

Never run across this before, but may have never had this method..just not sure.

We are sorting a small file for a report that has a memo field as the 50th field. There are fields afterwards that do print on the report, and are part of the sort key. When we do this, the fields after the memo field start inserting data from other fields, eventually making most garbage. The last two fields, which are new fields for this report end up blank. These fields all have data in them in the file itself.
One thing to mention, the original files in our system are created in foxpro, if that makes any difference. We normally do not sort this particular file.

So, I moved the memo field to the end of the file, just to test it, and it then worked.

Have you seen this issue before? I have not had this occur before. Also, we tested on different files (different data, same file) and had the same results.

Thanks

Fred
Omni

User avatar
rdonnay
Site Admin
Posts: 4813
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: Sort on File with Memo field

#2 Post by rdonnay »

I have never seen such a thing. Sounds like a bug in the dbe.
The eXpress train is coming - and it has more cars.

User avatar
Auge_Ohr
Posts: 1428
Joined: Wed Feb 24, 2010 3:44 pm

Re: Sort on File with Memo field

#3 Post by Auge_Ohr »

greetings by OHR
Jimmy

Post Reply