Board index » delphi » Saving Rich Text to sql server Text Fields

David Jones

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Saving Rich Text to sql server Text Fields

How can I save Formatted Rich Text in a SQL Server Text Field without losing
the formatting?

Thanks in anticipation

 
Steve Jorgense

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Saving Rich Text to sql server Text Fields


That depends entirely upon the front-end.  If you are using some kind of
rich text control, it should have a property you can read for the text
including all the formatting codes.

Quote
David Jones wrote in message <7pevb8$uu...@news4.svr.pol.co.uk>...
>How can I save Formatted Rich Text in a SQL Server Text Field without
losing
>the formatting?

>Thanks in anticipation

Dianne Siebol

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Saving Rich Text to sql server Text Fields


That's right, if you're using the Visual Basic rich text control it has a
.Text property and a .TextRTF property.  The .TextRTF property will return
the text and all the associated codes which you can store in SS Text field.

Dianne Siebold

Quote
Steve Jorgensen wrote in message ...
>That depends entirely upon the front-end.  If you are using some kind of
>rich text control, it should have a property you can read for the text
>including all the formatting codes.

>David Jones wrote in message <7pevb8$uu...@news4.svr.pol.co.uk>...
>>How can I save Formatted Rich Text in a SQL Server Text Field without
>losing
>>the formatting?

>>Thanks in anticipation

Daniel Stoia

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Saving Rich Text to sql server Text Fields


Quote
Dianne Siebold wrote in message ...
>That's right, if you're using the Visual Basic rich text control it has a
>.Text property and a .TextRTF property.  The .TextRTF property will return
>the text and all the associated codes which you can store in SS Text field.

>Dianne Siebold

Nothing like that in Delphi's TRichEdit though, eh? I couldn't find it?
Anybody knows?

Dan

Gene

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Saving Rich Text to sql server Text Fields


In TDBRichText, set PlainText property to False.

Good luck.
Gene

Quote
Daniel Stoian wrote in message ...
>Dianne Siebold wrote in message ...
>>That's right, if you're using the Visual Basic rich text control it has a
>>.Text property and a .TextRTF property.  The .TextRTF property will return
>>the text and all the associated codes which you can store in SS Text
field.

>>Dianne Siebold

>Nothing like that in Delphi's TRichEdit though, eh? I couldn't find it?
>Anybody knows?

>Dan

Daniel Stoia

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Saving Rich Text to sql server Text Fields


Mmm, yeah, but the point was to save somehow the info related to the
formatting, not just the text...

Quote
Gene wrote in message <7phahu$1m...@nntp9.atl.mindspring.net>...
>In TDBRichText, set PlainText property to False.

>Good luck.
>Gene

>Daniel Stoian wrote in message ...
>>Dianne Siebold wrote in message ...
>>>That's right, if you're using the Visual Basic rich text control it has a
>>>.Text property and a .TextRTF property.  The .TextRTF property will
return
>>>the text and all the associated codes which you can store in SS Text
>field.

>>>Dianne Siebold

>>Nothing like that in Delphi's TRichEdit though, eh? I couldn't find it?
>>Anybody knows?

>>Dan

Gene

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Saving Rich Text to sql server Text Fields


Sorry--misinterpreted the question.  One needs to set PlainText property to
True to save formatting.

Good luck.
Gene

Quote
Daniel Stoian wrote in message ...
>Mmm, yeah, but the point was to save somehow the info related to the
>formatting, not just the text...

>Gene wrote in message <7phahu$1m...@nntp9.atl.mindspring.net>...
>>In TDBRichText, set PlainText property to False.

>>Good luck.
>>Gene

>>Daniel Stoian wrote in message ...
>>>Dianne Siebold wrote in message ...
>>>>That's right, if you're using the Visual Basic rich text control it has
a
>>>>.Text property and a .TextRTF property.  The .TextRTF property will
>return
>>>>the text and all the associated codes which you can store in SS Text
>>field.

>>>>Dianne Siebold

>>>Nothing like that in Delphi's TRichEdit though, eh? I couldn't find it?
>>>Anybody knows?

>>>Dan

Other Threads

1. Saving MS Word files / Bmp files/ text / rich text files in SQL Server

2. quick routine to save text in rich text boxes

3. Insert Rich Text into a Rich Text file

4. Checking for Rich Text formatting in a rich text edit box

5. Adding Rich Text to Rich Text

6. Formatted Rich Text to Text Field

7. How to save rich text into blob fields

8. Rich Text Browser Component To SQL Server

9. MS SQL Server newbie - importing text to SQL tables from a text data feed

10. Update SQL 6.5 image field with rich text