field truncated

[klav]

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]

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