| Author |
delet mobilink client in consolidated database
|
|
| Eric Verhorstert 2005-07-29, 9:24 am |
| ASA 9
How do I delete a mobilink client in the consolidated database?
I use the script below to test if the user of our program is a mobilink
client:
SELECT count(*)
INTO ..
FROM ml_subscription
WHERE user_id = :UserOfOurProgram;
Should I use:
SELECT ml_subscription
WHERE user_id = :UserOfOurProgram;
| |
| David Fishburn 2005-07-29, 1:24 pm |
| Eric Verhorstert <ontsnapt@hotmail.com> wrote in news:42ea4418$1@foru
ms-
2-dub
of sybase.public.sqlanywhere.mobilink:
EV> ASA 9
Please provide dbeng9 -v output.
EV> How do I delete a mobilink client in the consolidated database?
First let's ask why you want to do this?
Is there some problem you are addressing?
EV> I use the script below to test if the user of our program is a
mobilink
EV> client:
EV>
EV> SELECT count(*)
EV> INTO ..
EV> FROM ml_subscription
EV> WHERE user_id = :UserOfOurProgram;
EV>
EV> Should I use:
EV>
EV> SELECT ml_subscription
EV> WHERE user_id = :UserOfOurProgram;
A user can show up multiple times in the ml_subscription table. Simply
checking ml_user should be sufficient.
Technicall you should use dbmluser -d UserOfOurProgram to remove the
user from the ML system tables.
But you could remove the removes yourself via SQL, but you have to make
sure you manage all the FK relationships between the tables.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
| |
| Eric Verhorstert 2005-08-01, 3:25 am |
|
We don't have any problems.
We test if a user is working with terminal server or with mobilink
(about 25 will use terminal server and 50 will use mobilink). When the
user is in the ml_subscription (or better ml_user) we know he is using
mobilink and disable some menu-items (mostly the input of data) when is
logged in with terminal server. This is to done prevent data changes in
the consolidated database other then by synchronization.
If a user switches from mobilink to terminal server we want to delete
the ml_user and ml_subscription data to be sure there is no
synchonization possible anymore.
So, deleting ml_subscrion and ml_user should be sufficiant?
DELETE ml_user FROM WHERE user_id = :userOfOurProgram;
DELETE ml_subscription FROM WHERE user_id = :userOfOurProgram;
Or will this give problems?
Thanks
Eric
David Fishburn wrote:
> Eric Verhorstert <ontsnapt@hotmail.com> wrote in news:42ea4418$1@foru
ms-
> 2-dub
> of sybase.public.sqlanywhere.mobilink:
>
> EV> ASA 9
> Please provide dbeng9 -v output.
>
> EV> How do I delete a mobilink client in the consolidated database?
>
> First let's ask why you want to do this?
> Is there some problem you are addressing?
>
> EV> I use the script below to test if the user of our program is a
> mobilink
> EV> client:
> EV>
> EV> SELECT count(*)
> EV> INTO ..
> EV> FROM ml_subscription
> EV> WHERE user_id = :UserOfOurProgram;
> EV>
> EV> Should I use:
> EV>
> EV> SELECT ml_subscription
> EV> WHERE user_id = :UserOfOurProgram;
>
> A user can show up multiple times in the ml_subscription table. Simply
> checking ml_user should be sufficient.
> Technicall you should use dbmluser -d UserOfOurProgram to remove the
> user from the ML system tables.
> But you could remove the removes yourself via SQL, but you have to make
> sure you manage all the FK relationships between the tables.
>
| |
| David Fishburn 2005-08-17, 1:24 pm |
| Eric Verhorstert <ontsnapt@hotmail.com> wrote in news:42edd562@forums
-1-
dub
of sybase.public.sqlanywhere.mobilink:
EV> We test if a user is working with terminal server or with mobilink
EV> (about 25 will use terminal server and 50 will use mobilink). When
the
EV> user is in the ml_subscription (or better ml_user) we know he is
using
EV> mobilink and disable some menu-items (mostly the input of data) when
is
EV> logged in with terminal server. This is to done prevent data changes
in
EV> the consolidated database other then by synchronization.
EV>
EV> If a user switches from mobilink to terminal server we want to delete
EV> the ml_user and ml_subscription data to be sure there is no
EV> synchonization possible anymore.
EV>
EV> So, deleting ml_subscrion and ml_user should be sufficiant?
EV>
EV> DELETE ml_user FROM WHERE user_id = :userOfOurProgram;
EV> DELETE ml_subscription FROM WHERE user_id = :userOfOurProgram;
Is this a permenant switch?
Or will you end up re-activating this remote?
If you do, what process do you follow?
Do you drop the sync subscription at the remote when you drop these
items above?
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
|
|
|
|