In my database one calendar-item needs more than one table.
So for loading calendar-items, I can use a view.
But: my database doesn't support triggers for views (to update the multiple underlying tables as suggested in this forum) (Sybase Adaptie Server Anywhere 9)

What can I do to store the calendar-items? Any suggestions?

Hans

If you database doesn't support instead of triggers on VIEWS, you can :
1.Create a dummy table
2.Triggers on dummy table to insert/update data in the real tables
3.Triggers on the real tables inserting/updating data in dummy table

or

1.Create a Dummy Table
2.Write some scheduled Stored Procedure to sync the data between Dummy and the real tables

Thanx for the quick answer.

I allready was afraid that's the only solution (a lot of triggers with the risk of running "out of sync").
We allready have programmed synchronizing with Exchange via Exchange "sync-events". This gives us troubles when running "out of sync" when for some reason an event is missed/failed. So we want to minimize real-time triggering and administering of all changes...

Actually, I'm looking for a tool which supports configurable "storing" of outlook items into a database.
So, for the direction Outlook --> database, one should be able to do a call to a stored procedure or sql-script or whatever... Not only direct on one table/view

Maybe a suggestion?
This shouldn't be too dificult to implement in this product?

Hans

Thanks for the tip, we will try to implement this in future versions.

Hi,

we have implemented custom SQL Commands for insert,update and delete. (button "Options.." in Assign Table Dialog)
see 3.0.0.8:
http://www.geniusconnect...niusconnect_download.asp