Subject Re: mem fields From Ken Mayer <dbase@nospam.goldenstag.net> Date Sun, 31 Jul 2022 14:33:11 -0700 Newsgroups dbase.getting-started 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