|
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 |
kalok
µù¥U®É¶¡: 2010-08-26 ¤å³¹: 284
²Ä 1 ¼Ó
|
µ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? |
|
¦^³»ºÝ |
|
|
aizz
µù¥U®É¶¡: 2007-01-29 ¤å³¹: 171
²Ä 2 ¼Ó
|
µ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Ó |
|
¦^³»ºÝ |
|
|
green
µù¥U®É¶¡: 2003-09-19 ¤å³¹: 136
²Ä 3 ¼Ó
|
µ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§¹¦¨ |
|
¦^³»ºÝ |
|
|
kalok
µù¥U®É¶¡: 2010-08-26 ¤å³¹: 284
²Ä 4 ¼Ó
|
µ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¤@Ó? |
|
¦^³»ºÝ |
|
|
aizz
µù¥U®É¶¡: 2007-01-29 ¤å³¹: 171
²Ä 5 ¼Ó
|
µ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, ÅÎÅΤӶ§, ¬Ý¬Ý¤ñ°ò¥§.......... |
|
¦^³»ºÝ |
|
|
LiuRambo
µù¥U®É¶¡: 2007-11-27 ¤å³¹: 481
²Ä 6 ¼Ó
|
µ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§¹¥þ¤£¤@¼Ëªº |
|
¦^³»ºÝ |
|
|
kalok
µù¥U®É¶¡: 2010-08-26 ¤å³¹: 284
²Ä 7 ¼Ó
|
µ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»á³Â·Ð. |
|
¦^³»ºÝ |
|
|
LiuRambo
µù¥U®É¶¡: 2007-11-27 ¤å³¹: 481
²Ä 8 ¼Ó
|
µ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 |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4212 ¨Ó¦Û: Taipei,Taiwan
²Ä 9 ¼Ó
|
µ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¦£ |
|
¦^³»ºÝ |
|
|
kalok
µù¥U®É¶¡: 2010-08-26 ¤å³¹: 284
²Ä 10 ¼Ó
|
µoªí©ó: ¬P´Á¤T ¤G¤ë 16, 2011 10:43 pm ¤å³¹¥DÃD: |
|
|
>¥Î¦bsql ¤W´N¥i¥H¤@Óconnection Åý¼ÆÓ¸ê®Æ®w¶i¤Jtransaction.
¤£¤Ó©ú¥Õ |
|
¦^³»ºÝ |
|
|
LiuRambo
µù¥U®É¶¡: 2007-11-27 ¤å³¹: 481
²Ä 11 ¼Ó
|
µ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ª¦¤å³¹ |
|
¦^³»ºÝ |
|
|
kalok
µù¥U®É¶¡: 2010-08-26 ¤å³¹: 284
²Ä 12 ¼Ó
|
µ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" |
|
¦^³»ºÝ |
|
|
pilipala
µù¥U®É¶¡: 2009-05-13 ¤å³¹: 75
²Ä 13 ¼Ó
|
µ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
|
|
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4212 ¨Ó¦Û: Taipei,Taiwan
²Ä 14 ¼Ó
|
µ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¦£ |
|
¦^³»ºÝ |
|
|
kalok
µù¥U®É¶¡: 2010-08-26 ¤å³¹: 284
²Ä 15 ¼Ó
|
µoªí©ó: ¬P´Á¥| ¤G¤ë 17, 2011 11:51 am ¤å³¹¥DÃD: |
|
|
¨S¦³»~¾É¤H, 4 ¼Ó¤w»¡©ú, ¤Ïı±o§A¼g±o¤£¤Ó²M·¡ |
|
¦^³»ºÝ |
|
|
|
|
±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§@
|