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

¥ÎSPT °µtransaction §ó·s¨â­Ódatabase°ÝÃD
«e©¹­¶­± 1, 2  ¤U¤@­¶
 
µoªí·s¥DÃD   ¦^ÂÐ¥DÃD    VFP ·R¥ÎªÌªÀ°Ï ­º­¶ -> VFP °Q½×°Ï
¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD  
µoªí¤H ¤º®e
kalok



µù¥U®É¶¡: 2010-08-26
¤å³¹: 284


²Ä 1 ¼Ó

µoªíµoªí©ó: ¬P´Á¤é ¤G¤ë 13, 2011 7:16 am    ¤å³¹¥DÃD: ¥ÎSPT °µtransaction §ó·s¨â­Ódatabase°ÝÃD ¤Þ¨¥¦^ÂÐ

¤p§Ì¥Îspt §ó·s¨â­Ódatabase ¤¤ªº¤@¨Çtable , ¦P®É¨Ï¥ÎSQLSETPROP(conn,"Transactions",2) ¨Ó°µ transaction³]©w, °ÝÃD¬O·í§Ú­Ì¨Ï¥Îsqlstringconnect «Ø¥ß³s½u®É, ¦ü¥G¥u¯à³s±µ¤@­Ódatabase, ¦]¦¹¨Ï¥Îspt¤Îtransaction ¨Ó§ó·s¨â­Ó database¤¤ªºtable ®É, «K¥X²{°ÝÃD(§ä¤£¨ì¥t¤@­Ódatabase), ½Ð°Ý¦³µL¸Ñ¨M¤èªk?
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
aizz



µù¥U®É¶¡: 2007-01-29
¤å³¹: 171


²Ä 2 ¼Ó

µoªíµoªí©ó: ¬P´Á¤@ ¤G¤ë 14, 2011 8:49 am    ¤å³¹¥DÃD: Re: ¥ÎSPT °µtransaction §ó·s¨â­Ódatabase°ÝÃD ¤Þ¨¥¦^ÂÐ

kalok ¼g¨ì:
.......... °ÝÃD¬O·í§Ú­Ì¨Ï¥Îsqlstringconnect «Ø¥ß³s½u®É, ¦ü¥G¥u¯à³s±µ¤@­Ódatabase, ..........?


¤£¹ï, ¥i¥H¦P®É¦n´X­Ó Razz
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
green



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


²Ä 3 ¼Ó

µoªíµoªí©ó: ¬P´Á¤@ ¤G¤ë 14, 2011 9:34 am    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

table_source ¥i¸ó¸ê®Æ®w
¨Ò¦p:¦³¨â­Ó¸ê®Æ®w database1¤Îdatabase2
select * from database1.[dbo].table1
select * from database2.[dbo].table1
¥i¥H¦P¤@­Óconnection§¹¦¨
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
kalok



µù¥U®É¶¡: 2010-08-26
¤å³¹: 284


²Ä 4 ¼Ó

µoªíµoªí©ó: ¬P´Á¤@ ¤G¤ë 14, 2011 11:09 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

¨Ò¦p, §Úªº sqlstringconnect¦p¤U:

conn=sqlstringconnect('driver=Microsoft Visual FoxPro Driver;SourceDB=c:\data\transaction.dbc;SourceType=DBC;Exclusive=No;Collate=Machine;Deleted=Yes;NULL=NO;BACKGROUNDFETCH=NO')

¥¦¥u³s±µ¤@­Ó¦b c:\data\transaction ªºdatabase, ½Ð°Ý¦p¦ó¥O¥¦³s±µ¦h¤@­Ó?
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
aizz



µù¥U®É¶¡: 2007-01-29
¤å³¹: 171


²Ä 5 ¼Ó

µoªíµoªí©ó: ¬P´Á¤G ¤G¤ë 15, 2011 1:39 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

kalok ¼g¨ì:
¨Ò¦p, §Úªº sqlstringconnect¦p¤U:

conn=sqlstringconnect('driver=Microsoft Visual FoxPro Driver;SourceDB=c:\data\transaction.dbc;SourceType=DBC;Exclusive=No;Collate=Machine;Deleted=Yes;NULL=NO;BACKGROUNDFETCH=NO')

¥¦¥u³s±µ¤@­Ó¦b c:\data\transaction ªºdatabase, ½Ð°Ý¦p¦ó¥O¥¦³s±µ¦h¤@­Ó?


(1) ¦P¤@°¦µ{¦¡¤º, ©p³ßÅw²£¥Í´X­Ó, ´N¥i¥HºÉ¶q¥h²£¥Í´X­Ó---¦³¨Ç DB ¹w³]¬°MaxConnection=100, ¤£¹L, ­×§ïÅܤj´N¨S¨Æ¤F....
(2) ¤@­ÓConnection, ·íµM¥u¯àÁp±µ¤@­Ó DB

©p¤@ª½¦b (2) ùØ­±Â¶°é¤l¥´Âà

ÁÙ¤£¦p¸ò§Ú¨ÓªøÅu®q, ÅÎÅΤӶ§, ¬Ý¬Ý¤ñ°ò¥§..........
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
LiuRambo



µù¥U®É¶¡: 2007-11-27
¤å³¹: 481


²Ä 6 ¼Ó

µoªíµoªí©ó: ¬P´Á¤G ¤G¤ë 15, 2011 3:03 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

¦P¤W

SQLSETPROP(conn1,"Transactions",2)
SQLSETPROP(conn2,"Transactions",2)
SQLSETPROP(conn3,"Transactions",2)
³o¤£´N¦³¤T­ÓDATEBASE¸ê®Æ³s±µ¶Ü

"DATEBASE"¸ò"TABLE" ¬O§¹¥þ¤£¤@¼Ëªº
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ MSN Messenger
kalok



µù¥U®É¶¡: 2010-08-26
¤å³¹: 284


²Ä 7 ¼Ó

µoªíµoªí©ó: ¬P´Á¤T ¤G¤ë 16, 2011 1:12 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

LiuRambo ¼g¨ì:

SQLSETPROP(conn1,"Transactions",2)
SQLSETPROP(conn2,"Transactions",2)
SQLSETPROP(conn3,"Transactions",2)
³o¤£´N¦³¤T­ÓDATEBASE¸ê®Æ³s±µ¶Ü


§A©ú¥Õ§Úªº°ÝÃD©Ò¦b, ¸Ñ¨M¤F, ¦ý¨C¦¸°õ¦æsqlexec(ConnectionHandle, sqlcommand) ®É, ³£­n¨Ï¥Î¤£¦PªºconnectionHandle ¨Ó§ó·s¤£¦Pªºdatabase, ³oÂI»á³Â·Ð.
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
LiuRambo



µù¥U®É¶¡: 2007-11-27
¤å³¹: 481


²Ä 8 ¼Ó

µoªíµoªí©ó: ¬P´Á¤T ¤G¤ë 16, 2011 1:58 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

kalok ¼g¨ì:
LiuRambo ¼g¨ì:

SQLSETPROP(conn1,"Transactions",2)
SQLSETPROP(conn2,"Transactions",2)
SQLSETPROP(conn3,"Transactions",2)
³o¤£´N¦³¤T­ÓDATEBASE¸ê®Æ³s±µ¶Ü


§A©ú¥Õ§Úªº°ÝÃD©Ò¦b, ¸Ñ¨M¤F, ¦ý¨C¦¸°õ¦æsqlexec(ConnectionHandle, sqlcommand) ®É, ³£­n¨Ï¥Î¤£¦PªºconnectionHandle ¨Ó§ó·s¤£¦Pªºdatabase, ³oÂI»á³Â·Ð.


§AÀ³¸Ó¥ý½T»{¦n §A©Ò­n³s±µªº¨ì©³¬O¤£¬O¦b¦P¤@­ÓDB¤º
¦pªG¬O ¤j¥i¤£¥Î¦h¶}CONNECT
SPT¦h¶}´X­Ó«K¥i
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ MSN Messenger
syntech



