Re: [Firebird-net-provider] Create or update a table

Hi   Your intention is to have one version database and 'syncronize' this structure to other databases?   Regards, Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ionut IchimSent: Saturday, November 04, 2006 11:47 PMTo: firebird-net-provider@lists.sourceforge.netSubjec

Re: [Firebird-net-provider] Create or update a table

Yes ... application will become complex and database structure too,if I'll update one user's application i have to update his databases structure too. Thanks !- Original Message From: paul.mercea <[EMAIL PROTECTED]>To: For users and developers of the Firebird .NET providers Sent: Sunday, No

Re: [Firebird-net-provider] Exception when running a query

Hello: > I get the following error : It's a little hard to debug this, i was doing the tests using v2.0 and getting this error: "Integer overflow. The result of an integer operation caused the most ..." That looks to be sent by the server The one you have told gives when using 1.7. I haven't

Re: [Firebird-net-provider] Attempted to read or write protected memory. This is often an indication that other memory is corrupt

I have found which is the condition for get the error. I get this error when a I put in the "where" clause a varchar value. SQL = "select CATE_ID from T_CATEGORIAS WHERE CATE_NOMBRE='@v_categoria'" .cmd.Parameters.Add("@v_categoria", FbDbType.VarChar).Value = "Cat1"While dr.Read   --- FailI

[Firebird-net-provider] FbDataAdapter problem

Regarding http://sourceforge.net/mailarchive/forum.php?thread_id=30866705&forum_id=12591   the problem is in this method:  protected override int Update(DataRow[] dataRows, DataTableMapping tableMapping)   If command is an Insert FbDataAdapter should call row.AcceptChanges()  before UpdatePa

Re: [Firebird-net-provider] Create or update a table

Hi   I use this scenario. In database I have one table for Version. I put every version in that table.If I deploy new version I have patch script (sql file with all database modifications - if u use IBExpert u can set metadatachange log file) and I run this patches.   For me works!   Regards,

[Firebird-net-provider] How to get Generator value

Hi! I want to use Generator to create global Key for all record of all table. I want to get value and Generator increase 1 at client. How to do? - Using Tomcat but need to do more? Need to support web services,

Re: [Firebird-net-provider] How to get Generator value

Hi   Current generator value is generator_value=GEN_ID(generator,0); You can increment with 1 generator value with Gen_ID(generator,1);   REgards, Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pham Huu Le Quoc PhucSent: Monday, November 06, 2006 9:42 AMTo: firebird-

Re: [Firebird-net-provider] How to get Generator value

Pham Huu Le Quoc Phuc wrote: > Hi! > > I want to use Generator to create global Key for all record of all > table. I want to get value and Generator increase 1 at client. select gen_id(generator, 1) from rdb$database; -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.c

Re: [Firebird-net-provider] How to get Generator value

If i've got what you mean, you should run this query with FbCommand.ExecuteScalar "select gen_id(my_global_generator_name,1) from rdb$database"- you will increase the generator value by 1, and get this new value at client -- View this message in context: http://www.nabble.com/How-to-get-Generat