Hans
2006-02-06T13:16:00Z
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
Administrator
2006-02-06T14:03:00Z
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
Hans
2006-02-06T15:19:00Z
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
Administrator
2006-02-06T18:39:00Z
Thanks for the tip, we will try to implement this in future versions.
Administrator
2006-06-08T01:17:00Z
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