Re: Update sintaxis
In English please because the SQL is not understandable. For example there is
no FROM clause in an UPDATE statement and #2 has unbalanced quotes so I'm not
sure what you are trying to paste together (unless the unbalanced quotes ARE
the problem!).
Art S. Kagel
----- Original Message -----
From: Mesa Ayuda <mayuda@sunrise-it.com.ar>
At: 2/26 15:32
> Hi,
>
> Can you tell me what is the problem with these statements ?
>
> 1)
> Update SDR_Clientes SET Rec_Asociado = 'S'
> From SDR_TMP_Asociar
> Where Rec_Number = Tmp_Number and (link fields)
> Tmp_Numero <> p_NumeroViejo (variable)>
> 2)
> LET v_CadenaAux = "Select Act_Actividad From SDR_Actividad Where
> SDR_Field1 In (" || v_Cadena || ") || ";";
> EXEC SQL prepare Seleccion from v_CadenaAux;
> EXEC SQL execute Seleccion;
>
> Thanks,
>
> David