CalendarView.ExportToDB - Revision history

Admin at 15:27, 17 September 2015

2015-09-17T15:27:12Z

2015-09-16T22:49:08Z

2015-09-16T22:19:27Z

2015-09-16T22:15:41Z

2015-08-06T12:20:53Z

94 revisions imported

2013-06-11T10:28:09Z

1 revision

2013-06-11T10:28:09Z

2012-09-05T22:49:04Z

1 revision

2012-09-05T22:49:04Z

2012-08-20T23:23:03Z

1 revision

@@ Line 25: / Line 25: @@
 CREATE TABLE IF NOT EXISTS `mydb`.`calendar` (
    `ID` INT NOT NULL AUTO_INCREMENT,
-   `start` DATETIME NOT NULL,
+   `startDate` DATETIME NOT NULL,
-   `end` DATETIME NULL,
+   `endDate` DATETIME NULL,
    `title` VARCHAR(45) NULL,
    `description` VARCHAR(200) NULL,

← Older revision		Revision as of 22:49, 16 September 2015
Line 19:		Line 19:
	It will update existing records using the [[CalendarEvent.ID]] and		It will update existing records using the [[CalendarEvent.ID]] and
	create new records if the ID isn't set.		create new records if the ID isn't set.
		+
		+
		+	The following SQL code can be used to create a compatible database:
		+	<source lang="sql">
		+	CREATE TABLE IF NOT EXISTS `mydb`.`calendar` (
		+	`ID` INT NOT NULL AUTO_INCREMENT,
		+	`start` DATETIME NOT NULL,
		+	`end` DATETIME NULL,
		+	`title` VARCHAR(45) NULL,
		+	`description` VARCHAR(200) NULL,
		+	`location` VARCHAR(45) NULL,
		+	`color` VARCHAR(10) NULL,
		+	`recurrence` VARCHAR(100) NULL,
		+	PRIMARY KEY (`ID`))
		+	</source>

← Older revision		Revision as of 22:19, 16 September 2015
Line 13:		Line 13:

	Exports all CalendarEvents to the passed'' TableName'' in the passed Database.		Exports all CalendarEvents to the passed'' TableName'' in the passed Database.
		+
		+	This function will return True if there is no error.
		+	Check DB.ErrorCode and DB.ErrorMessage if this function returns False.
		+
		+	It will update existing records using the [[CalendarEvent.ID]] and
		+	create new records if the ID isn't set.

@@ Line 4: / Line 4: @@
 | ownertype=class
 | scope=public
-| parameters=DB As Database, TableName As String, ID As String = "ID", StartDate As String = "Start", EndDate As String = "End", Title As String = "Title", EventColor As String = "Color", Location As String = "Location", Description As String = "Description"
+| parameters=DB As Database, TableName As String, ID As String = "ID", StartDate As String = "Start", EndDate As String = "End", Title As String = "Title", EventColor As String = "Color", Location As String = "Location", Description As String = "Description", Recurrence As String = "Recurrence"
 | returntype=Boolean
 | version=1.4.1

@@ Line 6: / Line 6: @@
 | parameters=DB As Database, TableName As String, ID As String = "ID", StartDate As String = "Start", EndDate As String = "End", Title As String = "Title", EventColor As String = "Color", Location As String = "Location", Description As String = "Description"
 | returntype=Boolean
-| version=1.2.2
+| version=1.4.1
 | platform=all
 }}

← Older revision	Revision as of 12:20, 6 August 2015
(No difference)

← Older revision	Revision as of 10:28, 11 June 2013
(No difference)

← Older revision	Revision as of 22:49, 5 September 2012
(No difference)

← Older revision	Revision as of 23:23, 20 August 2012
(No difference)