Hello ( Geoff ;-) )

IBO 4.7.16, FB 1.5 SQLDialect 1, Enh 2.2.1, D6, short date format dd/MM/yy

I have odd behaviour with a TIB_DateTime edit. Clicking the calendar drop
down and clicking 28 march puts '/28/0307' in the display, when the control
is exited this goes to '28/03/07'.

Clicking into the display puts it back to '/28/0307'

pressing delete gives '/ / |' where '|' is the carret. Typing '280307'
produces '/28/0307', exiting control goes to '28/03/07'.

There are no events attached, no layouts or masks specified and no
manipulation in code. The database field is type DATE. Query column
attribute set to NO TIME.

Here are the objects

object IB_DateTimeEnh2: TIB_DateTimeEnh
Left = 109
Top = 8
Width = 121
Height = 21
DataField = 'INVOICE_DATE'
DataSource = dsDesp
Color = clSilver
Ctl3D = True
ParentCtl3D = False
TabOrder = 2
DateOptions = []
DateDateCellColor = clSilver
DropDownColor = clSilver
end

object qDesp: TIB_Query
ColumnAttributes.Strings = (
'INVOICE_DATE=NOTIME')
DatabaseName = ....
IB_Connection = Main.ibCon
IB_Transaction = IB_Transaction1
SQL.Strings = (
'select do_no,INVOICE_DATE,SPECIAL_INSTRUCTIONS'
'from do_header where DO_NO=:DO_NO')
EditSQL.Strings = (
'UPDATE DO_HEADER SET'
' INVOICE_DATE = :INVOICE_DATE,'
' SPECIAL_INSTRUCTIONS = :SPECIAL_INSTRUCTIONS'
'WHERE'
' DO_NO = :OLD_DO_NO')
KeyLinks.Strings = (
'do_no')
MasterSource = ib_dsDyNote
MasterParamLinks.Strings = (
'do_no=do_header.do_no')
Left = 284
Top = 324
ParamValues = (
'DO_NO=')
end

Regards
Paul




[Non-text portions of this message have been removed]