Worked out what my problem was. I needed to insert an '@' symbol at the start of the parameter name using the object properties pane. I still don't understand why the data preview worked but the code itself didn't!
Have documented the problem/solution here if anyone's interested... http://logicalgenetics.com/forums/viewtopic.php?p=6883 Cheers, Dan On 17/09/06, M xu <[EMAIL PROTECTED]> wrote: > > > > Hi All, > > I am using firebird data provider version 1.7 for .NET 1.1. When creating > a table, I got the following message: > > "No message for error code 335544351 found" > > "No message for error code 335544382 found" > > How could I display more detailed message like "unsuccessful mata data > update...", for error code? > > Thanks, > > Minquan > > > > > > > > ________________________________ > > From: Carlos Guzmán Álvarez <[EMAIL PROTECTED]> > Reply-To: "For users and developers of the Firebird .NET providers" > <[email protected]> > To: [EMAIL PROTECTED],"For users and developers of the Firebird .NET > providers" <[email protected]> > Subject: Re: [Firebird-net-provider] Problem with stored procedure in > Visual Studio 2005 Pro > Date: Sat, 16 Sep 2006 23:01:54 +0200 > > >Hello: > > > --- > > > namesDataset.SurnamesDataTable ndt = new > namesDataset.SurnamesDataTable(); > > > surnamesTableAdapter.FillBySurnameContaining(ndt, > "TAY"); > > > --- > > > > > > ...it throws a firebird -206 dynamic SQL exception claiming that > > > column TXT is unknown. > >Huummmm could you try to change the name of the parameter to @TXT > > > > > >-- > >Carlos Guzmán Álvarez > >Vigo-Spain > > > >------------------------------------------------------------------------- > >Using Tomcat but need to do more? Need to support web services, security? > >Get stuff done quickly with pre-integrated technology to make your job > easier > >Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > >http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > >_______________________________________________ > >Firebird-net-provider mailing list > >[email protected] > >https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job > easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > > _______________________________________________ > Firebird-net-provider mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > -- Dan Taylor BSc MIET Software Development Engineer PhD Student, Heriot Watt University, UK http://www.logicalgenetics.com ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
