|
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 |
¦¶¨|¿³
µù¥U®É¶¡: 2003-08-25 ¤å³¹: 661 ¨Ó¦Û: ¥x¤¤¥«¤j¨½°Ï
²Ä 1 ¼Ó
|
µoªí©ó: ¬P´Á¤» ¤Q¤G¤ë 29, 2007 3:24 pm ¤å³¹¥DÃD: [°Q½×] Â^¨ú ODBC ¸ê®Æ¨Ó·½¦WºÙ¤Î¨äÅX°Êµ{¦¡»¡©ú²M³æ |
|
|
¥Ñ©ó§Ú¤½¥q·Ç³Æ±N DBF Âà¨ì SQL Server (Á`ºân§Ë¥X SQL ª©¤F)¡AÁöµM¼g VFP ¤w 8 ¦~¥b¤F¡A©l²×¨S¾÷·|¸I DBC¡A©Ò¥H³o¤è±ªº¸gÅç
¬O¤@°¦¤jµæ³¾¡A§ó´q½× SQL Server ¤F¡C
º¥ýn±N DBF ¸ê®Æ¤W²¾¨ì SQL Server¡AÁöµM VFP ¦³ [¤W²¾ SQL Server] ºëÆF¥i¥Î¡A¦ý«È¤á¹M§G¥þ¬Ù¦U¦a¡A§Ú·QY¥Î¥¦°µ¸ê®Æ¤W²¾¡A
·Q·QÁ`¬O©Ç©Çªº (¦b«È¤á¨ºùØ Step By Step ¡H¦Ó¥B¤@¦¸¤@ºØ DBC ¤W²¾¡A·Q·Q´Nn³Û¤Ñ°Ú¡I)¡A¦]¬°§Ú·Q¥Ñµ{¦¡¦Û°Ê±±¨î¡A¾ã§å¤@¦¸Âà
´«§¹²¦¡CÁöµM¦¹ºëÆF¥i¥Î DO ... WITH ...¡A¥¦´£¨Ñ¤F 9 Ó°Ñ¼Æ (¥¦À³¸Ó¦³´£¨Ñ«Dµøı¤Æ°õ¦æ¥\¯à¤~¹ï)¡A¦ý¥´¶}¨ä Source¡A¯uªº¬O
¬Ý¤Ñ®Ñ (À³¸Ó¬O¨S@¤ß¬Ý§a)¡A§ä¤£¨ì¸Ó 9 ӰѼƪº¸Ô²Ó¨Ï¥Î»¡©ú¡CY¦³¤Hª¾¹D¸Ó 9 ӰѼƦp¦ó¨Ï¥Î½Ð¤£§[§iª¾¡A³o¼Ë´N¥i¥H¬Ù¤F³o
ӨơA¦b¦¹¥ý¸ò±z»¡Án·PÁ¡C
¤U±³oÓ¦Û©w¨ç¼Æ¬O¥Ñ [¤W²¾ SQL Server] ºëÆFªº Source ¤¤Â^¨ú§ï¼g¥X¨Óªº (¤]°Ñ¦Ò¤F·L³n½u¤W´£¨Ñªº½d¨Ò)¡A¼g§¹«á¤£¬O§Ú·Qnªº
¨ºÓ¡A¤£¹L¬JµM¼g¤F¡A¤]ı±o¥¦À³¸Ó¦³¦a¤è¥i¥H¥Î§a (¦pªG¦U¦ì¦³¥Î±o¤W¡A¯à¤£¯à§iª¾§Ú¥Î¦b¦ó³B¡AÅý§Ú¯à¦h¤F¸Ñ)¡A¨ä¤¤
SQLDataSources ªº°Ñ¼Æ»¡©ú¡A¬O®Ú¾Ú¨ä¨Ï¥Îµ²ªG¡A¦Û¤v¥[¤Wªº»¡©ú¦Ó¤w¡AY¦³¤£¹ï¤]·Ð½Ð§iª¾§Ú¡C
µ{¦¡½X¤Î°õ¦æ½d¨Ò¦p¤U¡G
¥N½X: | CLEAR
DIMENSION M_aODBCDataSource(1,2)
=F1_GetODBCDataSourceList("M_aODBCDataSource")
FOR W1_SUB_A = 1 TO ALEN(M_aODBCDataSource,1)
? "DSN = "+M_aODBCDataSource(W1_SUB_A,1)
? "»¡©ú = "+M_aODBCDataSource(W1_SUB_A,2)
?
ENDFOR
FUNCTION F1_GetODBCDataSourceList(L_cArrayName AS String)
* ¥\¯à¡GÂ^¨ú ODBC ¸ê®Æ¨Ó·½¦WºÙ¤Î¨äÅX°Êµ{¦¡»¡©ú²M³æ
* -------------------------------------------------------------------------- *
* °Ñ¼Æ¦WºÙ «¬ºA »¡©ú
* -------------- ---- ------------------------------------------------------
* Input:
* L_cArrayName C 1.°}¦C¦WºÙ¡C¥Nªín±µ¦¬ DSN ¸ê°Tªº°}¦C¦WºÙ¡C
* 2.¦¹°}¦CÅܼƻݨƫe«Å§i¡C
* 3.¥»¨ç¼Æ°õ¦æ§¹²¦«á·|±N¸ê®Æ¨Ó·½¦WºÙ¤Î¨äÅX°Êµ{¦¡»¡©ú²M³æ
* ¦s¤J L_cArrayName ©Ò¥Nªíªº n ¡Ñ 2 °}¦C¤¤¡C
* -------------------------------------------------------------------------- *
LOCAL W1_nODBCEnv AS Number, W1_iDSNMax AS Integer, W1_iDSNLength AS Integer, W1_iDSNDescMax AS Integer,;
W1_iDSNDescLength AS Integer, W1_iFetchDirection AS Integer, W1_iReturnValue AS Integer,;
W1_cDataSourceName AS String, W1_cDSNDescription AS String, W1_iArrayDim AS Integer, W1_cArrayDim AS String
L_cArrayName = ALLTRIM(L_cArrayName)
#DEFINE SQL_FETCH_FIRST 2
#DEFINE SQL_FETCH_NEXT 1
#DEFINE SQL_SUCCESS 0
#DEFINE MAX_STRING 128
DECLARE INTEGER SQLDataSources IN ODBC32.DLL ;
INTEGER henv, ; && ODBC Àô¹Ò±±¨î¥N½X (¥Ñ VAL(SYS(3053)) ¨ú±o)
SHORT fdirection, ; && ±q¥Ø«e©Ò¦b°O¿ý¦V¤U§ì¨ú²Ä´XÓ¸ê®Æ¨Ó·½ªº¸ê°T
STRING @szDSN, ; && ¸ê®Æ¨Ó·½ªº¦WºÙ
INTEGER cbDSNMax, ; && ³]©w§ì¨ú [¸ê®Æ¨Ó·½¦WºÙ] ¦r¦êªº³Ì¤j¦r¤¸¼Æ
INTEGER @pcbDSN, ; && §ì¨ú«á¤§ [¸ê®Æ¨Ó·½¦WºÙ] ¦r¦êªº¹ê»ÚÁ`ªø«×
STRING @szDescription, ; && »P¸Ó¸ê®Æ¨Ó·½¬ÛÃöªºÅX°Êµ{¦¡»¡©ú
INTEGER cbDescriptionMax, ; && ³]©w§ì¨ú [ÅX°Êµ{¦¡»¡©ú] ¦r¦êªº³Ì¤j¦r¤¸¼Æ
INTEGER @pcbDescriptionn && §ì¨ú«á¤§ [ÅX°Êµ{¦¡»¡©ú] ¦r¦êªº¹ê»ÚÁ`ªø«×
W1_nODBCEnv = VAL(SYS(3053))
W1_iFetchDirection = SQL_FETCH_FIRST && ²Ä¤@µ§ªº¸ê®Æ¨Ó·½¬OªÅ¥Õ¡A©Ò¥H±q²Ä 2 µ§¶}©l§ì¨ú
W1_iDSNMax = MAX_STRING
W1_iDSNLength = 0
W1_iDSNDescMax = MAX_STRING
W1_iDSNDescLength = 0
DIMENSION &L_cArrayName.(1,2)
STORE "" TO (L_cArrayName+"(1,1)")
STORE "µL¥ô¦ó ODBC ¸ê®Æ¨Ó·½" TO (L_cArrayName+"(1,2)")
W1_iArrayDim = 1
W1_iReturnValue = SQL_SUCCESS && ±q¨S¦³¿ù»~¶}©l
DO WHILE (W1_iReturnValue = SQL_SUCCESS)
W1_cDataSourceName = SPACE(MAX_STRING+1) && ½T»{¦³¨¬°÷ªºªÅ¶¡
W1_cDSNDescription = SPACE(MAX_STRING+1)
W1_iReturnValue = SQLDataSources(W1_nODBCEnv, W1_iFetchDirection, @W1_cDataSourceName, W1_iDSNMax, ;
@W1_iDSNLength, @W1_cDSNDescription, W1_iDSNDescMax, @W1_iDSNDescLength)
W1_iFetchDirection = SQL_FETCH_NEXT && ¤U¤@¦¸n§ì¨úªº¦ì¸m
IF W1_iReturnValue = SQL_SUCCESS THEN && ¦pªG¨S¦³¿ù»~µo¥Í
W1_iArrayDim = W1_iArrayDim + 1
W1_cArrayDim = LTRIM(STR(W1_iArrayDim))
DIMENSION &L_cArrayName.(W1_iArrayDim,2)
STORE LEFT(W1_cDataSourceName, W1_iDSNLength) TO (L_cArrayName+"("+W1_cArrayDim+",1)")
STORE LEFT(W1_cDSNDescription, W1_iDSNDescLength) TO (L_cArrayName+"("+W1_cArrayDim+",2)")
ENDIF
ENDDO
IF W1_iArrayDim > 1
STORE "©|¥¼«ü©w ODBC ¸ê®Æ¨Ó·½" TO (L_cArrayName+"(1,2)")
ENDIF
CLEAR DLLS "SQLDataSources"
RETURN .T.
|
_________________ §Æ±æ¦³§ó¦h¤H¨Ó°Ñ»P
VFP wiki - »Ýn¤j®a¤@°_§¹¦¨ªºVFP¹q¤l®Ñ»PFAQ |
|
¦^³»ºÝ |
|
|
garfield Site Admin
µù¥U®É¶¡: 2003-01-30 ¤å³¹: 2157
²Ä 2 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤Q¤G¤ë 31, 2007 11:20 am ¤å³¹¥DÃD: |
|
|
§Úªº°µªk¬O¼g¤@Óµ{¦¡¨Ó°µ¸ê®Æ¤W²¾,
¬yµ{¦p¤U:
1.¥ý¦b¤½¥q«Ø¥ß¤@ÓªÅSQL Serverªº DataBase
2.DataBase ¤W²¾¨ì«È¤áªº sql Server ,
µ{¦¡½X½Ð°Ñ¦Ò: http://vfp.sunyear.com.tw/viewtopic.php?t=1778
3.¦b«È¤áºÝ¥ÎSPT ©Î¬O¥Î¨Æ¥ý«Ø¥ß¦nªºRemoteView ¨Ó°µ«È¤á¸ê®Æ¤W²¾.
¦ý¦]«È¤á SQL Serverªº¹q¸£¦WºÙµLªk©T©w, ©Ò¥Hn°µ°ÊºAªº×¥¿ ODBC ³s±µ¦r¦ê, ¦pnn×¥¿VFP DATABASE¸Ìªºconnectstring (RemoteView¥Îªº), °Ñ¾\ http://vfp.sunyear.com.tw/viewtopic.php?t=1028 _________________ §Q¥Î>>·j´M<<ªº¥\¯à·|¤ñ°ÝªºÁÙn§Ö±o¨ìµª®×. |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4212 ¨Ó¦Û: Taipei,Taiwan
²Ä 3 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤Q¤G¤ë 31, 2007 2:02 pm ¤å³¹¥DÃD: |
|
|
garfield ¥Sªº°µªk»P§Úªº¬Û¦P.
§Úı±o³o¼Ë¤ñ¸û²³æ. _________________ ¦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¦£ |
|
¦^³»ºÝ |
|
|
¦¶¨|¿³
µù¥U®É¶¡: 2003-08-25 ¤å³¹: 661 ¨Ó¦Û: ¥x¤¤¥«¤j¨½°Ï
²Ä 4 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤Q¤G¤ë 31, 2007 3:00 pm ¤å³¹¥DÃD: |
|
|
§Ú¨S¿ìªk¥ý¦b¤½¥q«Ø¥ß¤@ÓªÅSQL Serverªº DataBase¡A¦]¬°§Úªº«È¤á¨ì©³¨Ï¥Î¤F¦h¤ÖÓ¨t²Î¡A¥B¥¦¨ì©³¦³´X®a¤À¤½¥q¡A¦³¨Ç Table ¬O«ö¦~ÀÉ¥ý³v¦~¤À³Îªº¡C³o³£³y¦¨¨Sªk¥ý«Ø¥ßªÅSQL Serverªº DataBase¡A¥²¶·¦b«È¤á²{¦³ª¬ªp¤U§Y®É³B²z¡C
ì«h¤W§ÚÀ³¸Ó¦³ÀYºü¤F¡A§Ú·Q§Ú¶°¤¤¦b [¬õª°½×¾Â] ¨Ó²Î¤@°Q½×¡C _________________ §Æ±æ¦³§ó¦h¤H¨Ó°Ñ»P
VFP wiki - »Ýn¤j®a¤@°_§¹¦¨ªºVFP¹q¤l®Ñ»PFAQ |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4212 ¨Ó¦Û: Taipei,Taiwan
²Ä 5 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤Q¤G¤ë 31, 2007 4:20 pm ¤å³¹¥DÃD: |
|
|
·íµM¤]¥i¥H¥ÑDBF structure ²£¥Í create table ªº©R¥O,
°t¦Xspt ¤]¥i¥HÂà. _________________ ¦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¦£ |
|
¦^³»ºÝ |
|
|
saint
µù¥U®É¶¡: 2003-07-14 ¤å³¹: 211
²Ä 6 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤Q¤G¤ë 31, 2007 11:39 pm ¤å³¹¥DÃD: |
|
|
¥i¬O§ÚÁÙ¬O¤£¸Ñ§A¤£¯à¥ý«Ø¥ßªÅªºDATABSE ¬O¤°»ò·N«ä¡A¦pªG¥Ñ§A̤½¥q©Ò½æ¥X¥hªº¡AÃø¹D·|¤£ª¾¹Dµ²ºc¡H©Ò¥H³o©M§Ú¦b¬õª°©Ò¦^ÂЪº¬O¤@¼Ëªº¡A¨S¿ù¡I§A¬O¤£ª¾¹D«È¤á¥Î¤F¦h¤Ö¨t²Î¡A¦ý¬O²z½×¤W§AÌÁÙ¬O·|ª¾¹D²{³õªº±¡§Î¡A´Nºâ¬O«ö¦~¤ÀªºÀɮסA§A¤£¤]¬O¥i¥H¨ì²{³õ«á¡A¥Ñ§A̪º¤¶±¨Ó¨M©wn¦p¦ó·h¸ê®Æ¡C§Ú»¡³o¤@¬q¬O¥i¥H¤£¥Î¼g¦º¡A¦Ó¦b SERVERºÝ«Ø¥ß¸ê®Æªí¡A³o¤@¬q¥i¥H§Q¥ÎSCRIPT ¨Ó§¹¦¨¡A³o¤@ÂIÀ³¸Ó¬O¨S¦³°ÝÃDªº¡A§Úªº«ÂI¬O¡A¹ï©ó¸ê®Æ¤W¶Çªº³o¤@Ӱʧ@¡A¤]³\¥i¥H¤£¥Î¼gªº¨º»ò¦n¡A¥i¥H¯d¤@ÂIªÅ¶¡¥[¤J¤â°Êªº³]©w¡A¦A¥Ñµ{¦¡¨Ó§¹¦¨¥¦¡C |
|
¦^³»ºÝ |
|
|
|
|
±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§@
|