Notifying methods when some interesting table's records are change

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jpkong - 25 Jul 2008 07:18 GMT

Hi,

As far as I know, SQLCE doesn't have triggering method to itself, other
components or applications for specific table when its records are changed.

I want to get notifications from SQLCE to application when that situation.

What's the way for it in SQLCE3.1/3.5?

Thanks.

Reply to this Message

Ginny Caughey MVP - 25 Jul 2008 11:35 GMT

There are no triggers so you'd need to set up your own method for notifying
applications when you change the data.

Signature

Ginny Caughey
Device Application Development MVP

> Hi,
>
[quoted text clipped - 7 lines]
>
> Thanks.

Reply to this Message

ErikEJ - 29 Jul 2008 12:46 GMT

You can find a sample of how this can be done in code here:
http://erikej.blogspot.com/2008/04/mobile-sample-using-sql-compact.html

Signature

Erik Ejlskov Jensen, Mobile App Dev MCTS

Check out my SQL Compact blog at
http://erikej.blogspot.com

> Hi,
>
[quoted text clipped - 7 lines]
>
> Thanks.

Reply to this Message