Codejock Developer Community : Setting up Multiple resources http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 28 Apr 2026 07:05:38 +0000 Sun, 21 Jan 2007 16:05:00 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=3989 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Setting up Multiple resources : mindserve wrote:These are...]]> http://forum.codejock.com/forum_posts.asp?TID=3989&PID=19577&title=setting-up-multiple-resources#19577 Author: sserge
Subject: 3989
Posted: 21 January 2007 at 4:05pm

Originally posted by mindserve mindserve wrote:

These are dead links...can you repost the samples?


Forum looks to remove old attachments...

Here it is: uploads/20070121_160444_CalendarSchedul.zip

--
WBR,
Serge
]]> Sun, 21 Jan 2007 16:05:00 +0000 http://forum.codejock.com/forum_posts.asp?TID=3989&PID=19577&title=setting-up-multiple-resources#19577 <![CDATA[Setting up Multiple resources : These are dead links...can you...]]> http://forum.codejock.com/forum_posts.asp?TID=3989&PID=19559&title=setting-up-multiple-resources#19559 Author: mindserve
Subject: 3989
Posted: 20 January 2007 at 2:32pm

These are dead links...can you repost the samples?
1) I've created a very basic Calendar MultiSchedules sample for you, please find it there:  2006-04-16_150350_Calendar_MultiSchedules_simple.zip

2) Please also find updated standard Calendar VB sample, hopefully it will be useful for you: 2006-04-16_150628_CalendarSampleUpd.zip
]]> Sat, 20 Jan 2007 14:32:12 +0000 http://forum.codejock.com/forum_posts.asp?TID=3989&PID=19559&title=setting-up-multiple-resources#19559 <![CDATA[Setting up Multiple resources : Ok, thanks. Will fix those 2 errors. ...]]> http://forum.codejock.com/forum_posts.asp?TID=3989&PID=17210&title=setting-up-multiple-resources#17210 Author: sserge
Subject: 3989
Posted: 10 November 2006 at 4:49am

Ok, thanks. Will fix those 2 errors.]]> Fri, 10 Nov 2006 04:49:42 +0000 http://forum.codejock.com/forum_posts.asp?TID=3989&PID=17210&title=setting-up-multiple-resources#17210 <![CDATA[Setting up Multiple resources : in MakeCreateEventSQL is an error: the...]]> http://forum.codejock.com/forum_posts.asp?TID=3989&PID=17205&title=setting-up-multiple-resources#17205 Author: DikkeLeo
Subject: 3989
Posted: 09 November 2006 at 6:16pm

in MakeCreateEventSQL is an error:
the line
    strSQL = strSQL + "ScheduleID = " & pEvent.ScheduleID & ");" & vbCrLf

must be changed to:
    strSQL = strSQL & pEvent.ScheduleID & ");" & vbCrLf
]]> Thu, 09 Nov 2006 18:16:02 +0000 http://forum.codejock.com/forum_posts.asp?TID=3989&PID=17205&title=setting-up-multiple-resources#17205 <![CDATA[Setting up Multiple resources : found it! ]]> http://forum.codejock.com/forum_posts.asp?TID=3989&PID=17204&title=setting-up-multiple-resources#17204 Author: DikkeLeo
Subject: 3989
Posted: 09 November 2006 at 6:05pm

found it!]]> Thu, 09 Nov 2006 18:05:42 +0000 http://forum.codejock.com/forum_posts.asp?TID=3989&PID=17204&title=setting-up-multiple-resources#17204 <![CDATA[Setting up Multiple resources : There&#039;s an error in frmEditEvent.frm if...]]> http://forum.codejock.com/forum_posts.asp?TID=3989&PID=17203&title=setting-up-multiple-resources#17203 Author: DikkeLeo
Subject: 3989
Posted: 09 November 2006 at 6:02pm

