Skip to content

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

Show full hierarchy and direct subclasses

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 keyboardBiDi 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 acuteAfter 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 graveSee Ctrl+' comments.
Ctrl+~ (tilde) Accent tildeSee Ctrl+' comments.
Ctrl+; (semicolon) Accent umlautSee Ctrl+' comments.
Ctrl+Shift+6 Accent caret (circumflex)See Ctrl+' comments.
Ctrl+, (comma) Accent cedillaSee 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 OverwriteDBCS (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 alignmentIn BiDi documents, this is for left-to-right reading order.
Ctrl+Right Shift Right alignmentIn 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)