|
Home > Archive > SQL Anywhere Mobile > August 2005 > Re: Is it possible to synchronize & insert,delete, update using the mobilink client's authentic
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 |
Re: Is it possible to synchronize & insert,delete, update using the mobilink client's authentic
|
|
|
| The environment is ASE 12.5.1
< begin_syncronization
>
setuser ?
<end event>
when tried to synchronize I get this error.
E. 08/31 09:03:55. SQLCODE from MobiLink server is: -10002
E. 08/31 09:03:55. Message: ODBC: [DataDirect][ODBC Sybase Wire Protocol
driver][SQL Server]The untyped variable ? is allowed only in in a WHERE
clause or the SET clause of an UPDATE statement or the VALUES list of an
INSERT statement
(ODBC State = HY000, Native error code = 7332). Table
Name: NULL
I. 08/31 09:03:55. The user authentication value is 0.
when I tried with the following it will not have any impact on suser_name()
I don't know if there is a setting in ASE 12.5.1 that will stop this
function to provide the login id instead of the value that was set.
The log table do have ppml_user = the value of ml_user after the completion
of synchronization.
thanks in advance.
vsv
< begin_synchronizatio
n>
declare @user_name_ppml varchar(128)
delete from ppml_debug
insert into ppml_debug(ppml_user
)
values (?)
select @user_name_ppml = ppml_user
from ppml_debug
setuser @user_name_ppml
<end event>
"Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
wrote in message news:4315d0c2$1@foru
ms-2-dub...
> Argh. The SETUSER command should allow you to do this without modifying
any
> of your triggers. Sorry for the mis-information. You should just be able
> to run the SETUSER command in the begin_synchronizatio
n event.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer Version 8
> Please reply only to the newsgroup
>
> iAnywhere Developer Community : http://www.ianywhere.com/developer
> iAnywhere Documentation :
http://www.ianywhere.com/developer/product_manuals
> ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set filter to "Display ALL platforms IN ALL MONTHS"
>
>
> "vsv" <nospam@nospam.com> wrote in message news:4315c489$1@foru
ms-1-dub...
> were
> (database
a[color=darkred]
> invitation,
<FirstName.LastName@ianywhere.com>[color=darkred]
answer[color=darkred
]
> variable
@mlu[color=darkred]
> =
> the
MobiLink),[color=dar
kred]
> in
user[color=darkred]
> as
> news:4314a8f8$1@foru
ms-1-dub...
> mobilink
client's[color=darkr
ed]
behind[color=darkred
]
> startup.
> dbmlsrv
>
>
|
|
|
|
|