Class: cDbTextEdit

Properties Events Methods Index of Classes

Allows the user to enter and edit text connected to a column in a database table

Hierarchy

cObject
---cUIObject
------DfBaseObject
---------DfBaseWindow
------------DfBaseUIWindow
---------------DfBaseControl
------------------DfBaseTextEdit
---------------------cTextEdit
------------------------cDbTextEdit_
---------------------------cDbTextEditDS_
------------------------------cDbTextEdit

Library: Windows Application Class Library

Package: cDbTextEdit.pkg

Mixins: Extended_DEO_Status_Help_Mixin Extended_DEO_Status_Help_Tooltip_Mixin Extended_DEO_Mixin Extended_DEO_TextEditMixin

Description

The data-aware cDbTextEdit class allows the user to enter and edit text connected to a column in a database table.

The cDbTextEdit class is a data-aware class similar to the cTextEdit class.
The cDbRichEdit class is a rich-text (RTF) class similar to the cDbTextEdit class.

The default maximum number of characters for the control is 64 KB (65536 bytes or characters). This can be changed or retrieved via piMaxChars.

Syntax

Use cDbTextEdit.pkg

Object oObjectName is a cDbTextEdit
    Set Size to iHeight iWidth
    Set Location to iRow iColumn
 End_Object

Sample

Object oCustomer_Comments is a cDbTextEdit
    Entry_Item Customer.Comments
    Set Size to 71 242
    Set Location to 9 9
    Set peAnchors to anAll
End_Object

To set and get the value of a cDbTextEdit programmatically using Field_Changed_Value and Field_Current_Value, be sure to set pbBypassDDFieldBuffer to False. See DDOs and Extended Field Support for more information.

Current Selection in a Rich Edit Control

The user can select text in a rich edit control by using the mouse or the keyboard. The current selection is the range of selected characters, or the position of the insertion point if no characters are selected. An application can get information about the current selection, set it, determine when it changes, and show or hide the selection highlight.

Word and Line Breaks

A rich edit control calls a function called a word-break procedure to find breaks between words and to determine where it can break lines. The control uses this information when performing word-wrap operations and when processing CTRL+LEFT ARROW key and CTRL+RIGHT ARROW key combinations. An application can send messages to a rich edit control to replace the default word-break procedure, to retrieve word-break information, and to determine what line a given character falls on.

A linefeed (LF) character can be added to text programmatically by adding ASCII character 10 to a string using the character function. A carriage return (CR) character can be added to text programmatically by adding ASCII character 13 to a string using the character function. Either a LF or CR character will break the current line in the control. Also see AppendTextLn.

Text Edit Shortcut Keys

Text edit controls support the following shortcut keys.

