Simple isn't it ? Returning a scalar data value...

Simple isn't it ? Returning a scalar data value...

• Alex_Mann

  Thx shakalama for your're anwser.

  You're right, in fact when creating the "INSERT" command I forgot to remove the primary key from the SQL. ie : "INSERT INTO MyTable (ID, Name) VALUES ( , )" (the wizards automaticaly adds each field), I had to remove my autonumbered fields : "INSERT INTO MyTable (Name) VALUES ( )", with this the DBMS (here Access) handle the autonumbered field. Otherwise I get a "trying to assign a null value to a not variant field".

  Thx a lot.

  Thread fixed ^_^

  
  

• dcd112778

  hi,

  first of all you can make a field a primary key in your table and add make it auto generate the id itself like this

  'creating table

  Dim Tb As New DataTable("Table1")

  Tb.Columns.Add("id", GetType(Integer))

  Tb.Columns.Add("name", GetType(String))

  Tb.Columns("id").Unique = True

  Tb.PrimaryKey = New DataColumn() {Tb.Columns("id")}

  With Tb.Columns("id")

  .AutoIncrement = True

  .AutoIncrementSeed = 1

  End With

  Second if your Msaccess table auto generate the id by itself you simply use SQLStr = "Insert into mytble(........." without adding the id value it will be genereated in access table even you don't have to use executescalar

  hope it helps

   

  
  
  

• RayHerring

  Hi, SuperPoney

  you are welcome

  Best Regards

  
  
  
• Simple isn't it ? Returning a scalar data value...