Beta Testing results

After trying to plug this control in to a real-world app a few things cropped up. Hopefully codejock can make a few changes for 11.2.1 final.

A few missing methods:
SelectAll
ClearUndoBuffer
IndentSelection
UnindentSelection
PrintPreview (this is a show stopper for me)

Missing events:
Change event
SelectionChange event

Missing properties:
RowText(row as long)
RowCount

Some required changes:
FindReplace dialog should allow replace with empty string (currently replace button disables when replace with textbox is empty)
Standard shortcuts like Ctrl+C, Ctrl V, Ctrl A etc don't do anything.

A few bugs:
properties ShowSelectionMargin, ShowLineNumbers, EnableVirtualSpace do not persist when set at design time (there may be more but needs checking)
openfile method doesn't handle ANSI, Big Endian or UTF8 encoding formats (using Unicode version). eg in WinXP notepad create an SQL file and save it in all available encoding formats. Only 1 will load properly.

Problems:
Any attempt to use Text property causes delay (5 secs for 20000 lines). eg if I want to know if there's any text in the control:
bAnyText = (Len(txtSQL1.Text) > 0).
How about a property TextLength or IsBlank. Admittedly, rowcount property would help here but regardless, it seems the Text property is not maintained by the control, rather it's evaluated when accessed.

I still find it necessary to 'load' a blank file with .sql extension to get the syntax highlighting working. I set Text property in code as it's read from database so I want to be able to force a 'language' to be used without it being interpreted from a file extension (which IMO is a bit bad practice).

Wow. You've been busy.

Thanks for all the hard work.