Re: Truncation Issue w/ Strings

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Could you be a little less ambiguous than "big" & "very long", for some
people a "big" string will be a few hundred characters for others it's not
"very long" if its under a megabyte.

Also is "stMsg" as typo for "rstMsg"? or are you talking about different
things here.
This is an admittedly trivial example of why you should ALWAYS copy and
paste from your code rather than re-typing it into the message.

Regards - Dave O.

<jalil.feghhi@xxxxxxxxx> wrote in message
news:c5c2b21f-ec48-415d-b096-484b76ca54be@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have an access database that has a field (type memo) that keeps very
long strings. When the value of this field is very long, my Visual
Basic 6.0 code does not return the whole value and truncates it. I
just read it using standard code like this:

storeId = rstMsg!storeId

where is defined as: Dim stMsg As ADOdb.Recordset

Everything works fine if storeid is not very big.

Does anybody know why this happens?

Thanks,

-Jalil


.

Relevant Pages

  • Re: anothers users calendar
    ... One hack you can use is to get the StoreID of that Calendar folder and convert the string value into a byte array. ...
    (microsoft.public.outlook.program_vba)
  • Re: How to convert Infix notation to postfix notation
    ... If this is for an error message, why isn't it using stderr for its output? ... array of 15 characters, and you call this function with the limit 15 on ... Making sure that the only string I allocate and append to, ... because mulFactor in all versions must needs incorporate the functions ...
    (comp.lang.c)
  • Re: Prothon should not borrow Python strings!
    ... """It does not make sense to have a string without knowing what encoding ... same cul de sac as Python. ... Prothon_String_As_ASCII // raises error if there are high characters ... Python's split between byte strings and Unicode strings is ...
    (comp.lang.python)
  • Re: Letter to US Sen. Byron Dorgan re unpaid overtime
    ... put them in stupid places. ... Programming is difficult (as you must surely appreciate, ... > strings will be in the range 1...1000 characters. ... impose an artificially small limit on string length." ...
    (comp.programming)
  • Re: Byte Array to String
    ... retrieved text will mismatch the original characters. ... encoding the characters. ... Dim strFileData as String ...
    (microsoft.public.dotnet.framework.aspnet)