Calendar apps don't show existing records

Scriptcase 8 Discussion
#1

We have a calendar app in a client project which was working really well. But recently it has stopped showing the existing table records. You can add a new record via the calendar but they effectively “disappear”. You can see them in the table and on the other forms, but not on the calendar, which always appears empty. I’ve taken the WHERE clause off the SQL but even with no WHERE clause it is still empty. It kind of looks like it’s in data entry only mode but not sure how that could happen with a calendar?

Anyone had this happen and do you have any suggestions?

Thanks, Jeff

#2

I should mention that I tried creating a brand new calendar app on the same table, but it was just the same.

#3

could you please share with me the configuration page of your calendar app?..

#4

Hi kafecadm

Thanks - here’s a screenshot of the calendar page and one of the sql page.

[ATTACH=CONFIG]n69425[/ATTACH]

cal_config.png

cal_sql.png

#5

can you please show me how your calendar is displayed?.

regards

#6

Thanks Kafecadm

I think I found the problem. There were some records in the table with an empty appointment description field. That seemed to cause the problem. I filled those in and everything appeared. Seems like a bit of a bug as I don’t think a couple of empty descriptions should cause the whole calendar to empty!
:smiley:

I appreciate you trying to help on this.

Best regards

Jeff