Kevin,

Thanks for the link; I think it is going to be a big help after I get into it.

On the other issue of not getting the auto identity column updated, we did some investigating and found where you were making the ‘SQL’ call in your class. Chuck and I decided to write stored procedures and then retrieve the auto identity in the Sproc.

I wrote a VFP program that generates insert, update and delete DB2 sprocs to the clipboard and then all I have to do is send them to Chuck for him to install in the database. Then when I went to change my custom data access class to use the spocs, the .Net visual tool sees the spocs and the parameter list but does not build a column list to match to the parameters. It does not allow you to paste or write the values yourself.

So now I’m going to write another code generator to build the ado.net command code for me to paste in the custom data access class. I’ll keep you posted.

I’m trying to use custom data access classes and typed datasets with my business objects, but it is proving to be difficult with the OleDb provider and the ODBC driver layers necessary to talk to DB2.

Thanks!

Bill Williams