Re: [Firebird-net-provider] Problem with stored procedure in Visual Studio 2005 Pro

2006-09-17 Thread Dan Taylor
> > > > > > > > > From: Carlos Guzmán Álvarez <[EMAIL PROTECTED]> > Reply-To: "For users and developers of the Firebird .NET providers" > > To: [EMAIL PROTECTED],"For users and developers of the Fi

Re: [Firebird-net-provider] Problem with stored procedure in Visual Studio 2005 Pro

2006-09-16 Thread M xu
ot;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" To:  [EMAIL PROTECTED],"For users and developers of the Firebird .NET providers&

Re: [Firebird-net-provider] Problem with stored procedure in Visual Studio 2005 Pro

2006-09-16 Thread Carlos Guzmán Álvarez
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. Huu could you try to change the name of the p

[Firebird-net-provider] Problem with stored procedure in Visual Studio 2005 Pro

2006-09-16 Thread Dan Taylor
Hi all, I'm having problems getting a stored procedure to work in Visual Studio 2005 Pro. Have managed to get basic queries working, but no luck with a very simple stored proc... SET TERM ^ ; ALTER PROCEDURE "SurnamesContaining" ( Txt VARCHAR(100) ) RETURNS ( "NameId" INTEGER, "Name"

Re: [Firebird-net-provider] Problem with Stored Procedure

2006-07-17 Thread Christian J.
Cecil Martin wrote: >Are you committing your transaction? If you do not commit the >transaction the insert will be rolled back in the database. > > >Cecil Martin > > Hi, Yes much thanks, that was the point. My connection object had an open transaction and all changes where rolled back. Now i

Re: [Firebird-net-provider] Problem with Stored Procedure

2006-07-17 Thread Cecil Martin
Christian J. wrote: > I got it: > My mistake was, that i added the ID-Parameter as String, adding it with > "cmd.Parameters.Add("@IDSYSTEMSETTINGS", null);" > works. But there are no Changes made at the Database. The code is > executed without errors, but i don't find any new records at the DB. >

Re: [Firebird-net-provider] Problem with Stored Procedure

2006-07-17 Thread Christian J.
>> Hello: >> >> >>> FbCommand cmd = new FbCommand("SYSTEMSETTINGS_IOU1", new >>> FbConnection(c.ConnectionString)); >>> cmd.CommandType = CommandType.StoredProcedure; >>> cmd.Parameters.Add("@IDSYSTEMSETTINGS", "NULL"); >>> cmd.Parameters.Add

Re: [Firebird-net-provider] Problem with Stored Procedure

2006-07-16 Thread Christian J.
Carlos Guzmán Álvarez schrieb: > Hello: > >> FbCommand cmd = new FbCommand("SYSTEMSETTINGS_IOU1", new >> FbConnection(c.ConnectionString)); >> cmd.CommandType = CommandType.StoredProcedure; >> cmd.Parameters.Add("@IDSYSTEMSETTINGS", "NULL"); >> cm

Re: [Firebird-net-provider] Problem with Stored Procedure

2006-07-16 Thread Carlos Guzmán Álvarez
Hello: > FbCommand cmd = new FbCommand("SYSTEMSETTINGS_IOU1", new > FbConnection(c.ConnectionString)); > cmd.CommandType = CommandType.StoredProcedure; > cmd.Parameters.Add("@IDSYSTEMSETTINGS", "NULL"); > cmd.Parameters.Add("@SETTINGNAME", "anotherpa

[Firebird-net-provider] Problem with Stored Procedure

2006-07-16 Thread Borgman
Hi, I have a Problem to get the Stored Procedure Example working with VC# 2005 Express. my Code is: FbCommand cmd = new FbCommand("SYSTEMSETTINGS_IOU1", new FbConnection(c.ConnectionString)); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@I