Keys Operations Comments
Shift+Backspace Generate a LRM/LRM on a bidi keyboard BiDi specific
Ctrl+Tab Tab
Ctrl+Clear Select all
Ctrl+Number Pad 5 Select all
Ctrl+A Select all
Ctrl+C Copy
Ctrl+V Paste
Ctrl+X Cut
Ctrl+Z Undo
Ctrl+Y Redo
Ctrl+' (apostrophe) Accent acute After pressing the short cut key, press the appropriate letter (for example a, e, or u). This applies to English, French, German, Italian, and Spanish keyboards only.
Ctrl+` (grave) Accent grave See Ctrl+' comments.
Ctrl+~ (tilde) Accent tilde See Ctrl+' comments.
Ctrl+; (semicolon) Accent umlaut See Ctrl+' comments.
Ctrl+Shift+6 Accent caret (circumflex) See Ctrl+' comments.
Ctrl+, (comma) Accent cedilla See Ctrl+' comments.
Ctrl+Shift+' (apostrophe) Activate smart quotes
Backspace If text is protected, beep and do not delete it. Otherwise, delete previous character.
Ctrl+Backspace Delete previous word. This generates a VK_F16 code.
F16 Same as Backspace.
Ctrl+Insert Copy
Shift+Insert Paste
Insert Overwrite DBCS (double-byte character set) does not overwrite.
Ctrl+Left Arrow Move cursor one word to the left. On bidi keyboard, this depends on the direction of the text.
Ctrl+Right Arrow Move cursor one word to the right. See Ctrl+Left Arrow comments.
Ctrl+Left Shift Left alignment In BiDi documents, this is for left-to-right reading order.
Ctrl+Right Shift Right alignment In BiDi documents, this is for right-to-left reading order.
Ctrl+Up Arrow Move to the line above.
Ctrl+Down Arrow Move to the line below.
Ctrl+Home Move to the beginning of the document.
Ctrl+End Move to the end of the document.
Ctrl+Page Up Move one page up. If in SystemEditMode and Single Line control, do nothing.
Ctrl+Page Down Move one page down. See Ctrl+Page Up comments.
Ctrl+Delete Delete the next word or selected characters.
Shift+Delete Cut the selected characters.
Esc Stop drag-drop. While doing a drag-drop of text.
Alt+Esc Change the active application.
Alt+X Converts the Unicode hexadecimal value preceding the insertion point to the corresponding Unicode character.
Alt+Shift+X Converts the Unicode character preceding the insertion point to the corresponding Unicode hexadecimal value.
Alt+0xxx (Number Pad) Inserts Unicode values if xxx is greater than 255. When xxx is less than 256, ASCI range text is inserted based on the current keyboard. Must enter decimal values.
Alt+Shift+Ctrl+F12 Hex to Unicode. In case Alt+X is already taken for another use.
Alt+Shift+Ctrl+F11 Selected text will be output to the debugger window and saved to %temp%\DumpFontInfo.txt. For Debug only (need to set Flag=8 in Win.ini)

Keys	Operations	Comments

Shift+Backspace	Generate a LRM/LRM on a bidi keyboard	BiDi specific
Ctrl+Tab	Tab
Ctrl+Clear	Select all
Ctrl+Number Pad 5	Select all
Ctrl+A	Select all
Ctrl+C	Copy
Ctrl+V	Paste
Ctrl+X	Cut
Ctrl+Z	Undo
Ctrl+Y	Redo
Ctrl+' (apostrophe)	Accent acute	After pressing the short cut key, press the appropriate letter (for example a, e, or u). This applies to English, French, German, Italian, and Spanish keyboards only.
Ctrl+` (grave)	Accent grave	See Ctrl+' comments.
Ctrl+~ (tilde)	Accent tilde	See Ctrl+' comments.
Ctrl+; (semicolon)	Accent umlaut	See Ctrl+' comments.
Ctrl+Shift+6	Accent caret (circumflex)	See Ctrl+' comments.
Ctrl+, (comma)	Accent cedilla	See Ctrl+' comments.
Ctrl+Shift+' (apostrophe)	Activate smart quotes
Backspace	If text is protected, beep and do not delete it. Otherwise, delete previous character.
Ctrl+Backspace	Delete previous word. This generates a VK_F16 code.
F16	Same as Backspace.
Ctrl+Insert	Copy
Shift+Insert	Paste
Insert	Overwrite	DBCS (double-byte character set) does not overwrite.
Ctrl+Left Arrow	Move cursor one word to the left.	On bidi keyboard, this depends on the direction of the text.
Ctrl+Right Arrow	Move cursor one word to the right.	See Ctrl+Left Arrow comments.
Ctrl+Left Shift	Left alignment	In BiDi documents, this is for left-to-right reading order.
Ctrl+Right Shift	Right alignment	In BiDi documents, this is for right-to-left reading order.
Ctrl+Up Arrow	Move to the line above.
Ctrl+Down Arrow	Move to the line below.
Ctrl+Home	Move to the beginning of the document.
Ctrl+End	Move to the end of the document.
Ctrl+Page Up	Move one page up.	If in SystemEditMode and Single Line control, do nothing.
Ctrl+Page Down	Move one page down.	See Ctrl+Page Up comments.
Ctrl+Delete	Delete the next word or selected characters.
Shift+Delete	Cut the selected characters.
Esc	Stop drag-drop.	While doing a drag-drop of text.
Alt+Esc	Change the active application.
Alt+X	Converts the Unicode hexadecimal value preceding the insertion point to the corresponding Unicode character.
Alt+Shift+X	Converts the Unicode character preceding the insertion point to the corresponding Unicode hexadecimal value.
Alt+0xxx (Number Pad)	Inserts Unicode values if xxx is greater than 255. When xxx is less than 256, ASCI range text is inserted based on the current keyboard.	Must enter decimal values.
Alt+Shift+Ctrl+F12	Hex to Unicode.	In case Alt+X is already taken for another use.
Alt+Shift+Ctrl+F11	Selected text will be output to the debugger window and saved to %temp%\DumpFontInfo.txt.	For Debug only (need to set Flag=8 in Win.ini)