Programming
-
dear all
i want to store the medical reports (text) in the database , but i want its formating as it is e.g. font , bold, underline etc
does it possible ?
sachin
-
It sounds like you need to store the documents in an image column. This is simply a binary "copy" of the existing document which would preserve all formatting etc...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
hi
thnaks for the reply but i dont want to store the bainary file.
i am having vb 6 as front end. and my operator type it in a text box and then make some words bold , some underline
and in a table i simply store the contents of textbox.
but i am not able to store the formatting
how can i do this ??
sachin
-
Is this a text box, or a rich text box, or even a custom control? What type of formatting are you talking about (as in, HTML markup, RTF, etc)?
If you're using a rich text box, you're probably storing the TEXT of the box, and not the RTF of the box, which is the text and the formatting.
-
sachin - as far as I know the only way you can preserve and display formatting is by using an image datatype.
As Brendan points out - I tried using an rtf control to store something (the text "Special Training" in bold) in a text datatype column and here's what displayed on my vb frontend...
\par \b\f1\fs24 Special Training\b0\f0\fs17
**ASCII stupid question, get a stupid ANSI !!!** -
I have not implemented a solution as you describe.
I have worked with people who have made similar implementations.
From their experience I would advice not storing the documents in the database.
With the variety of formatting etc available this can be a nightmare to handle reliably.
From a performance standpoint it is expensive.
Recommendation: Store the documents on a secure file server and store the path and access control in the database. Within the path and access control you can control document change.
Good Luck
dmb
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply