field truncated

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

klav - 28 Apr 2005 13:09 GMT

I'm using Word 2003. My data source is an Oracle database. My SQL
statement looks like this:

{MERGEFIELD {DATABASE \d “c:\\mydatasource.odc” \c “connection string”

\s “SELECT \“TITLE\” FROM \“TABLE_NAME\” WHERE ((\“ID\” =
‘12345’))”}\*Upper}

Peter Jamieson Wrote:

> 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
>
> "klav" klav.1o4209@news.wordbanter.com wrote in message
> news:klav.1o4209@news.wordbanter.com...-
>
> 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?
>
> --
> klav-

Signature

klav

Reply to this Message

Peter Jamieson - 28 Apr 2005 15:42 GMT

OK, the DATABASE field should not be nested inside a { MERGEFIELD } field.
At the moment, Word is treating the result of the Database field as the name
of a column in your merge. You can select the { DATABASE } field and
cut/paste it so it is outside the MERGEFIELD field.

Peter Jamieson

> I'm using Word 2003. My data source is an Oracle database. My SQL
> statement looks like this:
[quoted text clipped - 35 lines]
>> --
>> klav-

Reply to this Message