field truncated

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

klav - 26 Apr 2005 16:30 GMT

I am using the "insert database" command with an SQL statement to grab a
specific row of data. From that one row, I am inserting one specific
field, consisting only of text, into my Word document. I have also
incorporated the "mergeformat" switch to have the text I am pulling
appear in all caps. My problem is that the data is being truncated
after 40 characters and looks like this:

<<THIS IS AN EXAMPLE OF MY RECORD TO BE IN>>

Any ideas on why this is happening? Also, I don't want the brackets
around my data result -- how do I get rid of them?

Signature

klav

Reply to this Message

Peter Jamieson - 27 Apr 2005 13:58 GMT

Which version of Word? What is the data source? Can you post the SQL here?

> I have also
> incorporated the "mergeformat" switch to have the text I am pulling
> appear in all caps.

You could probably use the \*Upper switch instead, or there may be a
suitable function in the dialect of SQL you are using.

Peter Jamieson

> I am using the "insert database" command with an SQL statement to grab a
> specific row of data. From that one row, I am inserting one specific
[quoted text clipped - 7 lines]
> Any ideas on why this is happening? Also, I don't want the brackets
> around my data result -- how do I get rid of them?

Reply to this Message