xcroft_girl 0 Report post Posted June 9, 2005 Sayer kena develop VB 6.0 dan database mcm biasalah access. Kalau ikut pengalaman dulu, saya pakai kom Windows 98 dan bila nak link database takder masalah sbb dia pakai data control dan link ajer dgn access 97. Skrg kat opis praktikal nih dia pakai Windows XP, so kita pakai adodc kan... Jadi yang menjadi masalahnya..Blh tak sesiapa tlng bagi contoh coding save, search, delete, addnew. Bukan apa dah cuba buat, tapi ntah aper2 lah...Bosan gak bila stuck... Harap2 orang2 yang terer dalam forum ni... Bantulah hamba yang tengah BLUR nih... TQ very much... Share this post Link to post Share on other sites
Rads78 0 Report post Posted June 9, 2005 Pergh... garang betul ngko nih.... hahhahahha.. nih check kat link nih ada sample sket camner ndak set / guna / connect ODBC melalui VB6.Good luck Share this post Link to post Share on other sites
FryShadow 90 Report post Posted June 9, 2005 kotye pon nak tanye jgn r nak marah2 cik kak oi...cool kay..saya ada coding dia, tapi skang kat jb source tue kat tempat lain...nnt saya usahakan.actually rasanya lau guna adodc cam biasa dah bleh kot...guna office 2003 pon leh tapi ssh sket... cuba cari kat google.com dulu.. Share this post Link to post Share on other sites
xcroft_girl 0 Report post Posted June 13, 2005 kotye pon nak tanye jgn r nak marah2 cik kak oi...cool kay..saya ada coding dia, tapi skang kat jb source tue kat tempat lain...nnt saya usahakan.actually rasanya lau guna adodc cam biasa dah bleh kot...guna office 2003 pon leh tapi ssh sket... cuba cari kat google.com dulu..←Mana lah ada sayer nih garangayu... gitu sori yek kalau garangkalau kita pakai opis 2003 susah skit yek patutlahdia debug jer. Nak kata salah coding rasanya betul dah. Saya nih bukanlah mahir sangat, tapi bila ada kawan2 yang nak bantu...SUKANYA.... sayer... Share this post Link to post Share on other sites
hafizzd 0 Report post Posted June 13, 2005 hmm, nak update / del / insert ni kene main dengan sqlmayb bule try camniadodc.recordsource = "SQL COMMAND"adodc.Recordset.requerydalam SQL COMMAND tu letak la sql punye command insert ke update ke, delete ke...paham dok?selamat mencuba Share this post Link to post Share on other sites
xcroft_girl 0 Report post Posted June 15, 2005 hmm, nak update / del / insert ni kene main dengan sqlmayb bule try camniadodc.recordsource = "SQL COMMAND"adodc.Recordset.requerydalam SQL COMMAND tu letak la sql punye command insert ke update ke, delete ke...paham dok?selamat mencuba ←Nampaknya demo mace ore klate...utk save kita buat coding..adodc.recordset.updatemcm tu lah lebih kurang...bila nak run ok cuma tak faham kenapa tang ayat tuh jer dia debugsaya kena siapkan sblm habis praktikal nih...supervisor hanya tahu arah jertapi bila tanya dia pun tak tau... yg dia tau VB 6.0 link ngan access 97 jer...Hhehehehhehe... Share this post Link to post Share on other sites
Rads78 0 Report post Posted June 15, 2005 Aku tak pernah ler lagi update adodc guna command comtuh semua. Yg slalu aku buat execute guna adodc connection.. cthnya camnihDim cnConnect as New ADODB.ConnectionDim myID as StringmyID = "123ABC"cnConnect.Open "DSN=MyDB"cnConnect.Execute "Delete from myTable where myID='" & myID & "'"cnConnect.Execute "Insert into myTable values('myfirstfield','mysecondfield','mythirdfield')"cnConnect.Execute "Update myTable set myfirstfield='" & myID & "' where myID='123456789'"Kalau ndak amik record guna recordset Share this post Link to post Share on other sites
xcroft_girl 0 Report post Posted June 15, 2005 Aku tak pernah ler lagi update adodc guna command comtuh semua. Yg slalu aku buat execute guna adodc connection.. cthnya camnihDim cnConnect as New ADODB.ConnectionDim myID as StringmyID = "123ABC"cnConnect.Open "DSN=MyDB"cnConnect.Execute "Delete from myTable where myID='" & myID & "'"cnConnect.Execute "Insert into myTable values('myfirstfield','mysecondfield','mythirdfield')"cnConnect.Execute "Update myTable set myfirstfield='" & myID & "' where myID='123456789'"Kalau ndak amik record guna recordset←Kalau mcm tuh kita buat arahan ni dkt command button save , delete, update. so kiranya dia pakai arahan SQL lah ye... Share this post Link to post Share on other sites
Rads78 0 Report post Posted June 15, 2005 Yup.. guna arahan SQL.. letak kat button save / delete / update Share this post Link to post Share on other sites
xcroft_girl 0 Report post Posted June 16, 2005 Yup.. guna arahan SQL.. letak kat button save / delete / update←Kenapa arahan tak sama yer.saya nih tak tau nak rujuk kat saper.dan bila kita nak pakai SQL, perlu tak kita tambah component apa2 Share this post Link to post Share on other sites
hafizzd 0 Report post Posted June 16, 2005 Kenapa arahan tak sama yer.saya nih tak tau nak rujuk kat saper.dan bila kita nak pakai SQL, perlu tak kita tambah component apa2←apa kata ko try je mana2 yg ada tu, try n error la...programming ni kene la practice.. tak bole nak mengharap org ajar 100%.. Share this post Link to post Share on other sites
xcroft_girl 0 Report post Posted June 17, 2005 hai kat sini saya nak ucap thank you bebanyak dkt mhatim2 yg sudi sesangat YM ngan saya dan tolong saya buat coding. smlm memang kelakar, buat2 error eje. ada jer yg tak kena. mujurlah dekat2 dah last minute nak balik opis, dapat jugak buat coding. itu pun baru coding save. mmg benda nih simple, tapi bagi saya ianya satu pembelajaran, kita try and error.Bila dah dapat satu coding dan blh link ajer terus sayer jerit seronok. terkejut supervisor. Dan dia pun nak tau mcm mana sayer buat, sbb dia selalu kondem sayer. Takpe bila dia kondem tuh yg sayer tak malu bertanya dalam forum nih. So kalau2 ada soalan sayer nih mcm org tak reti apa2 langsung, jgn lah marah yer. Lagipun saya cuma tak tau link database ajer kan. kira oklah tuh....Lastly buat mhatim2........TQ sekalai lagi. blh lah dtg port dickson, saya belanja nasi lemak ngan tea tarik. Share this post Link to post Share on other sites
