Re: [Firebird-net-provider] Data vs. Web trunk structure

2007-05-08 Thread Jiri Cincura
Jiri Cincura wrote: > \trunk\NETProvider\source\FirebirdSql\UnitTests Sorry. UnitTests should be placed in Data. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - This SF.net email is sponsore

[Firebird-net-provider] Data vs. Web trunk structure

2007-05-08 Thread Jiri Cincura
Hi Carlos, if we're in huge changes in codebase, I think, there's some problem with *.csproj files. The FirebirdSql.Web.Providers.csproj is located on other place (level) than FirebirdSql.Data.FirebirdClient.csproj . And also some same files (with same I think with same purpose in project) are

Re: [Firebird-net-provider] Firebird Firewall Warning

2007-05-08 Thread Mercea Paul
How is your connection string? Servername:databse or serverip:database? Regards, Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Smith Sent: Tuesday, May 08, 2007 6:35 PM To: For users and developers of the Firebird .NET providers Subject: [Firebird-net-provider]

[Firebird-net-provider] Firebird Firewall Warning

2007-05-08 Thread John Smith
I was wondering why everytime I connect to a database it autmatically tries to connect to a DNS server. John Smith - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and t

Re: [Firebird-net-provider] Issue with .net provider to work with a

2007-05-08 Thread Carlos Guzmán Álvarez
Hello: > So far so good. Since I have all the dataaccess in a separate layer > (DLL) using the DDEX provider, Hope you mean the ado.net provider. > I would like to keep this in a > tableadapter. The Visual Studio wizard performs some type of query parsing that is not valid for Firebird an

Re: [Firebird-net-provider] Issue with .net provider to work with aFirebird generator

2007-05-08 Thread Kai Bohli
Hi Roman ! This worked fine agains the database, but the DDEX provider didn't like this either. That's ok, cause I'll use this code in a FBCommand instead. Thanks a lot for your reply. Best wishes [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On

Re: [Firebird-net-provider] Issue with .net provider to work with a Firebird generator

2007-05-08 Thread Mercea Paul
Hi Kai For that table u can create a trigger before insert to set your next value for generator and you don't need to pass any value for that field. After inserting data (100 rows) generator will set value for each record (especially if this field is primary key for table u need mechanism like

Re: [Firebird-net-provider] Issue with .net provider to work with aFirebird generator

2007-05-08 Thread Roman Rokytskyy
Use SELECT FIRST 1 gen_id(my_generator, 1) FROM any_non_empty_table This will return you one record. Roman Kai Bohli wrote: > Hi Rick ! > > > > Thanks a lot for your reply. > > The generator code runs fine in my old version of “Interbase Workbench”. > > I cannot create a new table in this

Re: [Firebird-net-provider] Issue with .net provider to work with a Firebird generator

2007-05-08 Thread Kai Bohli
Hi Paul. >Why you need to know generator value before insert? I actually need the generator value after insert, but read in the firebird faq that it was a lot safer to get the generator value before insert. Anyway, I need this value cause the record inserted will be often updated during an exe

Re: [Firebird-net-provider] Issue with .net provider to work with aFirebird generator

2007-05-08 Thread Kai Bohli
Hi Rick ! Thanks a lot for your reply. The generator code runs fine in my old version of "Interbase Workbench". I cannot create a new table in this database. I have to use whatever is already made in this case since I'm not in control of the database. I also have to use a generator that's al

Re: [Firebird-net-provider] Issue with .net provider to work with a Firebird generator

2007-05-08 Thread Mercea Paul
Why you need to know generator value before insert? Regards, Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kai Bohli Sent: Monday, May 07, 2007 9:17 PM To: For users and developers of the Firebird .NET providers Subject: [Firebird-net-provider] Issue with .net provide

Re: [Firebird-net-provider] Issue with .net provider to work with aFirebird generator

2007-05-08 Thread Rick Roen
Kai, I have used this type of select in VB.Net 2005 and the query analyzer does complain about the "$", however it does actually work and return the result. I think I get something about a "problem near '$'.". Have you tried to run the generator code? If it does not even compile there i