Subject | TIB_Query - date problem |
---|---|
Author | Aage Frank Johansen |
Post date | 2014-12-07T21:07:24Z |
I have a couple of queries where the result sets are shown in a
grid. A few of the date fields behave differently from what I expect
(and how other date fields behave).
* The dates show correctly.
* The ellipsis show correctly, and I can use the "calender" to choose a date.
* But, if I write a date like 07122014 it is not accepted as
07.12.2014 (the delimiters do not show up, and I get an error message
about wrong format).
Other date fields in the same query behave correctly.
What is causing this?
I'm using Delphi XE2, Windows/8.1, Firebird/2.5.2 and IBO/5.5.3.
It also happens with Win/XP and IBO/4.9
--
Aage J.
Here is the query representation (of the simplest query) from the dfm file:
----------------------------------------------------------------
object ibqrFESTIVAL: TIB_Query
ColumnAttributes.Strings = (
'VIST_DATO=NOTIME')
FieldsCharCase.Strings = (
'LAND=UPPER')
FieldsGridLabel.Strings = (
'TITTEL=Tittel'
'LAND=Land'
'PRISER=Priser'
'T_TYPE=TittelType'
'FESTIVAL=Festival'
'AAR='#197'r'
'KATEGORI=Kategori'
'VIST_DATO=Vist dato'
'SRT=Sort')
FieldsVisible.Strings = (
'SLNR=FALSE'
'ID=FALSE')
IB_Connection = fDM1.ibcnSL1
IB_Transaction = fDM1.ibx1SL1
SQL.Strings = (
'select ID, SLNR, LAND, AAR, FESTIVAL, KATEGORI, VIST_DATO, SRT'
'from FESTIVALER'
'where SLNR = :SLNR'
'order by SRT')
ConfirmDeletePrompt.Strings = (
'Skal denne recorden slettes ?')
GeneratorLinks.Strings = (
'ID=GEN_FESTIVALNR')
KeyLinks.Strings = (
'ID')
OrderingItems.Strings = (
'LAND=LAND;LAND DESC'
'AAR=AAR;AAR DESC'
'FESTIVAL=FESTIVAL;FESTIVAL DESC'
'KATEGORI=KATEGORI;KATEGORI DESC'
'VIST_DATO=VIST_DATO;VIST_DATO DESC'
'SRT=SRT;SRT DESC')
OrderingLinks.Strings = (
'LAND=ITEM=1'
'AAR=ITEM=2'
'FESTIVAL=ITEM=3'
'KATEGORI=ITEM=4'
'VIST_DATO=ITEM=5'
'SRT=ITEM=6')
RequestLive = True
BeforePost = ibqrFESTIVALBeforePost
Left = 472
Top = 8
ParamValues = (
'SLNR='#39'0'#39)
end
----------------------------------------------------------------
grid. A few of the date fields behave differently from what I expect
(and how other date fields behave).
* The dates show correctly.
* The ellipsis show correctly, and I can use the "calender" to choose a date.
* But, if I write a date like 07122014 it is not accepted as
07.12.2014 (the delimiters do not show up, and I get an error message
about wrong format).
Other date fields in the same query behave correctly.
What is causing this?
I'm using Delphi XE2, Windows/8.1, Firebird/2.5.2 and IBO/5.5.3.
It also happens with Win/XP and IBO/4.9
--
Aage J.
Here is the query representation (of the simplest query) from the dfm file:
----------------------------------------------------------------
object ibqrFESTIVAL: TIB_Query
ColumnAttributes.Strings = (
'VIST_DATO=NOTIME')
FieldsCharCase.Strings = (
'LAND=UPPER')
FieldsGridLabel.Strings = (
'TITTEL=Tittel'
'LAND=Land'
'PRISER=Priser'
'T_TYPE=TittelType'
'FESTIVAL=Festival'
'AAR='#197'r'
'KATEGORI=Kategori'
'VIST_DATO=Vist dato'
'SRT=Sort')
FieldsVisible.Strings = (
'SLNR=FALSE'
'ID=FALSE')
IB_Connection = fDM1.ibcnSL1
IB_Transaction = fDM1.ibx1SL1
SQL.Strings = (
'select ID, SLNR, LAND, AAR, FESTIVAL, KATEGORI, VIST_DATO, SRT'
'from FESTIVALER'
'where SLNR = :SLNR'
'order by SRT')
ConfirmDeletePrompt.Strings = (
'Skal denne recorden slettes ?')
GeneratorLinks.Strings = (
'ID=GEN_FESTIVALNR')
KeyLinks.Strings = (
'ID')
OrderingItems.Strings = (
'LAND=LAND;LAND DESC'
'AAR=AAR;AAR DESC'
'FESTIVAL=FESTIVAL;FESTIVAL DESC'
'KATEGORI=KATEGORI;KATEGORI DESC'
'VIST_DATO=VIST_DATO;VIST_DATO DESC'
'SRT=SRT;SRT DESC')
OrderingLinks.Strings = (
'LAND=ITEM=1'
'AAR=ITEM=2'
'FESTIVAL=ITEM=3'
'KATEGORI=ITEM=4'
'VIST_DATO=ITEM=5'
'SRT=ITEM=6')
RequestLive = True
BeforePost = ibqrFESTIVALBeforePost
Left = 472
Top = 8
ParamValues = (
'SLNR='#39'0'#39)
end
----------------------------------------------------------------