|
Hi
I am using Firebird 1.5.3, FirebirdClient 2.0 for .Net Freamwork 2.0 [stable] and Visual
Studio 2005 with .NET 2.0.
All component are up and running and I can access
my firebird database.
I want to use a firebird generator for unique
primary keys. I have a stored procedure to get a generated id from my database
to fill in a field in a new row before "Updating" the new row.
CREATE PROCEDURE SP_GEN_SAMPLESUMMARIES_ID
returns ( ID bigint) as begin ID = gen_id(GEN_SAMPLESUMMARIES_ID, 1); suspend; end When trying to make a DataSet and import the
stored procedure, an error ocuurs: <"SP_GEN_SAMPLESUMMARIES_ID"> Dynamic
SQL Error: parameter mismatch for procedure
SP_GEN_SAMPLESUMMARIES_ID
When trying to make a query in a QueriesTableAdapter, the wizard shows an input and an output parameter, both named ID, and when finishing the wizard, a similar error ocurrs. Is this a general problem or a bug in the data provider for firebird? I can access the stored procedure if I use a query
with single value return an enter the SQL by myself: select * from "SP_GEN_SAMPLESUMMARIES_ID"
This query works fine in the GUI preview, but I now
have to find the way to use this query from code.
And a final question:
Is there a better way to use generators (and before
insert triggers) with Visual Studio 2005?
|
------------------------------------------------------------------------- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
