I forgot to mention the C# line where the error raises :
FbCommand cmd = new FbCommand(queryString, _Conexion.mConexion);
// queryString has assigned the SQL Sentence
cmd.Parameters.AddWithValue("@ID_USUARIO", idUsuario);
FbDataAdapter da = new FbDataAdapter(cmd);
da.Fill(ds); <--- ERROR
Regards,
Mocte
""Mocte Sandoval"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi again,
>
> I'm trying to execute an FBSQLCommand, which includes an union clause, the
> sql runs fine from IBExpert but when I run the SQL in Visual Studio the
> provider throws the error : 335544569 (Dynamic SQL Error), I can only
> think
> that the provider doesn't have support for this kind of querys, that's not
> a
> big trouble at all, I can do a SP with the union inside which returns the
> data, but I just wanted to know what is causing this error. Below you will
> find the "problematic" sql ;-)
>
> SELECT DISTINCT CENTROS.ID_CENTRO, CENTROS.DESCRIPCION
> FROM CENTROS
> INNER JOIN USUARIO_ZONA ON (CENTROS.ID_CENTRO = USUARIO_ZONA.ID_CENTRO)
> WHERE USUARIO_ZONA.ID_USUARIO = @ID_USUARIO AND
> NOT EXISTS (
> SELECT USUARIO_ZONA.ID_USUARIO
> FROM USUARIO_ZONA
> WHERE USUARIO_ZONA.ID_CENTRO=0 AND USUARIO_ZONA.ID_USUARIO =
> @ID_USUARIO)
> UNION
> SELECT DISTINCT CENTROS.ID_CENTRO, CENTROS.DESCRIPCION
> FROM CENTROS
> INNER JOIN USUARIO_ZONA ON (CENTROS.ID_CENTRO = USUARIO_ZONA.ID_CENTRO)
> WHERE EXISTS (
> SELECT USUARIO_ZONA.ID_USUARIO
> FROM USUARIO_ZONA
> WHERE USUARIO_ZONA.ID_CENTRO=0 AND USUARIO_ZONA.ID_USUARIO =
> @ID_USUARIO)
>
> Also since the SQL is running fine outside, I don't know If I should be
> naming different each occurrence of @ID_USUARIO
>
> Thanks,
> Mocte
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Firebird-net-provider mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
