Problem with the calendar application

Applications Calendar
#1

Although I have built a calendar application, which is exactly the tutorial, this does not work. When creating an appointment, although this is created in the table but not shown in the calendar. Does anyone have a similar problem, or even a solution?

#2

Re: Problem with the calendar application

Which browser do you use ?
Try to clean the cache from your browser, cookies, history.

#3

Re: Problem with the calendar application

I deleted the Browserhistory, cookies and all other local Browseritems, but the calendarapp is not running correctly, It saves new Items but it displays no Items…

#4

Re: Problem with the calendar application

Oh sorry, I forgot: Mozilla Firefox actual Version, I try IE7, IE8. All Browsers have the same Problem

#5

Re: Problem with the calendar application

Which database do you use ? Did you check in your database if the register exist ?

#6

Re: Problem with the calendar application

This is the code from the example of the tutorial.

CREATE TABLE calendario (
chave int(11) NOT NULL default ‘0’,
titulo varchar(50) default NULL,
descricao text,
inicio datetime default NULL,
final_data date default NULL,
final_hora time default NULL,
recorrencia char(1) default NULL,
periodo char(1) default NULL,
PRIMARY KEY (chave)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

If you use this and SC5.2 it will create
a messy form, that does not work if you fill it out
compleately. It´s easy to tweak and to get it to work - but
a baaad example is this throuh and through

Use english also in your examplecode or even try to use englich like i do

another bad example, cause i did not correct the language
thats what my code looks rigt now:

CREATE TABLE IF NOT EXISTS calendario (
chave int(11) NOT NULL AUTO_INCREMENT,
titulo varchar(50) DEFAULT NULL,
descricao date DEFAULT NULL,
inicio time DEFAULT NULL,
final_data date DEFAULT NULL,
final_hora time DEFAULT NULL,
recorrencia char(1) DEFAULT NULL,
periodo char(1) DEFAULT NULL,
PRIMARY KEY (chave)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=345634586 ;

chears

#7

Re: Problem with the calendar application

MySQL 5 or Access2007 via ODBC

This is the DDL for the Table
CREATE TABLE sds.calendar.t_items (
id bigint(10) unsigned NOT NULL AUTO_INCREMENT,
title varchar(50) NOT NULL,
descript text,
date_begin datetime DEFAULT NULL,
date_end date DEFAULT NULL,
period char(1) DEFAULT NULL,
recorr char(1) DEFAULT NULL,
series_id bigint(30) unsigned DEFAULT NULL,
calendar_id bigint(30) unsigned DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

The INSERT INTO Statement works correct and stored the Dataset in the table. But it is not diplaed in the Calendarview of SC.

Latest Research Results:
I have a Where clause in the SQL Statement:
calendar_id = 0
or Calendar_id = [calendar_id]
or calendar_id = [defaultcalendar_id]

I wish it to display the default calendar, and the user calendars.
It always provides a blank calendar.
Now I have deleted the WHERE CLAUSE.
The calendar now shows all messages.
After I installed the Where Clause again, the calendar all the entries again.
Now I had a new appointment. default for the calendar.
Now appear Wieers no dates. Even if the WHERE clause is deleted, the obese empty calendar.

I’m going crazy. The beast is not easy to grasp