There's an error in frmEditEvent.frm
if you try to save an existing MultiSchedule event, an error is generated at m_pCalender.DoUpdateEvent
The strSQL = m_pHelper.MakeUpdateEventSQL(pEvent) generates a falls SQL query!
The query I got was:
UPDATE CalendarEvents SET
Subject = "john 100",
Location = "",
Body = "",
IsMeeting = 0,
IsPrivate = 0,
LabelID = 0,
BusyStatus = 2,
ImportanceLevel = 1,
StartDateTime = {ts'2006-11-07 09:30:00'},
EndDateTime = {ts'2006-11-07 11:30:00'},
IsAllDayEvent = 0,
IsReminder = 0,
ReminderMinutesBeforeStart = 15,
RemainderSoundFile = "",
RecurrenceState = 0,
RecurrencePatternID = 0,
RExceptionStartTimeOrig = {ts'1899-12-30 00:00:00'},
RExceptionEndTimeOrig = {ts'1899-12-30 00:00:00'},
ISRecurrenceExceptionDeleted = 0,
CustomPropertiesXMLData = "<Calendar CompactMode=\"1\"/>
"
CustomIconsIDs = ""
ScheduleID = 1,
WHERE EventID = 4;
You see the comma behind ScheduleID = 1, this is not allowed. Can you tell me where in the code I can delete this last comma?
Thanks in advance.

]]> Thu, 09 Nov 2006 18:02:30 +0000 http://forum.codejock.com/forum_posts.asp?TID=3989&PID=17203&title=setting-up-multiple-resources#17203 <![CDATA[Setting up Multiple resources : Hello Serge, Yes, I added the...]]> http://forum.codejock.com/forum_posts.asp?TID=3989&PID=17202&title=setting-up-multiple-resources#17202 Author: DikkeLeo
Subject: 3989
Posted: 09 November 2006 at 5:35pm

Hello Serge,
Yes, I added the field ScheduleID to the table. Entered with the example two MultiSchedule events, the field ScheduleID in the table was still 0 (zero) for both events. I stopped the program, changed for the first event the field ScheduleID to 1, and the second to 2. Now they re-appear at the right column! But the ScheduleID field is not automatically changed by the sample program.
I'll have to look at the code for the reason.
Greetings, and thanks for your support. It's a great tool!]]> Thu, 09 Nov 2006 17:35:09 +0000 http://forum.codejock.com/forum_posts.asp?TID=3989&PID=17202&title=setting-up-multiple-resources#17202 <![CDATA[Setting up Multiple resources : Hi, I think I understand your...]]> http://forum.codejock.com/forum_posts.asp?TID=3989&PID=17199&title=setting-up-multiple-resources#17199 Author: sserge
Subject: 3989
Posted: 09 November 2006 at 4:28pm

Hi, I think I understand your problem.
Custom data provider example for version 10 does not use (read/write) ScheduleID Event property.
 
Please add support for ScheduleID property in the same way as this is done for LabelID.
 
This was added to VB sample for version 10.3.1.
You can download it to compare.
 
Also do not forget to add such field to your DB Table.
 
--
WBR,
Serge
]]> Thu, 09 Nov 2006 16:28:30 +0000 http://forum.codejock.com/forum_posts.asp?TID=3989&PID=17199&title=setting-up-multiple-resources#17199 <![CDATA[Setting up Multiple resources : (I use the VB6 version 10, and...]]> http://forum.codejock.com/forum_posts.asp?TID=3989&PID=17174&title=setting-up-multiple-resources#17174 Author: DikkeLeo
Subject: 3989
Posted: 09 November 2006 at 5:03am

(I use the VB6 version 10, and yes, I bought the license)
I altered the following:
in frmMain:
'OpenProvider cjCalendarData_Memory, "Provider=XML;Data Source=" & App.Path & "\Events.xml"
    OpenProvider cjCalendarData_MySQL, "Provider=Custom;DSN=wingymsql"
I use MySQL 4.14 on a Windows machine

in:
Private Sub mnuMultiSchedulesSimple_Click()
'strConnectionString = "Provider=XML;Data Source=" & App.Path & "\" & "CalendarMultipleSchedulesSample.xtp_cal"
    strConnectionString = "Provider=Custom;Data Source=wingymsql"
so the data is not stored in XML, but in MySQL. It is stored in the MySQL database but when I restart the application and I click this function, no data is shown. But when I do not click this function, I see the previously entered data.
I hope you can help me with this.
Thanks in advance.

greetings
]]> Thu, 09 Nov 2006 05:03:01 +0000 http://forum.codejock.com/forum_posts.asp?TID=3989&PID=17174&title=setting-up-multiple-resources#17174 <![CDATA[Setting up Multiple resources : DikkeLeo wrote:Hello, I&#039;ve...]]> http://forum.codejock.com/forum_posts.asp?TID=3989&PID=16522&title=setting-up-multiple-resources#16522 Author: sserge
Subject: 3989
Posted: 14 October 2006 at 11:10am

Originally posted by DikkeLeo DikkeLeo wrote:

Hello,
I've tried the multiple resources, but I can save them to a MySQL database, BUT I can't retreive them!
I hope somebody can help me with this one.


We can try to help, but there is not enough problem details described there. Try to be more specific.

--
WBR,
Serge
]]> Sat, 14 Oct 2006 11:10:35 +0000 http://forum.codejock.com/forum_posts.asp?TID=3989&PID=16522&title=setting-up-multiple-resources#16522