Calendar - Scripts for SQL Server

Print Page | Close Window

Scripts for SQL Server

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Calendar
Forum Description: Topics Related to Codejock Calendar
URL: http://forum.codejock.com/forum_posts.asp?TID=4720
Printed Date: 30 June 2024 at 12:31pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Scripts for SQL Server

Posted By: flauzer
Subject: Scripts for SQL Server
Date Posted: 03 August 2006 at 10:08am

Note:

The scripts for SQL Provider are not updated.....

....Calendar\VB\CalendarSample\SQLscripts

Flavio

Replies:

Posted By: sserge
Date Posted: 09 August 2006 at 4:24pm

Thanks.

CustomDataProvider samples will be updated (using SQL Server). Added new fields: ScheduleID, CustomIconsIDs.

Anything else?..

--
WBR,
Serge

Posted By: flauzer
Date Posted: 17 August 2006 at 10:06am

The information about multi-resources,

(I mean calendarmultipleschedulesext.xtp_cal)

needs SQL tables?

Thanks

Posted By: Stribor
Date Posted: 18 August 2006 at 11:41am

Other cuestion about multiple-resources:

Dim pRes0 As New CalendarResource

pRes0.DataProvider.Create -- don't create EventsSchedules table with MS Access data provider.

Only create: Event, Options and RecurrencePattern.

I'm use VB6, Access XP, ADO 2.8.

Thanks in advanced !!

Posted By: sserge
Date Posted: 21 August 2006 at 2:02pm

About EventsSchedules table - yes, this is true.
Data provider has a quite simple schedules collection (ID, Name).
For the current version you'll have to organize schedules storing by yourself and fill this collection in your own way after creating or opening data provider.

We'll most likely change this for future by adding Schedules as a separate table.

--
WBR,
Serge