µù¥U®É¶¡: 2003-05-16
¤å³¹: 4211
¨Ó¦Û: Taipei,Taiwan

²Ä 9 ¼Ó

µoªíµoªí©ó: ¬P´Á¤T ¤G¤ë 16, 2011 4:51 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

¥Î¦b odbc ³svfp dbc,¦ÛµM¤@­Óconnection ¥u¯à³s±µ¤@­Ódatabase.
¥Î¦bsql ¤W´N¥i¥H¤@­Óconnection Åý¼Æ­Ó¸ê®Æ®w¶i¤Jtransaction.


"SQLSETPROP(conn,"Transactions",2) " ·|Åý§O¤H»{¬°³s±µsql server®Éªº¤â°Êtransaction³B²z,
©Ò¥H»~¾É§O¤H¤£¤Ó¦n.





¦Ü©ó§A¬°¦ó¤£·Qª½±µ¶}dbc,¦Ó©ä­ÓÅs¥Îodbc¥h¶}dbc,
¦Ñ¹ê»¡,§Ú¤£·Qª¾¹D­ì¦]

_________________
¦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¦£
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ µo°e¹q¤l¶l¥ó AIM Address
kalok



µù¥U®É¶¡: 2010-08-26
¤å³¹: 284


²Ä 10 ¼Ó

