Servoy Calendar

Share business templates, ideas, experiences, etc with fellow Servoy developers here

Postby tweetie » Mon Feb 09, 2004 8:05 pm

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
User avatar
tweetie
 
Posts: 345
Joined: Thu Jan 08, 2004 11:32 am
Location: Rotterdam, Netherlands

Postby Harjo » Mon Feb 09, 2004 9:01 pm

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.
User avatar
Harjo
 
Posts: 4273
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Postby Ron » Tue Feb 10, 2004 12:22 am

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)
Ron
 
Posts: 315
Joined: Fri May 23, 2003 12:30 am
Location: Netherlands

Postby Harjo » Tue Feb 10, 2004 12:25 am

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? :o )
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!
User avatar
Harjo
 
Posts: 4273
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Postby Riccardino » Fri Feb 13, 2004 4:21 pm

HJK wrote:
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 :)
User avatar
Riccardino
 
Posts: 911
Joined: Thu Apr 24, 2003 11:42 am
Location: Ferrara, Italy

Postby Harjo » Mon Feb 16, 2004 6:48 pm

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!
User avatar
Harjo
 
Posts: 4273
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Postby Riccardino » Tue Feb 17, 2004 12:59 am

HJK wrote: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]
User avatar
Riccardino
 
Posts: 911
Joined: Thu Apr 24, 2003 11:42 am
Location: Ferrara, Italy

Postby Harjo » Tue Feb 17, 2004 9:27 am

Sorry! my fault! the version here is not working properly
There will be an update soon!
User avatar
Harjo
 
Posts: 4273
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Postby Riccardino » Tue Feb 17, 2004 9:59 am

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

Thanks :)
User avatar
Riccardino
 
Posts: 911
Joined: Thu Apr 24, 2003 11:42 am
Location: Ferrara, Italy

Postby Harjo » Tue Feb 17, 2004 11:05 am

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!.
Last edited by Harjo on Mon Jul 19, 2004 12:27 am, edited 1 time in total.
User avatar
Harjo
 
Posts: 4273
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Postby bcusick » Thu Mar 04, 2004 11:29 am

HJK wrote: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
bcusick
 
Posts: 1190
Joined: Wed Apr 23, 2003 11:27 pm
Location: Thousand Oaks, CA USA

Postby Harjo » Thu Mar 04, 2004 12:55 pm

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?
User avatar
Harjo
 
Posts: 4273
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Postby Harjo » Mon Jul 19, 2004 12:26 am

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.
User avatar
Harjo
 
Posts: 4273
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Previous

Return to Sharing Central

Who is online

Users browsing this forum: No registered users and 1 guest