Hello:
> The Installer for the provider installs the
> "FirebirdSql.VisualStudio.DataTools.dll" file with the date 2006-04-07.
What version of the provider are you using ??
The installer of the 2.0 final has that assembly with date 23/6/2006
-
> -Ursprüngliche Nachricht-
> Von: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Im Auftrag von Balla Imre
> Gesendet: Montag, 21. August 2006 09:12
> An: For users and developers of the Firebird .NET providers
> Betreff: Re: [Firebird-net-provider] DDEX sto
ders"
Sent: Sunday, August 20, 2006 11:42 AM
Subject: Re: [Firebird-net-provider] DDEX stored procedure problem
Hello:
> When trying to make a DataSet and import the stored procedure, an
> error ocuurs: <"SP_GEN_SAMPLESUMMARIES_ID"> Dynamic SQL Error:
> parameter mismat
> That's such a bad idea. Not only does max() need to scan the whole table to
> find the desired value (for each INSERT), you will also - sooner or later -
> get collisions. Never ever use such a function to create primary keys. It
> will lead to problems. Use generators - they are the only tran
Betreff: Re: [Firebird-net-provider] DDEX stored procedure problem
>
> I forgot about your second question. :-)
>
> If I don't use difficult generators, then I don't use them at all.
>
> I mean if I want to get an autoincrement number for every
> record, I persona
Hello:
> 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
I have done a test by dropping the stored procedure from the Server
Explorer inside the dataset
> I think autoincrement fields and your propusal are fine for local, single
> user databases, like a firebird embedded database.
I'm currently using that one, I should have wrote it to make it clear.
> In a multi user envirement, two users can insert the same key in the data
> set in the memory.
T
ED]>
To: "For users and developers of the Firebird .NET providers"
Sent: Friday, August 18, 2006 3:38 PM
Subject: Re: [Firebird-net-provider] DDEX stored procedure problem
>I forgot about your second question. :-)
>
> If I don't use difficult generators, then I don&#x
Only works if you have a single user DB. Much better to use a before insert trigger. Easy and quicker too.MarvOn 8/18/06, Balla Imre <
[EMAIL PROTECTED]> wrote:I forgot about your second question. :-)If I don't use difficult generators, then I don't use them at all.
I mean if I want to get an aut
NET providers"
Sent: Friday, August 18, 2006 3:24 PM
Subject: Re: [Firebird-net-provider] DDEX stored procedure problem
> Hello!
>
> I'm also new in Firebird, but here is my opinion:
> you shouldn't use "select whatever from stored procedure", because it
> is
Hello:
> 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
Could you send to my private email a test database ??
--
Best regards
Carlos Guzmán Álvarez
I forgot about your second question. :-)
If I don't use difficult generators, then I don't use them at all.
I mean if I want to get an autoincrement number for every record, I
personally prefer to use something like:
insert into table (id, field1, field2) select coalesce(max(id) + 1,
1), @field1,
Hello!
I'm also new in Firebird, but here is my opinion:
you shouldn't use "select whatever from stored procedure", because it
is behaving like a select statement. You should set up something like
this:
FbCommand command = new FbCommand("SP_GEN_SAMPLESUMMARIES_ID", connection);
command.CommandType
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 g
14 matches
Mail list logo
