|
Home > Archive > SQL Anywhere Mobile > June 2005 > Will Trigger be fired during synchronization?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Will Trigger be fired during synchronization?
|
|
|
| 9.0.2.2451
I have a table which has a trigger upon insert and update. Will this
trigger be fired during synchronization? Thanks!
| |
| Eddy Ramos 2005-06-15, 7:24 am |
| Roy,
The upload_insert, upload_update statement based scripts will
fire the relevant triggers.
Rgards,
Edwin Ramos
Senior Technical Presales
iAnywhere Soutions UK
"Roy" <abc@abc.com> wrote in message news:42aff7c5@forums
-1-dub...
> 9.0.2.2451
>
> I have a table which has a trigger upon insert and update. Will this
> trigger be fired during synchronization? Thanks!
>
>
| |
|
| how about download_cursor?
"Eddy Ramos" <ramose@ianywhere.com> wrote in message
news:42aff99b$1@foru
ms-1-dub...
> Roy,
>
> The upload_insert, upload_update statement based scripts will
> fire the relevant triggers.
>
> Rgards,
>
> Edwin Ramos
> Senior Technical Presales
> iAnywhere Soutions UK
>
> "Roy" <abc@abc.com> wrote in message news:42aff7c5@forums
-1-dub...
>
>
| |
|
| how about download cursor?
"Eddy Ramos" <ramose@ianywhere.com> wrote in message
news:42aff99b$1@foru
ms-1-dub...
> Roy,
>
> The upload_insert, upload_update statement based scripts will
> fire the relevant triggers.
>
> Rgards,
>
> Edwin Ramos
> Senior Technical Presales
> iAnywhere Soutions UK
>
> "Roy" <abc@abc.com> wrote in message news:42aff7c5@forums
-1-dub...
>
>
| |
| Breck Carter [TeamSybase] 2005-06-15, 9:24 am |
| The MobiLink server is just another application, so triggers fire on
the consolidated normally... depending on what is uploaded (which
depends on dbmlsync).
And dbmlsync is a special animal... it may or may not upload the
database changes performed by triggers on the remote, and it may or
may not fire triggers when database changes are downloaded.
See the SendTriggers and FireTriggers extended options. Read the Help
carefully, it's a brain-twister :)
FWIW the defaults are OK most of the time.
Breck
On 15 Jun 2005 03:01:58 -0700, "Roy" <abc@abc.com> wrote:
>how about download_cursor?
>
>"Eddy Ramos" <ramose@ianywhere.com> wrote in message
> news:42aff99b$1@foru
ms-1-dub...
>
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
|
|
|
|
|