|
On Wed, 29 Jan 2003, Dan wrote: > > This is where it gets a little confusing to me. I never get to 100, > let alone 2048. You aren't exceeding 2048, you're exceeding the length of the string. The string is VARYING. That means that the length of it can vary between 0 bytes long and 2048 bytes long. However, if the string is (for example) 100 bytes long, you cannot begin a %scan in position 101. It's that simple, the string is only 100 bytes long so you can't scan position 101. Since you haven't reached the max size of your VARYING field, you COULD increase the size of the field so that it is now 101 bytes long. That would work (tho it seems silly to search something you just added!) and in fact that's what you accomplish by concatenating the blank to the end... the string becomes one byte longer, and that new byte is guaranteed not to be a quote... Does that explanation help?
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
