SQL Anywhere Mobile - New Problem with Upload

Author

New Problem with Upload_update

Rodrigo Defavari

2005-10-27, 8:21 am

Hello,

I need help again. I using ASA9 (in a Palm Aplication) syncronizing with
Oracle, and I have this problem:

I have one script in the event upload_insert and another one in the event
upload_update, When I insert a new row in my application in the Palm the
event upload_insert functions normally on syncronization. After I make one
update in this row and make the syncronization again, But the event
upload_update does not execute.

I am ordering below the SQL of my update:

(UPDATE wf_pre_pedido SET

LIBERADO_REPRESENTAN
TE = TO_NUMBER(1) ,
DATA_LIBERACAO = sysdate

where
(id_pedido_pda = TO_NUMBER(?)
AND PEDIDO = TO_NUMBER(?)
AND DATA = TO_DATE(?)
AND USUARIO = ?
AND TP_PRODUTO = TO_NUMBER(?)
AND DT_PEDIDO = TO_DATE(?)
AND COD_CLIENTE = TO_NUMBER(?)
AND COD_REPRES = TO_NUMBER(?)
AND NUM_PED_EMPRESA = TO_NUMBER(?)
AND NUM_PED_CLIENTE = ?
AND PRAZO_ENTR_CLIENTE = TO_DATE(?)
AND ENTREGA_PARCIAL = TO_NUMBER(?)
AND CUSTO_FINANC_NO_FAT = TO_NUMBER(?)
AND PORC_CUSTO_FINANC = TO_NUMBER(?)
AND COD_REDESPACHO = TO_NUMBER(?)
AND COD_FRETE_REDESP = TO_NUMBER(?)
AND COD_TRANSP = TO_NUMBER(?)
AND COD_FRETE = TO_NUMBER(?)
AND COD_PAGTO = TO_NUMBER(?)
AND TABELA_PRECO_VENDA = TO_NUMBER(?)
AND PORC_CUSTO_FINANC_IN
CLUSO = TO_NUMBER(?)
AND COD_CLIENTE2 = TO_NUMBER(?)
AND COD_PESSOA_ESTAB_JUR
IDICO = TO_NUMBER(?)
AND GENERO = TO_NUMBER(?)
AND APLICACAO = TO_NUMBER(?)
AND COD_CLIENTE3 = TO_NUMBER(?)
AND PORC_DESCONTO = TO_NUMBER(?)
AND COMISSAO = TO_NUMBER(?)
AND DEPARTAMENTO = ?
AND LIBERADO_REPRESENTAN
TE = TO_NUMBER(?)
AND DATA_LIBERACAO = TO_DATE(?)
AND ENVIADO = TO_NUMBER(?)
/*AND LIBERADO_REPRESENTAN
TE = 1*/
OR 1=1 )
)

in my application in palm, the field that I make update is
liberado_representan
te.
I would like to anybody discoverer what's happening.

Thanks

--

Rodrigo Defavari
Developer
AKB IT Solutions Ltda. - Tel: 19 3466-9672
rodrigo.defavari@akbit.com

Evite imprimir ! Pense em sua responsabilidade e compromisso com o MEIO
AMBIENTE.

Greg Fenton

2005-10-27, 8:21 am

Rodrigo Defavari wrote:
>
> I need help again. I using ASA9 (in a Palm Aplication) syncronizing with
> Oracle, and I have this problem:
>

Answered in the general newsgroup. Please post to one newsgroup and
allow sufficient time for a response (up to 48 hours).

BTW: This is the more appropriate group for your question.

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