When I need long text fields in MapInfo, I create a second that looks like: [Table: Memo] Memo_id int Sequence smallint Text char(64)
And in the main table I store the memo_id where I want to reference a memo field. Then I have written memo support functions in MapInfo like MemoRead(), MemoWrite(), MemoDelete(), MemoEdit() and MemoSearch(). You can pass long text strings between your app and these functions, but they have to do the job of manipulating the long strings to fit the "memo" table. In other word, handle a long text strings as a series of short text strings ordered by sequence. Write these functions as a library module, and link to any app where you need to support memo fields, and you'll find it's quite easy to support long strings. However, you can't use Access memo fields with MapInfo because MapInfo will just treat them like char(254) data types. You need to use a different data structure and write supporting functions. Even then with MapInfo's textedit boxes you are limited to strings no larger than 32K and containing no more than 49 newlines. -- - Bill Thoen ------------------------------------------------------------ GISnet, 1401 Walnut St., Suite C, Boulder, CO 80302 tel: 303-786-9961, fax: 303-443-4856 mailto:bthoen@;gisnet.com, http://www.gisnet.com/ ------------------------------------------------------------ David Denton wrote: > > Hello MapInfo-L users, > > No response the first time -- I will try again with my question. > > I would like to be able to read, query and edit text that is much > longer than 254 chacters. Currently, my data are in a memo field in an > Access 97 database. > > People have suggested I use multiple text fields to get around the > 254 character limit but this is an extremely awkward solution. > > I have also tried hotlinks. These could give access to the text data > (e.g. in a Word file), but they cannot be queried. > > I have tried ODBC drivers with Live Access. The memo fields are only > available up to 254 characters and they are not editable. > > Does anyone have any other suggestions or word-arounds. Are there any > add-on programs that might help? I am using MapInfo 7.0. > > Many thanks in advance for your help. > > -- > Best regards, > David mailto:ddenton@;lino.com > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 3998
