 |
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¸ü.
|
¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD |
µoªí¤H |
¤º®e |
KKKLYNN
µù¥U®É¶¡: 2004-09-17 ¤å³¹: 357
²Ä 1 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤Q¤G¤ë 11, 2006 12:02 pm ¤å³¹¥DÃD: ½Ð°Ý³z¹LSPT INSERT ¤@µ§¸ê®ÆµLªk¦¨¥\(¶Ç¦^-1)? |
|
|
¦U¦ì¥ý¶i¦n
¥Ø«e¤w¥i×¥¿¸ê®Æ
±N¼Ò¦¡§ï¤@¤U,¨Ó¸Õ¸Õ·s¼W,«o¥¢±Ñ,½ÐÀ°§Ú¬Ý¬Ý
lnHandle=SQLConnect("lynsql","test","test")
lnReturn=SQLExec(lnHandle,"insert into items(suup_code,total_price) values('ABC',168)")
¥H¤WÁÂÁÂ |
|
¦^³»ºÝ |
|
 |
saint
µù¥U®É¶¡: 2003-07-14 ¤å³¹: 211
²Ä 2 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤Q¤G¤ë 11, 2006 12:22 pm ¤å³¹¥DÃD: |
|
|
¥i¥H§â¨ºÓ insert into ªº¦r¦ê..¦s¤U¨Ó..¦A¥h sql server ¤W¸Õ¸Õ´Nª¾¹D§A¨ºùؤU¿ù¤F..§Ú·Q¦³¥i¯à¬OÄæ¦ì«¬ºAªº°ÝÃD!¤W¦^¤£¬O¦³¤¶²Ð§A¥Î aerror() ¨ÓÀˬd¥X¤F¤°»ò¿ù¶Ü?aerror ¬O¤£¦n¥Î?ÁÙ¬O¤£·|¥Î?¦pªG¤£·|¥Î..¨º§A¼g SPT ´N«Ü¦YÁ« |
|
¦^³»ºÝ |
|
 |
KKKLYNN
µù¥U®É¶¡: 2004-09-17 ¤å³¹: 357
²Ä 3 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤Q¤G¤ë 11, 2006 2:15 pm ¤å³¹¥DÃD: |
|
|
»¡¯uÁÙ¯u·d¤£²MAERROR¥Îªk
lnHandle=SQLConnect("lynsql","test","test")
lnReturn=SQLExec(lnHandle,"insert into items(item_num,order_num,prod_num,supp_code,quantity,total_price) values(0,0,0,'ABC',0,168)")
Do Case
Case lnReturn=1 &&¹B¦æ¦¨¥\
Thisform.grid1.ColumnCount=2
Thisform.grid1.column1.Width=100
Thisform.grid1.column2.Width=90
Thisform.grid1.column1.header1.Caption='¹s¥ó¥N¸¹'
Thisform.grid1.column2.header1.Caption='³æ»ù'
Select CursorEmp
Thisform.grid1.RecordSource='CursorEmp'
Thisform.grid1.column1.ControlSource='CursorEmp.supp_code'
Thisform.grid1.column2.ControlSource='CursorEmp.total_price'
Thisform.grid1.Refresh
³s½uA=1
Case lnReturn=-1 &&¹B¦æ¦¨¥\
Messagebox("³s±µ¼h SQL SERVER¥¢±Ñ",1,"BUFFER")
Case lnReturn=-2 &&¹B¦æ¦¨¥\
Messagebox("³s±µÀô¹Ò SQL SERVER¥¢±Ñ",1,"BUFFER")
ENDCASE
ON ERROR DO errhand && errhand ¬O¿ù»~³B²zµ{§Ç
errhand.PRG
Aerror(aErrorArray) && ³Ìªñµo¥Í¿ù»~ªº¼Æ¾Ú
? '¿ù»~´£¨Ñ¤F¥H¤U«H®§' && Åã¥Ü«H®§
For N = 1 To 7 && Åã¥Ü¼Æ²Õªº©Ò¦³¤¸¯À
? aErrorArray(N)
Endfor
±Ninsert into items(item_num,order_num,prod_num,supp_code,quantity,total_price) values(0,0,0,'ABC',0,168)
¥á¨ìSQL½T¾É¦V ORDER ¦Ó¤£¬O ITEMS
§Ú¦Aª¦¤å¬Ý¬Ý
ÁÂÁÂ |
|
¦^³»ºÝ |
|
 |
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4249 ¨Ó¦Û: Taipei,Taiwan
²Ä 4 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤Q¤G¤ë 11, 2006 2:47 pm ¤å³¹¥DÃD: |
|
|
DATABASE À³¸Ó¤£¹ï§a,
§A½T©w§A¬O¹ï¸ê®Æ®wMASTER ¼g¤J¶Ü? ¤£¬O§A¦Û¤vªº¸ê®Æ®w¶Ü? _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
 |
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4249 ¨Ó¦Û: Taipei,Taiwan
²Ä 5 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤Q¤G¤ë 11, 2006 2:49 pm ¤å³¹¥DÃD: |
|
|
¦Ó¥BÁÙ¦³ foreign key ½Ä¬ð?
¯u©_©Ç. _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
 |
KKKLYNN
µù¥U®É¶¡: 2004-09-17 ¤å³¹: 357
²Ä 6 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤Q¤G¤ë 11, 2006 2:55 pm ¤å³¹¥DÃD: |
|
|
¬O¹ïmaster¸ê®Æ®w¨S¿ùªº
¦]¬°§Ú¬O±N×§ïµ{§Ç,½Æ»s¹L¨Ó(×¥¿µ{§Ç¬Ook)
¤W±±Ôz¬OÂà¦Ü table "order" ¦Ó¤£¬O items
§Ú¦b¸Õ¸Õ,ÁÂÁÂ |
|
¦^³»ºÝ |
|
 |
KKKLYNN
µù¥U®É¶¡: 2004-09-17 ¤å³¹: 357
²Ä 7 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤Q¤G¤ë 11, 2006 4:13 pm ¤å³¹¥DÃD: |
|
|
½Ð°Ý¬O§_¦³Ãö |
|
¦^³»ºÝ |
|
 |
KKKLYNN
µù¥U®É¶¡: 2004-09-17 ¤å³¹: 357
²Ä 8 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤Q¤G¤ë 12, 2006 5:01 pm ¤å³¹¥DÃD: |
|
|
¤w¸g¥i¥H·s¼W
ì¨Óitem_num»Porder_numªº¸ê®Æ¤£¥i¦P®É«½Æ©ó¸ê®Æªí®æ¤ºªº¸ê®Æ
¦ý¦p¦ó©ó¸ê®Æªíµ²ºc©Îþ¸Ì¥i¹î¬Ý±ø¥ó¨î,¤£²M·¡!
·q½Ð¨ó§U
ÁÂÁÂ |
|
¦^³»ºÝ |
|
 |
REEDWU
µù¥U®É¶¡: 2006-12-14 ¤å³¹: 2
²Ä 9 ¼Ó
|
µoªí©ó: ¬P´Á¥| ¤Q¤G¤ë 14, 2006 10:33 am ¤å³¹¥DÃD: |
|
|
§Ú¤]µo¥Í¹L¦¹¿ù»~¡A¦ýÀ³¸Ó¬Oitem_num,order_numªºÃþ«¬¬Oint¤Þ°_ªº§a¡C¥t¡A¦³°ÝÃD¨D±Ð¡A²{¦b¥u¬O´¡¤J¤@±ø°O¿ý¡A¦pªGn±N¤@±iªí°l¥[¶i¥h¡A¦p¦ó°µ©O¡H |
|
¦^³»ºÝ |
|
 |
REEDWU
µù¥U®É¶¡: 2006-12-14 ¤å³¹: 2
²Ä 10 ¼Ó
|
µoªí©ó: ¬P´Á¤T ¤Q¤G¤ë 20, 2006 3:43 pm ¤å³¹¥DÃD: |
|
|
·j¨ì¤@条¥N码¡A¦@¨É
use ORDER
Scan
lnReturn=SQLEXEC(gnConnHandle,"Insert Into [ORDER DETAILS] (QUANTITY,DISCOUNT,PRODUCTID,UNITPRICE) values (?ORDERDETAILS.QUANTITY,?ORDERDETAILS.DISCOUNT,?ORDERDETAILS.PRODUCTID,?ORDERDETAILS.UNITPRICE)" )
EndScan |
|
¦^³»ºÝ |
|
 |
|
|
±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§@
|