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
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
