||Re: mem fields
||Tue, 02 Aug 2022 18:17:40 -0400
Thanks Ken... I have found 3 instances where database was closed before the form so I have to go slow with this. Thanks for the tip. Something I never thought of.
Ken Mayer Wrote:
> On 7/31/2022 2:24 PM, Charlie wrote:
> > I am planing to change two fields in 4 different tables from character to memo. I have had problems in the past with memo fields causing problems with data changing and other things. Since then I have updated all tables to the highest level. Just wondering if this is a good idea or bad idea. I need more than 254 characters in the fields involved. Would appreciate opinions. Thanks!!
> This is a "YMMV" (Your Mileage May Vary) thing. I have NEVER had
> corrupted memos, never had issues with them. But I also make sure I
> close forms, all that, before closing the database. Honestly, you should
> be okay. I know some folk will tell you otherwise, but again, I've never
> had a problem. I use them all the time. I have tables with multiple memo
> fields, some with none, depending on the purpose.
> *Ken Mayer*
> Ken's dBASE Page: http://www.goldenstag.net/dbase
> The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp
> dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm
> dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm
> dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm
> dBASE DOS to Windows Tutorial: