Notifications
Clear all
Topic starter
Drawing a blank on the table/field that houses the chart document's text in it... 
Thanks
Posted : March 12, 2013 3:36 am
There's a couple places depending on the status of the document:
Documents On Hold:
DOCUMENT.NOTETEXT
Signed documents:
DOCDATA.DATA
From the data dictionary:
http://centricitypractice.gehe.....rtPage.htm
The DOCDATA table stores document data. Each row represents one "chunk" of document data, up to 2000
characters. Documents requiring more than one row have "chunks" stored sequentially in rows of the table
using the same SDID.
Rows with the same SDID are part of the same document. The additional rows follow immediately after the first
and are in the correct sequence; a query for all rows with the same SDID and FORMATID automatically returns
the chunks in the proper sequence.
The DOCDATA table is searchable. Queries can be built to search chunks of document data for specific words
or phrases. In order to make searching faster, a chunk is broken on white space boundaries. If no white space
is encountered, it is broken on linefeed boundaries. If no linefeed is encountered, it is broken on a 2000-
character boundary.
Posted : March 12, 2013 6:23 am