µoªíµoªí©ó: ¬P´Á¤T ¤G¤ë 16, 2011 10:43 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

>¥Î¦bsql ¤W´N¥i¥H¤@­Óconnection Åý¼Æ­Ó¸ê®Æ®w¶i¤Jtransaction.

¤£¤Ó©ú¥Õ
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
LiuRambo



µù¥U®É¶¡: 2007-11-27
¤å³¹: 481


²Ä 11 ¼Ó

µoªíµoªí©ó: ¬P´Á¤T ¤G¤ë 16, 2011 11:31 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

kalok ¼g¨ì:
>¥Î¦bsql ¤W´N¥i¥H¤@­Óconnection Åý¼Æ­Ó¸ê®Æ®w¶i¤Jtransaction.

¤£¤Ó©ú¥Õ


¦ó¿×DATEBASE? ¦ó¿×TABLE? ¤°»ò¬OSQLSTRINGCONNECT?
»°§Ö¥hª¦¤å³¹
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ MSN Messenger
kalok



µù¥U®É¶¡: 2010-08-26
¤å³¹: 284


²Ä 12 ¼Ó

µoªíµoªí©ó: ¬P´Á¥| ¤G¤ë 17, 2011 9:45 am    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

¤w¥Î SPT¦h¦~¤F, ¤£¥Îª¦³o¨Ç§a, ¥u¬O¤H»P¤H¤§¶¡·¾³q¤Ó¦h»~¸Ñ.

¨Ï¥Î¨â­Ó¤£¦Pªºdatabase, ¦Ó·í¤¤ªºtable ¤S¤¬¬Û§@¥Îªº¸Ü, °ÝÃD¤£¤Ö, ¨Ò¦p¤U¦C sql »y¥y¤¤, transaction ©M product ¨â­Ótable ¤ÀÄݩ󤣦Pªº database, ¨Ï¥Î sqlexec(ConnectionHandle, sqlcommand) ®É«K¦³°ÝÃD

sqlcommand="select a.*, b.name from transaction a, product b " + " where a.productCode=b.productCode"
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
pilipala



µù¥U®É¶¡: 2009-05-13
¤å³¹: 75


²Ä 13 ¼Ó

µoªíµoªí©ó: ¬P´Á¥| ¤G¤ë 17, 2011 10:41 am    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

µ¹¥¦§¹¾ãªº¦WºÙ¡A´N¥i¥H¦b¤@±øConnection¤¤¡A¸óDB¬d¸ß¸ê®Æ

¥N½X:

TEXT TO cSQLCommand TEXTMERGE NOSHOW PRETEXT 2
 SELECT a.*, b.name
 FROM DB1.dbo.transaction AS a , DB2.dbo.product AS b
 WHERE a.productCode=b.productCode
ENDTEXT
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
syntech



µù¥U®É¶¡: 2003-05-16
¤å³¹: 4211
¨Ó¦Û: Taipei,Taiwan

²Ä 14 ¼Ó

µoªíµoªí©ó: ¬P´Á¥| ¤G¤ë 17, 2011 11:32 am    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

13 ¼Óºô¤ÍÄ~Äò¨ü¤H»~¾É¤¤..........¡@¡@¡@¡@XD
_________________
¦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¦£
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ µo°e¹q¤l¶l¥ó AIM Address
kalok



µù¥U®É¶¡: 2010-08-26
¤å³¹: 284


²Ä 15 ¼Ó

µoªíµoªí©ó: ¬P´Á¥| ¤G¤ë 17, 2011 11:51 am    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

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

 
«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§@