

The user’s system settings control the formats that are used. The Date properties that return formatted date or time information are affected by the user's operating system settings. Conversely, if you change any of these properties, the value of TotalSeconds changes commensurately. API is the complete guide to the specifics of the Xojo language and framework.
Xojo database tutorial how to#
TOPICS provides categorized discussions on how to accomplish specific tasks. If you change the value of the TotalSeconds property, the values of the Year, Month, Day, Hour, Minute, and Second properties change to reflect the second on which TotalSeconds occurs. This documentation is organized into six sections: GETTING STARTED provides step by step tutorials as well as a high-level overview of all you need to know to learn Xojo. The other property values are derived from TotalSeconds. The TotalSeconds property is the “master” property that stores the date/time associated with a Date. Use the ParseDate function to convert a date string to a Date value. What is actually happening is that the Variant stores the value of the TotalSeconds property as a Double, along with the type information that it is a Date (the Variant's Type property = 7).Īlthough Date is a class that is subclassed from Object, VarType identifies a Date as a Date data type (Type=7) rather than an Object (Type=9). You can get the current date and time by creating a new date and reading the values of the Year, Month, Day, Hour, Minute, and Second properties. The date properties of FolderItems can be accessed via the CreationDate and ModificationDate properties of FolderItem objects. If you try to set the date or date/time and the format is incorrect, an UnsupportedFormatException is raised. Not setting the year before entering Feb 29 will cause oddities if the current year is not a leap year.īecause Date implements Operator_Compare, you can use the normal comparison operators to compare date values. Continue reading Good Change, API 2. API 2.0 sets the bind types for you and that means you can switch engines by just changing the Super of your database class and updating the connection settings.

Xojo database tutorial code#
Advanced features API design Application deployment Application structure Build automation Code management Communication Custom controls Data processing Databases. Therefore the order of assignment is important: when dealing with a day that exists in one month when the current system date is in another (such as December 31 when you're in November), setting the Day before the month can result in an unexpected (here ) or even invalid date. Xojo has built in database classes for accessing SQLite, Postgres, MySQL, Microsoft SQL Server, Oracle & ODBC. Tutorials Creating more apps Using the IDE Using the Xojo Language Object-Oriented Programming Example projects Debugging TOPICS. When you create and instantiate a Date object, it is initialized to the current date and time.
Xojo database tutorial windows#
On Windows (due to the Windows API being used), it is not possible to go back further than 1 January 1601.
