SQL Anywhere Mobile - Adding a column

Author

Adding a column

Peter Stojkovic

2005-04-15, 7:24 am

I get an error-message, when I try to add a column on a table,

that is used also by mobilink.

But the target was, that this new column is created automatically on all
other remotes.
But only the column, no data should be transferred.

What i have to do ??

Thanks
Peter

Greg Fenton

2005-04-15, 8:24 pm

Peter Stojkovic wrote:
> I get an error-message, when I try to add a column on a table,
> that is used also by mobilink.
>

Please, always post the version and build number of ASA/ML that you are
using (e.g. use the command "dbeng9 -v" for ASA 9.x)

I assume you are seeing this error when trying to modify a table in a
*remote* database when that table is part of a *publication*. Is this
correct?

If so, in the ASA 9.x online docs see:

MobiLink Administration Guide
Synchronization Techniques
Schema changes in remote databases

Also, for ASA remotes, see the " sp_hook_dbmlsync_sch
ema_upgrade" stored
procedure documentation (new in 9.0.0).

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