Subject Re: mem fields From Charlie <tm@tc.com> Date Tue, 02 Aug 2022 18:17:40 -0400 Newsgroups dbase.getting-started 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 > > -- > *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: > http://www.goldenstag.net/dbase/DtoWTutorial/00_Menu.htm