My string length is too long

  • Thread starter Thread starter efandango
  • Start date Start date
E

efandango

I am trying to output a query which in turn will feed a data file (xml) to an
exernal app; but the overall field length on some records exceeds 255
characters in some records, and replaces the onerous chracters with a square
character.

I really must keep each field line intact so that the xml parser will read
it, and... to enable me to avoid going cross-eyed at the thought of wading
through tons of metatags on multiple lines.

what are my options, if any?
 
well you can set the field in access to memo rather than text is this
what you are looking for

Regards
Kelvan
 
If the issue is just getting a query to include all the characters, one way
to prevent a query from truncating at 255 characters is to SELECT FIRST on
that field instead of just SELECT

This: SELECT First(MyMemoField) FROM MyTable

Instead of this: SELECT MyMemoField FROM MyTable

I cannot remember why, but I'm sure one of the MVP's has the reason (and
probably a better answer to your question, as well).
 
Back
Top