Web forum is in read-only mode. Login as active registered customer for write access
  Forum Search   New Posts New Posts

TDBAdvRichEditor

 Post Reply Post Reply
Author
Balslev Anders View Drop Down
New Member
New Member
Avatar

Joined: 11 Jun 2012
Posts: 26
Post Options Post Options   Quote Balslev Anders Quote  Post ReplyReply Direct Link To This Post Topic: TDBAdvRichEditor
    Posted: 05 May 2019 at 11:43am
I would like to make use of the component "TDBAdvRichEditor"
The datasource points to TClientDataset field, again pointing to a column in a MS SQL Server database.

What datatype shall I define in the SQL database table so it can be compatible with the editor?

If I use the build-in "TDBRichEdit" included in Delphi, I define the datatype as "ntext", and it apparently works. But ntext datatype is incompatible with TDBAdvRichEditor (exception upon opening the dataset: "Invalid stream format")

Anders
Back to Top
Bruno Fierens View Drop Down
TMS Support
TMS Support
Avatar

Joined: 11 May 2010
Posts: 7922
Post Options Post Options   Quote Bruno Fierens Quote  Post ReplyReply Direct Link To This Post Posted: 05 May 2019 at 11:45am
TDBAdvRichEditor persists natively in a binary format, so you'd need to use a binary blob field. If you want to persist in RTF format, use TAdvRichEditor with TDBAdvRichEditorRTFIO for databinding
Back to Top
Weber Margit View Drop Down
New Member
New Member
Avatar

Joined: 22 Dec 2018
Posts: 3
Post Options Post Options   Quote Weber Margit Quote  Post ReplyReply Direct Link To This Post Posted: 17 May 2019 at 11:26am
How can I configurate the charset of my RTF content?
Back to Top
Bruno Fierens View Drop Down
TMS Support
TMS Support
Avatar

Joined: 11 May 2010
Posts: 7922
Post Options Post Options   Quote Bruno Fierens Quote  Post ReplyReply Direct Link To This Post Posted: 18 May 2019 at 8:58am
At this moment this is hardcoded to the standard ANSI CP1252
Back to Top
Weber Margit View Drop Down
New Member
New Member
Avatar

Joined: 22 Dec 2018
Posts: 3
Post Options Post Options   Quote Weber Margit Quote  Post ReplyReply Direct Link To This Post Posted: 18 May 2019 at 8:59pm
Is there any solution to display my text correct. 
Words containing , , and so on. 
Thanks
Back to Top
Bruno Fierens View Drop Down
TMS Support
TMS Support
Avatar

Joined: 11 May 2010
Posts: 7922
Post Options Post Options   Quote Bruno Fierens Quote  Post ReplyReply Direct Link To This Post Posted: 20 May 2019 at 12:28pm
I cannot see an issue with these characters.
Do you have more details how to reproduce this?
Back to Top
Weber Margit View Drop Down
New Member
New Member
Avatar

Joined: 22 Dec 2018
Posts: 3
Post Options Post Options   Quote Weber Margit Quote  Post ReplyReply Direct Link To This Post Posted: 20 May 2019 at 8:25pm
I use the ADVRichEditor componente with the TDBAdvRichEditorRTFIO for save & load the Binary Blobfield from my Firebird Database. When I use a word like "Gre". The Component display this text after save & load it from the Database. 'Gr??e'
Back to Top
Bruno Fierens View Drop Down
TMS Support
TMS Support
Avatar

Joined: 11 May 2010
Posts: 7922
Post Options Post Options   Quote Bruno Fierens Quote  Post ReplyReply Direct Link To This Post Posted: 20 May 2019 at 9:36pm
Are you sure this is a binary blob field? When you use a binary blob field, you don't need RTF btw, you can use TDBAdvRichEditor.
I have especially retested the functionality of TDBAdvRichEditorRTFIO but could not see an issue here. Perhaps you can separately try TAdvRichEditorRTFIO and save & load from file (and test the file with another editor like WordPad). If this works, the issue must be with the DB field.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down