Servoy Calendar

[tweetie]

The calendar now works....and it looks great...

But I get this error:

Switch to design mode to fix the problem in this relation(s):
Warning: Relation 'agenda_to_boekingen36' has mismatched keys
Key type from globals.user does not match with type from boekingvan

Also an error in calculation agendaboekingtm:
Exception executing agendaboekingtm: Cannot convert null to an object.


I use Servoy Developer
Version R2 2.0 rc3-build 263
Java version 1.4.2_02-b03 (Windows 2000)

and did all the steps as prescribed.....

tweetie

[Harjo]

Yes, I saw that one too!
I have fixed this and put in a next-release (this week, I hope!)

the other error: appears only in the left-corner, right?
I'll do a calculation and sometimes a value in the calculation contains null.
I can't prevent this.

[Ron]

Hi Harjo,

Downloaded your Calender solution.
Looks fine, but I find it rather slow.
Switching from 1 week view to 2 week view or monthview takes about half a minute. How long is this supposed to take?. Is there something wrong with my box?.
I know from FM Calendars that there is quite a calculation going on behind the screens, but this long....
Plse let me know.

Best Regards,

Ron

(WinXP Pro / Athlon 2200+ / FB /Servoy2RC3)

[Harjo]

No, there must be something wrong.
I have pIV 2.0 GHZ and it takes about 1 second to switch
the first time, sometimes ,takes about 3 seconds.

Did you download the latest? (the one with the error in relation 36? )
I noticed too, that sometimes when you load a solution in Developer and switch to another form, that this taking about 20 a 30 seconds!

this has nothing to do, with this solution. If you go back to one week en back to 2 weeks, is this taking so long too?

Please try it in Servoy Client too! This has much less overhead!

[Riccardino]

Please try it in Servoy Client too! This has much less overhead!

I also have several problems (I use OSX):
the agenda doesn't create all the days in the week, but only the first (monday).
If I click on the other dates, I get an dd-MMM-yyyy and, on the dayname box, an EEEE.
I tried creating appointments in the missing days, but they're not displayed.

Also, if I try to click on the appo, I get this message
"agenda_to_boekingen" is not defined.
And, when opening the solution:
ERROR IN RELATIONs
Switch to design mode to fix the problem in this relation(s):

Warning: Relation 'agenda_to_boekingen36' has mismatched keys
Key type from globals.user does not match with type from boekingvan

I hope this helps you: I'd like to test it as soon as possible :)

[Harjo]

Hi ricardino!

create first (manually) ONE record in Calendar!
than the calculation will start to work!

I will update soon, there is indeed an error in one relation!

hope this helps!

[Riccardino]

Hi ricardino!

create first (manually) ONE record in Calendar!
than the calculation will start to work!

I did it: but the problem shows up anyway :wink: [/quote]

[Harjo]

Sorry! my fault! the version here is not working properly
There will be an update soon!

[Riccardino]

Sorry! my fault! the version here is not working properly
There will be an update soon!

Thanks :)

[Harjo]

See the latest message in this topic!!
here is a new version of the Calendar Tool: 2.1

for MAC users: only copy empty.gdb to calendar.gdb
and make a standard firebird-connection, with name: Calendar
than import the solution!
The Calendar Tool now automaticly creates one user and One record in Calendar. (So you don't have to do this manually again!)

Please let me know what you think!.

[bcusick]

here is a new version of the Calendar Tool: 2.1

for MAC users: only copy empty.gdb to calendar.gdb
and make a standard firebird-connection, with name: Calendar
than import the solution!
The Calendar Tool now automaticly creates one user and One record in Calendar. (So you don't have to do this manually again!)

Please let me know what you think!.

Great! I finally got this solution to load/work! Nice looking. However, there is a big problem: you need to re-synch the sequences to the calendar.gdb file you provide. In creating a new user - the new user ID is 1, but the existing userID (the sample data) is a 2. Same with new appointments - I can't even add one in because I get a firebird ID contstraint error (i.e. it's trying to add ID = 54 and it's already there).

Nice design, though, from what I can see.

Bob Cusick

[Harjo]

HM-i that's strange!
I thougth that, if you make a new server connection to a gdb file,
and than import (only the first time) the solution, that the solution-sequences are updated!

Question to the Servoy guys: Are the sequences updated the first time?

[Harjo]

Hi, because of some troubeling in previous versions, I have made changes to the Calendar Tool.

You can download it now with sample data, so no troubles, with empty tables, etc...

Please try it now in the 2.1beta4. Johan did some tremendous changes in speeding up portals!!.

Feel free to contact me.