If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
field truncated
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" wrote in message ...- 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- -- klav |
#2
|
|||
|
|||
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 "klav" wrote in message ... 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" wrote in message ...- 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- -- klav |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
DCount compare table.textfield to form.text field question | RNUSZ@OKDPS | Using Forms | 1 | March 11th, 2005 02:05 AM |
Memo Field That Is Exported to RTF Format May Be Truncated | Ravi | Setting Up & Running Reports | 1 | August 26th, 2004 03:07 PM |
Memo Field Truncated in Access 97 query | bdehning | General Discussion | 2 | August 19th, 2004 04:11 PM |
field manipulation | Steve | Running & Setting Up Queries | 2 | May 28th, 2004 03:12 PM |
Supress blank lines in DOCPROPERTY field | Mary | Formatting Long Documents | 10 | May 25th, 2004 07:27 PM |