Parameters not detected in VS2008 IDE when LEFT OUTER JOIN used ---------------------------------------------------------------
Key: DNET-180 URL: http://tracker.firebirdsql.org/browse/DNET-180 Project: .NET Data provider Issue Type: Bug Components: ASP.NET Providers, DDEX Provider Affects Versions: 2.5.0 Alpha 2, 2.1.0 Environment: Windows XP SP3 Spanish, Visual Studio 2008 SP1, Firebird Server 2.1, Firebird Client 2.5.0.0 Alpha 2, DDEX 2.0.4.0 Reporter: Zento Assignee: Jiri Cincura 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. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider