How to: Edit large text fields with multiple lines with no hassle
SQLMerger makes it easier to edit a large text field, than by using the database’s own data edit mechanism.
To edit a large text, first open a merge item containing a text, memo or string field.
If you want to try this in your own database, here is a statement to create the table used in the example:
CREATE
TABLE
ScreenText (
Id INT
PRIMARY
KEY
NOT
NULL,
BigText TEXT
);
Below is an example of how this is set up:
Do:
1. Open the target.
|
|
The table right after it is opened
|
2. Click the "BigText" field, and enter a big text.
|
|
When entering a text, an editor for large text automatically pops up.
|
3. Click the [OK] button and select the “Id” field.
![The target area after click [OK]](images\after-editing-large-text-column.gif "After having edited the field")
|
|
You can now see the front of the text you entered, notice the ... because it does not fit the available display area
|
4. Enter an Id and click the “Script” tab.
|
|
This is the statement to insert the new record
|
5. Execute the statement and return to the “Merge” tab
|
|
The new data.
|
6. Now select or enter ”BigText” in the ”Big Field” edit.
|
|
Looking at a big field
|
The contents are display below the normal line, the text hi-lighted in blue. The full text is displayed, regardless of how many lines it contains.
Tip:
Using this feature, you can also generate and XML file with this included via the “Save Target contents via XML” feature found “Script” menu.
Back to Overview...
|
Works with all Windows versions.
|
