OdbcCommand, MySql and auto-increment field

  • Thread starter Thread starter Ben Fidge
  • Start date Start date
B

Ben Fidge

Hi

I have a scenario where i'm writing to a MySql table using OdbcCommand and
the table has an auto-increment field that needs returning after the
"insert" statement executes.

How do I do this?

I've tried creating am Output parameter but that doesn't get populated after
the call to OdbcCommand.ExecuteNonQuery(). This may be because in my
"insert" statemement I'm using "?" to denote parameters as opposed to using
proper named parameters. I also can't seem to get these to work corretly
either.

Any help gratefully received,

Ben
 
Is it a relatively new version of MySQL? If yes, then you can use SELECT
@@IDENTITY to get the latest id field's value.

HTH
ALTAF
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OdbcCommand exception - MySQL 1
DataAdapter and inserting into a table with a AUTO Counter field? 3
Auto Increment Field or Identity Field In MS SQL Server 0
get the next auto increment 2
auto incrementing field 1
DateTime fields and DBNull.Value 1
Auto-Increment Issue (couldn't find this one) 4
Setting and Retrieving MySQL BIT(1) datatype as boolean value 2

Back
Top