SQL Anywhere Mobile - upload order

Author

upload order

Eric Verhorstert

2005-06-24, 9:24 am

ASA 9.02.3131

Is there a way to find out in which order the scripts are processed.

On some tables we get the message "No primary key value for foreign key".

I think this could be because:

1) I did not include the table in which the primary key exists. But the
table is in the article list under publications so should be synchronized.

2) there is no insert script for this table. But there is an upload
insert script.

3) There is something wrong with the foreign keys so that mobilink does
not now the order. But if I get this message it seems to mee the foreign
key relationship is ok.

Thanks
Eric

Eric Verhorstert

2005-06-24, 9:24 am

If found the tor option which is normally not used. However when I use
this everything works fine.

So I probably need to know how Mobilink decides in which way to upload
the data.

Eric Verhorstert wrote:
> ASA 9.02.3131
>
> Is there a way to find out in which order the scripts are processed.
>
> On some tables we get the message "No primary key value for foreign key".
>
> I think this could be because:
>
> 1) I did not include the table in which the primary key exists. But the
> table is in the article list under publications so should be synchronized.
>
> 2) there is no insert script for this table. But there is an upload
> insert script.
>
> 3) There is something wrong with the foreign keys so that mobilink does
> not now the order. But if I get this message it seems to mee the foreign
> key relationship is ok.
>
> Thanks
> Eric

Greg Fenton

2005-06-24, 11:25 am

Eric Verhorstert wrote:
>
> So I probably need to know how Mobilink decides in which way to upload
> the data.
>

dbmlsync (or UltraLite) determine the order of uploads based on the
declared referential integrity (i.e. foreign keys) of the *remote*
database schema.

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links