I haven't coded anything yet. This is happening in the IDE, using only a grid, an SQLDataSource and their smart tags.
By the way, thank you for such a quick answer. :) Mercea Paul wrote: > > Could you show the code that execute this sql query? > > >> -----Original Message----- >> From: Zento [mailto:[EMAIL PROTECTED] >> Sent: Thursday, October 02, 2008 12:02 >> To: firebird-net-provider@lists.sourceforge.net >> Subject: [Firebird-net-provider] Problems with parametrized queries (DDEX >> VS2008) >> >> >> Hello everybody. >> >> I'm trying to use Firebird as RDBMS for a new ASP.NET web project to >> test, >> as I'm totally new to this technology. I've installed Firebird 2.1.1, >> Firebird Client 2.1.0.0 and DDEX 2.0.4.0 and using SqlDataSource with >> Firebird bindings. Everything works perfectly for queries like SELECT * > FROM >> Table, but when I try to use a parametrized query with a join, > SqlDataSource >> can't retrieve schema: >> >> When using this query: >> >> SELECT UsuDisp.Dispositivos, Usu.IDUsuario, Usu.Usuario, Usu.Nombre >> FROM UsuariosDispositivos UsuDisp >> LEFT OUTER JOIN Usuarios Usu ON (Usu.IDUsuario = UsuDisp.Usuario) >> WHERE UsuDisp.Dispositivos = ? >> >> The "Test Query" button show this error: "SQLDA missing or incorrect >> version, or incorrect number/type of variables". >> >> Then tryed through Query Builder, and parameter changed: >> >> SELECT UsuDisp.Dispositivos, Usu.IDUsuario, Usu.Usuario, Usu.Nombre >> FROM UsuariosDispositivos UsuDisp LEFT OUTER JOIN >> Usuarios Usu ON Usu.IDUsuario = UsuDisp.Usuario >> WHERE (UsuDisp.Dispositivos = @Param1) >> >> "Execute Query" button worked correctly, but "Test Query" button show >> this >> error: "Must declare command parameters". Tryed also to fill SelectQuery >> property directly, adding a named and typed parameter manually, but same >> error showed again. >> >> Same query using Microsoft ODBC provider + Firebird ODBC driver worked >> correctly, but I think this is not the better way... >> >> Any thought? Thank you in advance. >> -- >> View this message in context: http://www.nabble.com/Problems-with- >> parametrized-queries-%28DDEX-VS2008%29-tp19775726p19775726.html >> Sent from the firebird-net-provider mailing list archive at Nabble.com. >> >> >> ------------------------------------------------------------------------- >> 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 > > > > ------------------------------------------------------------------------- > 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 > > -- View this message in context: http://www.nabble.com/Problems-with-parametrized-queries-%28DDEX-VS2008%29-tp19775726p19776335.html Sent from the firebird-net-provider mailing list archive at Nabble.com. ------------------------------------------------------------------------- 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
