Xojo Developer Conference
25/27th April 2018 in Denver.
MBS Xojo Conference
6/7th September 2018 in Munich, Germany.

Platforms to show: All Mac Windows Linux Cross-Platform

SQLIntervalMBS.Days as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: The days in this interval.
Notes: (Read only property)

Feedback, Comments & Corrections

SQLIntervalMBS.DoubleValue as Double
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: The value of this interval.
Example:
dim n as new SQLIntervalMBS(1,2,3,4)

MsgBox str(n.DoubleValue) // shows "1.085463" for 1 day, 2 hours, 3 minutes and 4 seconds
Notes: (Read only property)

Feedback, Comments & Corrections

SQLIntervalMBS.Fraction as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 15.1 Yes Yes Yes Yes No
Function: The fraction of a second in nano seconds.
Notes:
Range 0..999999999.
(Read only property)

Feedback, Comments & Corrections

SQLIntervalMBS.Hours as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: The hours value.
Notes: (Read only property)

Feedback, Comments & Corrections

SQLIntervalMBS.Minutes as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: The minutes value.
Notes: (Read only property)

Feedback, Comments & Corrections

SQLIntervalMBS.Seconds as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: The seconds value.
Notes: (Read only property)

Feedback, Comments & Corrections

SQLIntervalMBS.StringValue as string
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: The interval as a string.
Example:
dim n as new SQLIntervalMBS(5)

MsgBox n.StringValue // shows "120:00:00" for 120 hours
Notes: (Read only property)

Feedback, Comments & Corrections

SQLIntervalMBS.TotalDays as Double
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: The total days value.
Example:
dim n as new SQLIntervalMBS(1,2,3,4)

MsgBox str(n.TotalDays) // shows "1"
Notes: (Read only property)

Feedback, Comments & Corrections

SQLIntervalMBS.TotalHours as Double
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: The total hours value.
Example:
dim n as new SQLIntervalMBS(1,2,3,4)

MsgBox str(n.TotalHours) // shows "26"
Notes: (Read only property)

Feedback, Comments & Corrections

SQLIntervalMBS.TotalMinutes as Double
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: The total minutes value.
Example:
dim n as new SQLIntervalMBS(1,2,3,4)

MsgBox str(n.TotalMinutes) // shows "1563"
Notes: (Read only property)

Feedback, Comments & Corrections

SQLIntervalMBS.TotalSeconds as Double
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: The total seconds value.
Notes:
dim n as new SQLIntervalMBS(1,2,3,4)

MsgBox str(n.GetTotalSeconds) // shows "93784"
(Read only property)

Feedback, Comments & Corrections

The items on this page are in the following plugins: MBS SQL Plugin.




Links
MBS FileMaker Plugins