![]() |
Setting up Multiple resources |
Post Reply ![]() |
Author | ||
Freq ![]() Newbie ![]() Joined: 11 April 2006 Status: Offline Points: 5 |
![]() ![]() ![]() ![]() ![]() Posted: 11 April 2006 at 10:48pm |
|
I'm very interested in your product. I'm currently evalling it to see if it will work with our software. I need the calendar to be able to view the schedules of multiple people in 1 dayview. I'm having a hard time setting up multiple resources. Do you have any tutorials specific to this? When I use the VB CalendarControl sample and click 'Load Multischedules(Extended) I get the following error (Object variable or With block variable not set). Do you have a simple working sample that will show the basics of how to setup multiple resources/schedules in 1 day view? |
||
![]() |
||
sserge ![]() Moderator Group ![]() Joined: 01 December 2004 Status: Offline Points: 1297 |
![]() ![]() ![]() ![]() ![]() |
|
Hello,
What you describe should be working properly... Could you please specify more information about this problem. What environment do you use (Visual Basic 6.0 ?) Does it show a place in the code where it hangs up? Can you open frmMain in design mode? Does Load Multischedules(Simple) work fine ? Actually, VB sample is what you need: it has a code which shows how to use multi-schedules. -- WBR, Serge |
||
![]() |
||
Freq ![]() Newbie ![]() Joined: 11 April 2006 Status: Offline Points: 5 |
![]() ![]() ![]() ![]() ![]() |
|
I'm using VB6. I'm using the Calendar Sample for VB6.You mentioned 'VB Sample' is that sample different from the one I am currently working with? If so, where can I get it? It hangs up on frmEditEvent in the cmdOK sub at 'If m_pEditingEvent.RecurrenceState <> xtpCalendarRecurrenceMaster Then' the var 'm_pEditingEvent.RecurrenceState' is not set. Multischedules(simple) seems to hang at the same spot too. |
||
![]() |
||
sserge ![]() Moderator Group ![]() Joined: 01 December 2004 Status: Offline Points: 1297 |
![]() ![]() ![]() ![]() ![]() |
|
We have only 1 VB6 sample. But I can not reproduce your problem
![]() Let me ask more questions on that: -- are you using the latest release: 7 April, 2006 Q1 ? (Calendar control version 10.1). If no, please download and try this one. -- what is your environment? Windows version, SP, VB6 version (from its About Box), your default locale? -- what are your steps to reproduce
frmEditEvent:
the var 'm_pEditingEvent.RecurrenceState' is not set
?
-- which DataProvider do you use? is it default file/memory data provider?-- Best regards, Serge |
||
![]() |
||
Freq ![]() Newbie ![]() Joined: 11 April 2006 Status: Offline Points: 5 |
![]() ![]() ![]() ![]() ![]() |
|
I reinstalled the trial software and it no longer hangs there. (I may have edited the code and caused a prob). With the fresh install, I start it, click Dayview, the File/Load Sample multischedules(simple) and it doesn't change the view. File/Open Resources Manager and add 2 resources and it doesn't change the view. -- no new columns. Please give some sample code that shows in the simplest way possible, the steps to create a calendar with 2 or 3 columns(different person in each column). |
||
![]() |
||
sserge ![]() Moderator Group ![]() Joined: 01 December 2004 Status: Offline Points: 1297 |
![]() ![]() ![]() ![]() ![]() |
|
Freq,
1) I've created a very basic Calendar MultiSchedules sample for you, please find it there (see below for a working link). 2) Please also look at standard Calendar VB sample, hopefully it will be useful for you. -- WBR, Serge |
||
![]() |
||
migue ![]() Newbie ![]() Joined: 02 August 2006 Status: Offline Points: 3 |
![]() ![]() ![]() ![]() ![]() |
|
sserge,
I'd like to check these samples that you update but I can't download them.
Could you send me the correct links... I'm very interesting in this component and Iwant to check the simple funcionalities before buying.
Thanks,
![]() Migue
|
||
![]() |
||
sserge ![]() Moderator Group ![]() Joined: 01 December 2004 Status: Offline Points: 1297 |
![]() ![]() ![]() ![]() ![]() |
|
Hi Migue,
Full Calendar VB sample is available within the evaluation package. See below for a code of a simple multi-resources example. Add a Calendar control to the form, and add a code like:
Also below is the contents of the calendarmultipleschedulessample.xml file:
-- WBR, Serge |
||
![]() |
||
migue ![]() Newbie ![]() Joined: 02 August 2006 Status: Offline Points: 3 |
![]() ![]() ![]() ![]() ![]() |
|
Ok, thanks... I want to work with MS Access but my database has got a password ... How can I create the provider with password in your connection... I've tried with this sentence but doesn´t work:
OpenProvider "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & cadena & ";Persist Security Info=False;Jet OLEDB:Database Password=xxx"
Thanks..
Miguel
|
||
![]() |
||
PeySoft ![]() Newbie ![]() ![]() Joined: 07 August 2006 Location: South Africa Status: Offline Points: 4 |
![]() ![]() ![]() ![]() ![]() |
|
Hi there
me again
try using
CalendarControl1.SetDataProvider Application.CurrentDB
|
||
MS Access Expert
(or trying to be!) |
||
![]() |
||
PeySoft ![]() Newbie ![]() ![]() Joined: 07 August 2006 Location: South Africa Status: Offline Points: 4 |
![]() ![]() ![]() ![]() ![]() |
|
Sorry about that! Just read the whole thread. This will only work if using Access as the front end.
|
||
MS Access Expert
(or trying to be!) |
||
![]() |
||
sserge ![]() Moderator Group ![]() Joined: 01 December 2004 Status: Offline Points: 1297 |
![]() ![]() ![]() ![]() ![]() |
|
Was working for me fine, the only change is to take data source filename into single quotes: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" & App.Path & "\" & strPath & "';Persist Security Info=False;Jet OLEDB:Database Password=xxx" -- WBR, Serge |
||
![]() |
||
sserge ![]() Moderator Group ![]() Joined: 01 December 2004 Status: Offline Points: 1297 |
![]() ![]() ![]() ![]() ![]() |
|
![]() |
||
DikkeLeo ![]() Newbie ![]() Joined: 14 October 2006 Location: Netherlands Status: Offline Points: 6 |
![]() ![]() ![]() ![]() ![]() |
|
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. |
||
![]() |
||
sserge ![]() Moderator Group ![]() Joined: 01 December 2004 Status: Offline Points: 1297 |
![]() ![]() ![]() ![]() ![]() |
|
We can try to help, but there is not enough problem details described there. Try to be more specific. -- WBR, Serge |
||
![]() |
||
DikkeLeo ![]() Newbie ![]() Joined: 14 October 2006 Location: Netherlands Status: Offline Points: 6 |
![]() ![]() ![]() ![]() ![]() |
|
(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 |
||
![]() |
||
sserge ![]() Moderator Group ![]() Joined: 01 December 2004 Status: Offline Points: 1297 |
![]() ![]() ![]() ![]() ![]() |
|
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 |
||
![]() |
||
DikkeLeo ![]() Newbie ![]() Joined: 14 October 2006 Location: Netherlands Status: Offline Points: 6 |
![]() ![]() ![]() ![]() ![]() |
|
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! |
||
![]() |
||
DikkeLeo ![]() Newbie ![]() Joined: 14 October 2006 Location: Netherlands Status: Offline Points: 6 |
![]() ![]() ![]() ![]() ![]() |
|
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. |
||
![]() |
||
DikkeLeo ![]() Newbie ![]() Joined: 14 October 2006 Location: Netherlands Status: Offline Points: 6 |
![]() ![]() ![]() ![]() ![]() |
|
found it!
|
||
![]() |
||
DikkeLeo ![]() Newbie ![]() Joined: 14 October 2006 Location: Netherlands Status: Offline Points: 6 |
![]() ![]() ![]() ![]() ![]() |
|
in MakeCreateEventSQL is an error:
the line strSQL = strSQL + "ScheduleID = " & pEvent.ScheduleID & ");" & vbCrLf must be changed to: strSQL = strSQL & pEvent.ScheduleID & ");" & vbCrLf |
||
![]() |
||
sserge ![]() Moderator Group ![]() Joined: 01 December 2004 Status: Offline Points: 1297 |
![]() ![]() ![]() ![]() ![]() |
|
Ok, thanks. Will fix those 2 errors.
|
||
![]() |
||
mindserve ![]() Newbie ![]() Joined: 20 January 2007 Location: United States Status: Offline Points: 13 |
![]() ![]() ![]() ![]() ![]() |
|
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 |
||
![]() |
||
sserge ![]() Moderator Group ![]() Joined: 01 December 2004 Status: Offline Points: 1297 |
![]() ![]() ![]() ![]() ![]() |
|
Forum looks to remove old attachments... Here it is: uploads/20070121_160444_CalendarSchedul.zip -- WBR, Serge |
||
![]() |
Post Reply ![]() |
|
Tweet
|
Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |