# error in appending record from vb 2010.net4 in phpmysql

Page 1 of 1

## 1 Replies - 2688 Views - Last Post: 10 October 2012 - 11:06 AMRate Topic: //<![CDATA[ rating = new ipb.rating( 'topic_rate_', { url: 'http://www.dreamincode.net/forums/index.php?app=forums&module=ajax&section=topics&do=rateTopic&t=295068&amp;s=a15c15b68979f7161e7090d0145e1a5f&md5check=' + ipb.vars['secure_hash'], cur_rating: 0, rated: 0, allow_rate: 0, multi_rate: 1, show_rate_text: true } ); //]]>

### #1 prabhakarsb

Reputation: 0
• 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

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

• 痛覚残留

Reputation: 3936
• Posts: 11,965
• 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?