Error with Type M Field

Error with Type M Field

I’m trying to access a particular field via an ASP. I presently have a table displaying multiple fields. Everything works fine, but as soon as I try to add a specific field I get the error.

The database I’m pulling from is not well documented, but it lists this particular field as a “Type M.” All the other fields I’m pulling from are “Type C” or “Type I.” The field contains text as far as I can tell; it’s just a “notes” field.

Any idea why it keeps crashing out on this field? If so, what can I do to fix it?

My guess is that fields that are coming back to you identified as data type “M” (and this is just a wild guess) are Memo fields. They are used, as you have observed, to store variable-length text.

The problem is that because the length of actual data is variable, there is a different access method attached to data types like text or image.

You need to define a variable of size 255 and use it to fetch succeeding “buckets full” of 255 bytes (using the textptr variable) until you exhaust the contents of the field.

If you can affect the schema, it might be better to recast this field as a VARCHAR(2000) (it can be as big as 8000 if you need it to be) because I think it will simplify accessing this text.

See also  5 Tips for Choosing the Right Medical Software for Your Practice

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist