VFP ·R¥ÎªÌªÀ°Ï ­º­¶ VFP ·R¥ÎªÌªÀ°Ï
¥»°Q½×°Ï¬° Visual Foxpro ·R¥ÎªÌ¸gÅç¥æ¬yªº¦a¤è, ½Ð¦h¦h§Q¥Î"·j´M"ªº¥\¯à, ¥ý¬d¬Ý¬Ý¦³µL«e¨Ò¥i´`, ¦pªGÁÙ¦³¤£À´ªº¦Aµo°Ý. ³¡¥÷¥DÃD¦³ªþ¥[ÀÉ®×, ¶·¥ýµù¥U¦¨¬°ªÀ°Ï©~¥Á¤~¥i¥H¤U¸ü.
 
 ±`¨£°ÝÃD±`¨£°ÝÃD   ·j´M·j´M   ·|­û¦Cªí·|­û¦Cªí   ·|­û¸s²Õ·|­û¸s²Õ   ·|­ûµù¥U·|­ûµù¥U 
 ­Ó¤H¸ê®Æ­Ó¤H¸ê®Æ   µn¤JÀˬd±zªº¨p¤H°T®§µn¤JÀˬd±zªº¨p¤H°T®§   µn¤Jµn¤J

¦bvs2005 express web developer sql update¦p¦ó¤Þ¤Jtextbox­È?

 
µoªí·s¥DÃD   ¦^ÂÐ¥DÃD    VFP ·R¥ÎªÌªÀ°Ï ­º­¶ -> SQL °Q½×°Ï
¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD  
µoªí¤H ¤º®e
KKKLYNN



µù¥U®É¶¡: 2004-09-17
¤å³¹: 357


²Ä 1 ¼Ó

µoªíµoªí©ó: ¬P´Á¤G ¤»¤ë 13, 2006 9:27 am    ¤å³¹¥DÃD: ¦bvs2005 express web developer sql update¦p¦ó¤Þ¤Jtextbox­È? ¤Þ¨¥¦^ÂÐ

¨Ï¥Îsqldatasourceùتºupdate,¤@ª½¬O¤£¥X¨ÓÄæ¦ì§ó·s¦r¦ê¦p¦ó¤U?

UPDATE ¹s¥ó¸ê®Æ SET ¹s¥ó¦WºÙ = '"+ me.textbox3.text +"' WHERE (¹s¥ó¥N¸¹ = 'BNH2724A65Y-')

¦p¤W¦r¦ê·|±N¤Þ¸¹¤ºªº¦r¦ê¾ã­Ó§ó·s¤Jsqldatasource
­Y¨S¦³¤Þ¸¹«h·|¥X²{¿ù»~
¦Ó§Ú«o¬O§Æ±æ¨ú±o me.textbox3.textªº­È
¥H¤W·q½Ð«ü¥¿
ÁÂÁÂ
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
summer



µù¥U®É¶¡: 2003-06-19
¤å³¹: 32


²Ä 2 ¼Ó

µoªíµoªí©ó: ¬P´Á¤­ ¤»¤ë 16, 2006 7:28 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

Try it ..
"UPDATE ¹s¥ó¸ê®Æ SET ¹s¥ó¦WºÙ = '" & me.textbox3.text & "' WHERE (¹s¥ó¥N¸¹ = 'BNH2724A65Y-')"

PS.Use in VB
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
KKKLYNN



µù¥U®É¶¡: 2004-09-17
¤å³¹: 357


²Ä 3 ¼Ó

µoªíµoªí©ó: ¬P´Á¤­ ¤»¤ë 16, 2006 10:45 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

ÁÂÁÂ!±zªº´£¥Ü!¤w®M¥Î!
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
±q¤§«eªº¤å³¹¶}©lÅã¥Ü:   
µoªí·s¥DÃD   ¦^ÂÐ¥DÃD    VFP ·R¥ÎªÌªÀ°Ï ­º­¶ -> SQL °Q½×°Ï ©Ò¦³ªº®É¶¡§¡¬° ¥x¥_®É¶¡ (GMT + 8 ¤p®É)
²Ä1­¶(¦@1­¶)

 
«e©¹:  
±z µLªk ¦b³o­Óª©­±µoªí¤å³¹
±z µLªk ¦b³o­Óª©­±¦^ÂФ峹
±z µLªk ¦b³o­Óª©­±½s¿è¤å³¹
±z µLªk ¦b³o­Óª©­±§R°£¤å³¹
±z µLªk ¦b³o­Óª©­±¶i¦æ§ë²¼
±z µLªk ¦b³o­Óª©­±ªþ¥[ÀÉ®×
±z µLªk ¦b³o­Óª©­±¤U¸üÀÉ®×


Powered by phpBB © 2001, 2005 phpBB Group
¥¿Å餤¤å»y¨t¥Ñ phpbb-tw ºûÅ@»s§@