Recent content by FastJavelin

  1. F

    Data-aware controls and TIMESTAMP WITH LOCAL TIME ZONE

    TOracleSession.Preferences.TimeStampsAsString = FALSE (default value); when I set it to TRUE, I get an error when loading a db record: Could not convert variant of type (string) into type (double)
  2. F

    Data-aware controls and TIMESTAMP WITH LOCAL TIME ZONE

    My application uses data-aware controls bound to database fields of type TIMESTAMP WITH LOCAL TIME ZONE. When I READ data from the db, time values are displayed correctly i.e. in the Session Time Zone. However, when I POST data to the db, time values are stored as if they were expressed in the...
  3. F

    Updating dataset based upon join

    My problem is basically as follows: I have a Delphi form with 2 DBEdit fields; I will refer to them here by DBEditX and DBEditY. The fields are bound to a dataset with this SQL statement: SELECT T1.RowID, T1.X AS X, NVL(T2.Y, T1.Y) AS Y FROM T1, T2 WHERE T1.FK = T2.PK (+) (1) If T1.FK is NULL...
Back
Top