c# - mysql foreign key mistake -


i need issue. there problem not find it

error message is

cannot add or update child row: foreign key constraint fails (db_kiosk.tbl_oyunhareketi, constraint oh_kioskid foreign key (oh_kioskid) references tbl_kiosk (kiosk_id) on delete no action on update no action)

here code c#

string sql = "insert db_kiosk.tbl_oyunhareketi (oh_oyuncuid,oh_kioskid,oh_puan,oh_tarih,oh_controlrow) values ('"+convert.toint32(label4.text)+"','"+convert.toint32(label3.text)+"','" + puan_txt.text + "' , '" + tarih_txt.text + "',1)";  label3.text = kiosk_drop.selectedvalue;  label4.text = oyuncu_drop.selectedvalue;

kiosk_drop , oyuncu_drop dropdownlist in asp.net , in selectedindexchanged function. when display labels values coming problem insertion. db attributes integer couldn't find problem.

you have foreign key constraint prevents adding rows child table before have relevant information in parent table.

in case should first populate tbl_kiosk before adding row tbl_oyunhareketi. rows matched columns oh_kioskid , kiosk_id.


-

Comments

Post a Comment

Popular posts from this blog

json - Zend error Connection -

i have problem code, first code <?php require_once('zend/json.php'); require_once('zend/db.php'); //require_once 'zend/db/adapter/pdo/pgsql.php'; class jsonvi { protected $_db; public function _koneksi () { try { $this->_db = zend_db::factory('pdo_pgsql',array( 'host'=>'localhost', 'username'=>'stet', 'password'=>'test', 'dbname'=>'test' )); return $this->_db; } catch(zend_db_exception $e) { return $e->getmessage(); } } public function getdata() { $db = $this->_koneksi(); try { $sql = "select * info "; ...
Read more

javascript - Trigger mouseenter when an animated element touches mouse -

i'm new web development , i'm building game in object avoid touching animated circles pointer. set mouseenter event (full jsfiddle below): $("#"+circlename).mouseenter(function(){ $(this).attr("class", "redcircle"); }); this turns circles red when user moves pointer them. however, when mouse stationary, circles can pass through safely. there better way this? by changing mouseenter event hover event, event triggered when animated circle touches stationary mouse. however, there seems delay. know why might be? this sounds it's related issue found here, means may have related browser bug: getting mouseenter event still mouse entering animated element fiddle: http://jsfiddle.net/nbsteuv/6yok3s56/4/ i store last mouse position , whenever circle moves, check whether has intersected mouse position. var mousex, mousey; $( "#container-element-id" ).mousemove(function( event ) { mousex = event.pagex; mouse...
Read more

ubuntu - collect2: fatal error: ld terminated with signal 9 [Killed] -

Image
i'm trying build precimonious on ubuntu 16.04.3 x64. allocated 1gb memory it. file structure looks like ~ |--- llvm/ |--- precimonious/ where llvm on version 3.0 mentioned @ https://github.com/corvette-berkeley/precimonious#requirement . followed steps on readme command make ended with ... llvm[1]: linking debug shared library libllvm-3.0.so collect2: fatal error: ld terminated signal 9 [killed] compilation terminated. ... i went through answers online , might because there's not enough memory perform link. memory usage the gcc version on machine gcc version 5.4.0 20160609 (ubuntu 5.4.0-6ubuntu1~16.04.4) , installed via apt-get install build-essential . fresh droplet created on digitalocean btw. appreciated. it memory exhaustion. sampling interval memory measurement not small enough covers exact point oom killer kicks in. depending on container/vm technology, may able set vm.overcommit_memory=2 before build, process not killed (but doing requires m...
Read more