Formatted Text and Database Blob
Quote from CSSystems on November 7, 2025, 2:49 amI wrote a "Simple Ticket Maker" app which I would like to make more flexible.
In the description of the event, I am limited to a Text Box (multiple lines) with fixed font and size which is printed from a DBPro field of memo.
This field is changed as event description changes.For the header name of the event I use another Text box with Larger Font.
I want to be able to do some formatting such as Bold, Font Size, Colour change of single words.
I was looking at the DBPro field options and I noticed the field 'Picture' can store more than a picture.
It can store contents such as a Rich Text .How can I use a field on the Main Screen change the text with formatting options and save it to a Blob field in the Database and print my Ticket?
Would be very much appreciated!!
I wrote a "Simple Ticket Maker" app which I would like to make more flexible.
In the description of the event, I am limited to a Text Box (multiple lines) with fixed font and size which is printed from a DBPro field of memo.
This field is changed as event description changes.
For the header name of the event I use another Text box with Larger Font.
I want to be able to do some formatting such as Bold, Font Size, Colour change of single words.
I was looking at the DBPro field options and I noticed the field 'Picture' can store more than a picture.
It can store contents such as a Rich Text .
How can I use a field on the Main Screen change the text with formatting options and save it to a Blob field in the Database and print my Ticket?
Would be very much appreciated!!
Quote from Vadim on November 7, 2025, 8:21 am@cssystems
Good afternoon!
You can use the EditorsToolbox 1.75 plugin (C. Giebel).
A small example of such an application with a database.
Good afternoon!
You can use the EditorsToolbox 1.75 plugin (C. Giebel).
A small example of such an application with a database.
Quote from CSSystems on November 8, 2025, 4:00 pmI do use Report Designer. My question is about a Picture field showing Rich Text I have created in the Ticket Description.
Right now it is only allows plain text, one font one size.
I do use Report Designer. My question is about a Picture field showing Rich Text I have created in the Ticket Description.
Right now it is only allows plain text, one font one size.
Quote from CSSystems on November 8, 2025, 4:18 pmVadim,
Thanks for the reminder about EditBox .
I will try to create a document formatted that I can save in the Picture (Blob).
Vadim,
Thanks for the reminder about EditBox .
I will try to create a document formatted that I can save in the Picture (Blob).
Quote from CSSystems on November 11, 2025, 6:12 pmI have studied the EditorsToolbox. Vadim I had trouble looking at the sample app because of the language.
I am studying the code.I am using a Memo field in the database to store the RTF . I mentioned using a Blob field. Still not sure that is an option.
I am having trouble with the text. It wants to show the raw code instead of the formatted text in the Report Designer.
Can you help me?
I have studied the EditorsToolbox. Vadim I had trouble looking at the sample app because of the language.
I am studying the code.
I am using a Memo field in the database to store the RTF . I mentioned using a Blob field. Still not sure that is an option.
I am having trouble with the text. It wants to show the raw code instead of the formatted text in the Report Designer.
Can you help me?
Quote from Vadim on November 11, 2025, 8:10 pm@cssystems
I use the Memo field in the specified project, since the RTF format is a text format in which there is nothing but text characters that encode everything, including images. Therefore, Memo is perfect for formatted text and even with pictures inside.
The project probably isn't working properly for you, because it uses several plugins (they need to be installed):• zmFunctions 1.0b (Peter Pavlov)
• EditorsToolbox 1.75 (C. Giebel)
• NeoBookDBPro 1.6a (NeoSoft Corp.) – NeoDBpro (SinLios)
• zmToRTF (Peter Pavlov)
• ksFunctions (Igor R.)
• hpwUtility 2.16 (Hans-Peter Wickern)
I use the Memo field in the specified project, since the RTF format is a text format in which there is nothing but text characters that encode everything, including images. Therefore, Memo is perfect for formatted text and even with pictures inside.
The project probably isn't working properly for you, because it uses several plugins (they need to be installed):
• zmFunctions 1.0b (Peter Pavlov)
• EditorsToolbox 1.75 (C. Giebel)
• NeoBookDBPro 1.6a (NeoSoft Corp.) – NeoDBpro (SinLios)
• zmToRTF (Peter Pavlov)
• ksFunctions (Igor R.)
• hpwUtility 2.16 (Hans-Peter Wickern)
Quote from Matilde on November 11, 2025, 9:54 pmHi @vadim please
Hi friend, @vadim do you happen to have any documentation explaining how to use zmToRFT plugin? I downloaded it but it didn't come with any help instructions.
Or could you provide an example?
Thanks in advance.
BestRegards
Hi @vadim please
Hi friend, @vadim do you happen to have any documentation explaining how to use zmToRFT plugin? I downloaded it but it didn't come with any help instructions.
Or could you provide an example?
Thanks in advance.
BestRegards
Quote from Vadim on November 12, 2025, 6:59 amGood day, @matilda!
The zmToRFT plugin has only one command, zmASCII2RTF. It allows you to translate the ASCII code (this is the first parameter of the command) into RTF characters (the variable name for the result is specified in the second parameter of the command). This should be done if you perform a full-text search in a database in which information is stored in rich text format (RTF).
An example of usage.
What the user entered is first translated into ASCII code (using the zmConvertString command from the zmFunctions plugin), and then into RTF characters to prepare for database search:zmConvertString "StrToAscii" "[TextEdit]" "[ASCII]"
zmASCII2RTF "[ASCII]" "[findRTF]"
Good day, @matilda!
The zmToRFT plugin has only one command, zmASCII2RTF. It allows you to translate the ASCII code (this is the first parameter of the command) into RTF characters (the variable name for the result is specified in the second parameter of the command). This should be done if you perform a full-text search in a database in which information is stored in rich text format (RTF).
An example of usage.
What the user entered is first translated into ASCII code (using the zmConvertString command from the zmFunctions plugin), and then into RTF characters to prepare for database search:
zmConvertString "StrToAscii" "[TextEdit]" "[ASCII]"
zmASCII2RTF "[ASCII]" "[findRTF]"
Quote from Matilde on November 13, 2025, 4:52 pm@vadim hI!
Is it possible to get a translation of the ksFunctions plugin? I really can't understand the explanations of each command in Russian...
@vadim hI!
Is it possible to get a translation of the ksFunctions plugin? I really can't understand the explanations of each command in Russian...
Quote from Vadim on November 13, 2025, 7:21 pm@matilde Good afternoon!
Here is the translation of the commands of the ksFunctions plugin:
ksSetColorTransparent=Set the color of the full transparency of the object(s) in the main window. The color is specified in RGB format.
ksNoColorTransparent=Cancel the color of the full transparency of the object(s) in the main window.
ksSetColorTransparentCustomWindow=Set the color of the full transparency of the object(s) in the external window. The color is specified in RGB format.
ksNoColorTransparentCustomWindow=Cancel the color of the full transparency of the object(s) in the external window.
ksToolWindow=Change window style to ToolWindow.
ksDialogBox=Change the window style to DialogBox (standard).
ksNoBorder=Change window style to NoBorder.
ksWinNoSizeBox=Remove the window stretching property.
ksWinSizeBox=Add a window stretching property.
ksNoSusMenu=Remove the system buttons "Collapse, Expand, Close".
ksAddSusMenu=Add the system buttons "Collapse", "Expand", "Close".
ksDisableButtonMinimize=Deactivate the "Collapse" button.
ksEnableButtonMinimize=Activate the "Collapse" button.
ksDisableButtonMaximize=Deactivate the "Expand" button.
ksEnableButtonMaximize=Activate the "Expand" button.
ksDisableButtonClose=Deactivate the "Close" button.
ksEnableButtonClose=Activate the "Close" button.
ksHideButtonMinimizeMaximize=Hide the system buttons "Collapse", "Expand".
ksSetWindowMask=Apply a black and white mask on the main window.
ksCustomWindowSizeBox=Add a stretch property to the outer window.
ksShotDesktopToJpg =Take a snapshot of the desktop and save the file in JPG format. You can set the compression ratio.
ksShotDesktopToBmp=Take a picture of your desktop and save the file in BMP format.
ksShotWindow=Take a picture of the full window (even outside the desktop) and save the file in BMP format.
ksShotObject=Take a picture of an object (even if the window is outside the desktop) and save the file in BMP format.
ksShotRect=Take a picture of any area of the screen and save the file in BMP format.
ksHideShowIconDesktop=Hide\ Show desktop icons.
ksGetPixelColor=Get the pixel color of a specific point on the screen in RGB format.
ksClipCursor=Restrict the movement of the mouse cursor along the specified screen coordinates.
ksNoClipCursor=Undo the mouse cursor movement restriction previously created by the "ksClipCursor" command.
ksMouseStatus=Disconnect \ connect the mouse.
ksMouseEvent=Simulate left, middle, and right mouse clicks.
ksWindowFromPoint=Get the handle (HWND) of the window or controls under the mouse cursor.
ksSetSystemCursor=Install a new system cursor.
ksPrevSystemCursor=Return the previous system cursor.
ksHideShowSistemTray=Hide\ show the system tray.
ksCapsLockStatus=Determine the status of the CapsLock mode. The result is returned to the [ks_CapsRez] variable. True-enabled, False-disabled.
ksCapsLockPush=Enable or disable CapsLock mode.
ksSetTextEntryOptions=Change the properties of the Text Entry object (TextEntry).
ksRenameFile=Rename the external file.
ksColorDialog=Display a custom color selection dialog and save the selected color in a variable in RGB format.
ksSetWatermark=Apply a watermark on the image (picture on picture).
ksEjectCD_ROM=Open the drive door.
ksCloseCD_ROM=Close the drive door.
ksCopyFileToClip=Copy a file of any extension to the clipboard.
ksSetWindowPngMaskShadow =Apply a mask on the main PNG window with the ability to display a translucent shadow and other areas. Initially, the window should not have a title bar and should match the size of the PNG image.
ksGetSysColor=Get the system colors of various controls in RGB format.You can also use the online database of commands for many plugins here. This is a page from my free online course, registration is required on the website: https://distant.orgpsiholog.ru/mod/data/view.php?id=725
@matilde Good afternoon!
Here is the translation of the commands of the ksFunctions plugin:
ksSetColorTransparent=Set the color of the full transparency of the object(s) in the main window. The color is specified in RGB format.
ksNoColorTransparent=Cancel the color of the full transparency of the object(s) in the main window.
ksSetColorTransparentCustomWindow=Set the color of the full transparency of the object(s) in the external window. The color is specified in RGB format.
ksNoColorTransparentCustomWindow=Cancel the color of the full transparency of the object(s) in the external window.
ksToolWindow=Change window style to ToolWindow.
ksDialogBox=Change the window style to DialogBox (standard).
ksNoBorder=Change window style to NoBorder.
ksWinNoSizeBox=Remove the window stretching property.
ksWinSizeBox=Add a window stretching property.
ksNoSusMenu=Remove the system buttons "Collapse, Expand, Close".
ksAddSusMenu=Add the system buttons "Collapse", "Expand", "Close".
ksDisableButtonMinimize=Deactivate the "Collapse" button.
ksEnableButtonMinimize=Activate the "Collapse" button.
ksDisableButtonMaximize=Deactivate the "Expand" button.
ksEnableButtonMaximize=Activate the "Expand" button.
ksDisableButtonClose=Deactivate the "Close" button.
ksEnableButtonClose=Activate the "Close" button.
ksHideButtonMinimizeMaximize=Hide the system buttons "Collapse", "Expand".
ksSetWindowMask=Apply a black and white mask on the main window.
ksCustomWindowSizeBox=Add a stretch property to the outer window.
ksShotDesktopToJpg =Take a snapshot of the desktop and save the file in JPG format. You can set the compression ratio.
ksShotDesktopToBmp=Take a picture of your desktop and save the file in BMP format.
ksShotWindow=Take a picture of the full window (even outside the desktop) and save the file in BMP format.
ksShotObject=Take a picture of an object (even if the window is outside the desktop) and save the file in BMP format.
ksShotRect=Take a picture of any area of the screen and save the file in BMP format.
ksHideShowIconDesktop=Hide\ Show desktop icons.
ksGetPixelColor=Get the pixel color of a specific point on the screen in RGB format.
ksClipCursor=Restrict the movement of the mouse cursor along the specified screen coordinates.
ksNoClipCursor=Undo the mouse cursor movement restriction previously created by the "ksClipCursor" command.
ksMouseStatus=Disconnect \ connect the mouse.
ksMouseEvent=Simulate left, middle, and right mouse clicks.
ksWindowFromPoint=Get the handle (HWND) of the window or controls under the mouse cursor.
ksSetSystemCursor=Install a new system cursor.
ksPrevSystemCursor=Return the previous system cursor.
ksHideShowSistemTray=Hide\ show the system tray.
ksCapsLockStatus=Determine the status of the CapsLock mode. The result is returned to the [ks_CapsRez] variable. True-enabled, False-disabled.
ksCapsLockPush=Enable or disable CapsLock mode.
ksSetTextEntryOptions=Change the properties of the Text Entry object (TextEntry).
ksRenameFile=Rename the external file.
ksColorDialog=Display a custom color selection dialog and save the selected color in a variable in RGB format.
ksSetWatermark=Apply a watermark on the image (picture on picture).
ksEjectCD_ROM=Open the drive door.
ksCloseCD_ROM=Close the drive door.
ksCopyFileToClip=Copy a file of any extension to the clipboard.
ksSetWindowPngMaskShadow =Apply a mask on the main PNG window with the ability to display a translucent shadow and other areas. Initially, the window should not have a title bar and should match the size of the PNG image.
ksGetSysColor=Get the system colors of various controls in RGB format.
You can also use the online database of commands for many plugins here. This is a page from my free online course, registration is required on the website: https://distant.orgpsiholog.ru/mod/data/view.php?id=725
Quote from Matilde on November 14, 2025, 4:06 am@vadim
Thanks a million, friend. I just don't know where to put the translation you sent me so it works... or does it need to be saved to an external file with a specific name and extension in a particular location, like most Russian plugins?
Thanks again!
Thanks a million, friend. I just don't know where to put the translation you sent me so it works... or does it need to be saved to an external file with a specific name and extension in a particular location, like most Russian plugins?
Thanks again!
Quote from Vadim on November 14, 2025, 5:54 am@matilde
It's just a list of commands with translation. If I remember correctly, this plugin does not have a built-in translation capability to other languages. But thanks to the image translation feature (with text recognition) in modern browsers, this is no longer a problem.
In the case of a plug-in in a foreign language, it can be convenient to simply point the phone's smart camera at the plug-in window and receive instant translation on the phone. If there are difficulties, I will try to help.
It's just a list of commands with translation. If I remember correctly, this plugin does not have a built-in translation capability to other languages. But thanks to the image translation feature (with text recognition) in modern browsers, this is no longer a problem.
In the case of a plug-in in a foreign language, it can be convenient to simply point the phone's smart camera at the plug-in window and receive instant translation on the phone. If there are difficulties, I will try to help.