1 Replies - 651 Views - Last Post: 10 October 2012 - 08:48 AM Rate Topic: -----

#1 prabhakarsb  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 10-October 12

error in appending record from vb 2010.net4 in phpmysql

Posted 10 October 2012 - 08:44 AM

the following error code is vb 2010 with phpmysql

Column 'shcode' cannot be null

this happens for fields in the table

begining of code

Dim cb As New MySqlCommandBuilder(sharemain.daAddMem)

cb.GetInsertCommand.CommandText = ("INSERT INTO `sgtmdatawamp`.`memvbaddr` (`shcode`, `idno`, `pfolno`, `shname`, `shstreet`, `sharea`, `shcity`, `shstate`, `shjoint1`, `shjoint2`, `shjoint3`, `shitpan`, `itstatus`, `shmail`, `script`, `scriptno`, `noshare`, `remarks`, `photopath`, `scansign`) VALUES ('9068', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');")

cb.GetInsertCommand.ExecuteNonQuery()

ending of code

Is This A Good Question/Topic? 0
  • +

Replies To: error in appending record from vb 2010.net4 in phpmysql

#2 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 9574
  • View blog
  • Posts: 36,262
  • Joined: 12-June 08

Re: error in appending record from vb 2010.net4 in phpmysql

Posted 10 October 2012 - 08:48 AM

Do not create duplicate topics. Closing.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1