search

FirebirdSQL / NETProvider

Firebird ADO.NET Data Provider
https://www.firebirdsql.org/en/net-provider/
Other
152 stars 63 forks source link

Parameters not detected in VS2008 IDE when LEFT OUTER JOIN used [DNET180] #190

Closed firebird-automations closed 15 years ago

firebird-automations commented 15 years ago

Submitted by: Zento (zento)

Using this query in the VS2008 IDE with Firebird Client 2.1.0.0 or Firebird Client 2.5.0.0:

SELECT UsuDisp.Dispositivo, Usu.IDUsuario, Usu.Usuario, Usu.Nombre FROM UsuariosDispositivos UsuDisp LEFT OUTER JOIN Usuarios Usu ON Usu.IDUsuario = UsuDisp.Usuario WHERE (UsuDisp.Dispositivo = @Param1)

Resulting in this .aspx code:

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
    ConnectionString="<%$ ConnectionStrings:AT3W %\>"
    ProviderName="<%$ ConnectionStrings:AT3W\.ProviderName %\>" SelectCommand="SELECT UsuDisp\.Dispositivo, Usu\.IDUsuario, Usu\.Usuario, Usu\.Nombre

FROM UsuariosDispositivos UsuDisp LEFT OUTER JOIN Usuarios Usu ON Usu.IDUsuario = UsuDisp.Usuario WHERE (UsuDisp.Dispositivo = @Param1)"> <SelectParameters> <asp:Parameter DefaultValue="2" Name="Param1" /> </SelectParameters> </asp:SqlDataSource>

The "Refresh Schema" link from smart tag shows a "Must declare command parameters" error.

firebird-automations commented 15 years ago
Modified by: @cincuranet status: Open \[ 1 \] =\> In Progress \[ 3 \]
firebird-automations commented 15 years ago
Modified by: @cincuranet Component: Provider \[ 10041 \] Component: Providers \[ 10090 \] =\> Component: DDEX Provider \[ 10042 \] =\>
firebird-automations commented 15 years ago

Commented by: @cincuranet

http://social.msdn.microsoft.com/forums/en-US/adodotnetdataproviders/thread/ae87febc-2c5f-4ece-8be6-b3a1496dd9c4/

firebird-automations commented 15 years ago
Modified by: @cincuranet status: In Progress \[ 3 \] =\> Resolved \[ 5 \] resolution: Won't Fix \[ 2 \]