Page 1 of 1
Problem with new ODAC-Build
Posted: Thu 14 Apr 2005 11:45
by Campinoi
After the update with new ODAC-Build i have a problem with timestamp-fields. In datebase : the value is ".... 00:00'. ODAC read "...01:00".
Can you send me the previous Build of ODAC without this Problem.
I have a time-problem
Thanks
Delphi 7 , Oracle 9.2
Posted: Thu 14 Apr 2005 11:48
by Campino
the ODAC-Build is ODAC-Build : 5.50.0.17
Posted: Thu 14 Apr 2005 11:59
by Paul
What is a type of timestamp: TIMESTAMP, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH LOCAL TIME ZONE?
Do you use Net-option connection or OCI client?
Posted: Thu 14 Apr 2005 12:02
by Campino
The Type is Timestamp and i use the net-option.
After the Update with the new build exist this Problem.
Posted: Fri 15 Apr 2005 08:07
by Paul
Please write letter to ODAC support address.
We reproduced your problem and fixed it. This fix will be included in the next ODAC build in a 2 weeks.
Posted: Fri 15 Apr 2005 13:19
by Campino
Bug & Fix :
Fieldtype : TimeStamp
Property Format : HH24:MI
read and write with smartquery :
smartquery.fieldbyname ( 'yx' ).AsdateTime := Value;
field-content and result in visual controls
' ....00:00' -> '...01:00'
' ....01:00'- > '...02:00'
"Fix"
:
procedure TDModuleDP.pFIBDSTermineDES_TIME_ENDGetText
(Sender: TField;
var Text: String; DisplayText: Boolean);
begin
Text := FormatDateTime ( 'HH:NN' , Sender.AsDateTime );
end;