- Vytvoril/a D2000 Dev Team, naposledy zmenené júl 07, 2021
Vidíte historickú verziu tejto stránky. Pozrite si aktuálnu verziu.
Porovnať s aktuálnou verziou Zobraziť históriu stránky
« Predchádzajúce Verzia 4 Ďalej »
%SubTimesLocal function
REAL %SubTimesLocal( TIME in TimeA, TIME in TimeB, TEXT in timeZone := %GetCurrentTimeZone() )
TimeA | Absolute time. | |||||||||||||||||||||
TimeB | Absolute time. | |||||||||||||||||||||
timeZone | Name of the time zone used for conversion to local time (e.g. "Europe/London") or definition of fixed offset from UTC using format "(+|-)hh[:mi[:ss]]", where hh defines a number of hours, mi defines a number of minutes, and ss defines a number of seconds. Sign as well as a number of hours are mandatory parts of offset definition, number of minutes and seconds are optional and default to 0 (e.g. "+02:30" defines offset of 2 hours and 30 minutes from UTC). The empty text has the same meaning as function %GetCurrentTimeZone. DB_INSERT and DBS_INSERT actions
Function
The action will insert one or more rows into the table.
Declaration
DB_INSERT handleIdent_Int, rowIdent, retCodeIdent_Int [ORAHINT hintIdent_Str] DBS_INSERT dbObjIdent, rowIdent, retCodeIdent_Int [TRANS transHandle_Int] [ORAHINT hintIdent_Str]
or
DB_INSERT handleIdent_Int, structIdent, retCodeIdent_Int [ORAHINT hintIdent_Str] DBS_INSERT dbObjIdent, structIdent, retCodeIdent_Int [TRANS transHandle_Int] [ORAHINT hintIdent_Str]
Parameters
Return code
The value of the parameter transHandle_Int. See the table of error codes. It is possible to get extended error information.
Description
Table must be opened with the access _DB_MODIFY. There must be the correct structure type of inserted row or structure. Values of all items of every inserted row must be valid.
The advantage of the action DBS_INSERT at work with a table is the possibility to leave out its closing and opening (shorter code). For D2000 v5.00: an disadvantage of the action DBS_INSERT is in speed. Each DBS_INSERT call results in necessity to open and close the database in DBManager - it can be a time-consuming operation and it is a comparatively nonstandard method in term of databases. TRANS For D2000 v6.00 and higher: DBManager optimization (connection recycling, predefined connections) causes, that the action DBS_INSERT is executes as quick as the action DB_INSERT and as moreover there is saved a time required for execution of the action DB_CONNECT to open the database.
Related topics
Related pages: |
; ================================================================= ; Using time zone "Europe/Bratislava" ; Daylight saving time was observed in year 2009, therefore time shifts occured. ; Winter [B] time was 1 hour ahead of UTC, summer [A] time was 2 hours ahead of UTC. ; Summer time was from 29th March 2009 to 24th October 2009. ; A3:00:00 is changed to B2:00:00 on Sunday (25th October 2009). ; ================================================================= BEGIN TIME _timeA TIME _timeB TIME _baseTime REAL _subLocal1 REAL _subLocal2 ; 2009-10-25 00:30:00 UTC _timeA := %StrToTimeEx("2009-10-25 A2:30:00", "yyyy-mm-dd hh:mi:ss", "Europe/Bratislava") ; 2009-10-25 01:30:00 UTC _timeB := %StrToTimeEx("2009-10-25 B2:30:00", "yyyy-mm-dd hh:mi:ss", "Europe/Bratislava") ; 2009-10-24 23:30:00 UTC _baseTime := %StrToTimeEx("2009-10-25 01:30:00", "yyyy-mm-dd hh:mi:ss", "Europe/Bratislava") ; difference 1 hour(s) (3600 seconds) _subLocal1 := %SubTimesLocal(_timeA, _baseTime, "Europe/Bratislava") ; difference 1 hour(s) (3600 seconds) _subLocal2 := %SubTimesLocal(_timeB, _baseTime, "Europe/Bratislava") END
- Žiadne štítky