I have an app originally written in A5v3 or 4.5, now in v.9
Until this year, the memo fields were working ok, but recently, the client has been having big problems with the table. It would bloat to 2 gigs with very little provocation. I know that this is a known issue with dbf memo files, and I have been wanting to redo the entire layout to conform more to the Dr. Wayne method of creating and maintaining memos that work (http://www.learn alpha.com/MemosThat...osThatWork.htm)
In the mean time, I decided to export the records to an ascii file and import them into a new table. This worked so well, I almost broke my arm patting myself on the back... until the client called and asked why all of his memo fields had lost their hard returns in the memos. Now all of the text in the memo fields is all run together.
I am contemplating going to SQL for this table but whenever I try to do most anything I get the message "Failure trying to move pointer to the beginning of the file". I cannot export the records to a new table directly, as the memo field gives the above message..
I have tried to use Alpha's memo repair as well as purchasing a third party dbf repair tool.
Ultimately, I would like to either create a new dbf file, with the hard returns in the memo field, or create an SQL table and use the varchar field, but that too has to have the hard returns.
Any thoughts on how I can export the records and leave the the hard returns intact?
Thanks.
Jay
Until this year, the memo fields were working ok, but recently, the client has been having big problems with the table. It would bloat to 2 gigs with very little provocation. I know that this is a known issue with dbf memo files, and I have been wanting to redo the entire layout to conform more to the Dr. Wayne method of creating and maintaining memos that work (http://www.learn alpha.com/MemosThat...osThatWork.htm)
In the mean time, I decided to export the records to an ascii file and import them into a new table. This worked so well, I almost broke my arm patting myself on the back... until the client called and asked why all of his memo fields had lost their hard returns in the memos. Now all of the text in the memo fields is all run together.
I am contemplating going to SQL for this table but whenever I try to do most anything I get the message "Failure trying to move pointer to the beginning of the file". I cannot export the records to a new table directly, as the memo field gives the above message..
I have tried to use Alpha's memo repair as well as purchasing a third party dbf repair tool.
Ultimately, I would like to either create a new dbf file, with the hard returns in the memo field, or create an SQL table and use the varchar field, but that too has to have the hard returns.
Any thoughts on how I can export the records and leave the the hard returns intact?
Thanks.
Jay
Comment