Error with Type M Field

Question:
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?

Answer:
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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

The Latest

6 Tips for Setting Up a Decentralized Exchange

6 Tips for Setting Up a Decentralized Exchange

There’s no doubt that cryptocurrency is a complex and divisive topic in the modern financial landscape. There are those who are convinced that it’s nothing more than a bubble, but both who are well-informed are able to see the ways in which cryptocurrency can help them both build their fortune

user experience with someone on their phone

5 Ways to Improve Your Customers’ User Experience

They say you can’t judge a book by its cover, but just because they say that doesn’t mean it’s true. Consider how often you choose one sort of product over another just because it appeals to you. Then think about how often you’ve stopped using something because, simply put, it

How to Manage Your Finances after Buying a Home

How to Manage Your Finances after Buying a Home

Buying a home is a milestone in the journey of life – it’s one way to invest your money and create lasting memories. Now you know everything about a home purchase, home mortgage, and what is a conventional 97 loan but do you know what’s next after you sign the

Windows Logging is one of the vital aspects of any Windows system administration. However, it is mostly overlooked until the system develops a problem. This is because logs contain important information needed to troubleshoot and resolve system issues.

The Fundamentals of Windows Logging

Windows Logging is one of the vital aspects of any Windows system administration. However, it is mostly overlooked until the system develops a problem. This is because logs contain important information needed to troubleshoot and resolve system issues. Without it, tech experts might find it difficult to track a computer’s

Interstitial Ads: Best Practices for Successful Campaigns

Interstitial Ads: Best Practices for Successful Campaigns

Interstitial Ads: Best Practices for Successful Campaigns Interstitial ads are full-screen advertisements that appear to grasp the attention of on-site prospects, creating opportunities for brands seeking effective ways to communicate their proposition of value. With such an attention-grabbing format and high-impact visuals, it’s no wonder why interstitial advertising is proving