1 Replies - 1572 Views - Last Post: 10 October 2012 - 11:06 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:17 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

This post has been edited by modi123_1: 10 October 2012 - 08:19 AM
Reason for edit:: highlight the text and just click the 'code' button in the text editor


Is This A Good Question/Topic? 0
  • +

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

#2 Dormilich  Icon User is offline

  • 痛覚残留
  • member icon

Reputation: 3397
  • View blog
  • Posts: 9,607
  • Joined: 08-June 10

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

Posted 10 October 2012 - 11:06 AM

are you sure that shcode is supposed to be a string type?
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1