Hi, I was wondering if there's a way to automatically update a MYTABLERow object with an autoincremented ID field from the database on insert?
The setup is that I have a table, MYTABLE, in my firebird DB to which I connect using the generated MYTABLETableAdapter and a DataSet, MYDATASET. In MYTABLE I have a primary key column, ID, which uses a trigger and a generator to autoincrement the ID column. Since I will have multiple clients that might simultaneously insert rows in the table I can't use the AutoIncrement Property of the DataColumn. Hence I want the DB to autogenerate the ID and return that value to the MYTABLERow that is inserted. With other databases I've learned that you can check the Refresh the Datatable checkbox when configuring your table adapter but that doesn't seem to work with Firebird. Thanks Christian
------------------------------------------------------------------------------ Return on Information: Google Enterprise Search pays you back Get the facts. http://p.sf.net/sfu/google-dev2dev
_______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
