In message <ga************ ******@newsfe1-gui.ntli.net>, Mark
<ma**@tencdf.co m> writes
Thanks Andrew...
I was hoping to be able to load the rtf's into the database so
1) I could control security (being a bit lazy I am) from within SQL server.
Some of the files need to be protected / hidden etc. and..
2) I wanted to be able to search the files in queries. I understand this is
not possible and have been considering either a) copying the unformatted
text (on save) to the backend (for search purposes) whilst storing the
formatted text in a file (not so clever) or b) programatically doing a
search for files containing specified text and appending these to the list
of records containing specified text (some records hold text in RTF and
others within the record itself).
It's a bit of a pain but I'm tryinging to get seamless results where a
search can cover both table and file data (the files are named
primaryKey.r tf so returning a list of filenames would work).
If you take the route of storing the unformatted text in the database
then I would suggest changing the data type to TEXT rather than Binary
or Image for storage and access issues (ie: avoiding GetChunk, reducing
index fragmentation, improve performance etc).
Also, it may be wise to put these in a separate link table rather than
the main table. This again would improve storage and you can ignore the
large Text fields when not required (ie: if required use a Select with
an INNER JOIN).
By using a Text field you would also be able to perform selects like
"SELECT * FROM MyTable [optional inner join] WHERE MyTextField LIKE
'%Search String%' ".
Kind Regards,
--
Andrew D. Newbould E-Mail:
ne********@NOSP AMzadsoft.com
ZAD Software Systems Web :
www.zadsoft.com