Problem with new ODAC-Build

Campinoi · Post by **Campinoi** » Thu 14 Apr 2005 11:45

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

Campino · Post by **Campino** » Thu 14 Apr 2005 11:48

the ODAC-Build is ODAC-Build : 5.50.0.17

Paul · Post by **Paul** » Thu 14 Apr 2005 11:59

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?

Campino · Post by **Campino** » Thu 14 Apr 2005 12:02

The Type is Timestamp and i use the net-option.

After the Update with the new build exist this Problem.

Paul · Post by **Paul** » Fri 15 Apr 2005 08:07

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.

Campino · Post by **Campino** » Fri 15 Apr 2005 13:19

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;