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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Top n query using Allen Browne's "ConcatRelated" 3
Transfer table to fixed length text records 5
My "Condition" String is too long 5
Record Length Too Long in a Table 2
delete images from disk where filename is not in table 1
inserting data into "CLOB" field returning ORA-01704: string literal too long 1
Reports missing data at end of page, splits text horizontally 1
Problems Loading Large String Array into Array variable 6

Back
Top