µoªí¤H |
¤º®e |
¥DÃD: ºµºµ§Ñ°O«ç»òª½±µ±q Oracle §â¸ê®Æ³z¹LODBC ¸ü¨ìVFP |
whh
¦^ÂÐ: 1
Æ[¬Ý: 2791
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤@ ¤C¤ë 13, 2015 11:50 am ¥DÃD: Re: ºµºµ§Ñ°O«ç»òª½±µ±q Oracle §â¸ê®Æ³z¹LODBC ¸ü¨ìVFP |
Help §ä¨ì¤F
SQLEXEC |
¥DÃD: ºµºµ§Ñ°O«ç»òª½±µ±q Oracle §â¸ê®Æ³z¹LODBC ¸ü¨ìVFP |
whh
¦^ÂÐ: 1
Æ[¬Ý: 2791
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤@ ¤C¤ë 13, 2015 11:45 am ¥DÃD: ºµºµ§Ñ°O«ç»òª½±µ±q Oracle §â¸ê®Æ³z¹LODBC ¸ü¨ìVFP |
CLOSE ALL
C_TABLE = "Table¦WºÙ"
C_CONN_Oracle = "Driver={Microsoft ODBC for Oracle};ConnectString=±b±K¡B¸ê®Æ®w..."
H_CONN_Oracle = SQLSTRINGCONNECT(C_CONN_Oracle ... |
¥DÃD: ¤º«Ø¨ç¼Æ¡G¾ã¦C½Æ»s¡B¶K¤W¡A§Ñ°O¨ç¼Æ¦WºÙ¨D±Ï.... |
whh
¦^ÂÐ: 3
Æ[¬Ý: 3925
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤@ ¥|¤ë 13, 2015 1:04 pm ¥DÃD: ¤º«Ø¨ç¼Æ¡G¾ã¦C½Æ»s¡B¶K¤W¡A§Ñ°O¨ç¼Æ¦WºÙ¨D±Ï.... |
§Anªº¬O³oÓ¶Ü?
SCATTER MEMVAR MEMO
APPEND BLANK
GATHER MEMVAR MEMO
!! ¨S¿ù ^^
ÁÂÁ§A |
¥DÃD: ¤º«Ø¨ç¼Æ¡G¾ã¦C½Æ»s¡B¶K¤W¡A§Ñ°O¨ç¼Æ¦WºÙ¨D±Ï.... |
whh
¦^ÂÐ: 3
Æ[¬Ý: 3925
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤@ ¥|¤ë 13, 2015 10:46 am ¥DÃD: ¤º«Ø¨ç¼Æ¡G¾ã¦C½Æ»s¡B¶K¤W¡A§Ñ°O¨ç¼Æ¦WºÙ¨D±Ï.... |
¤Ó¤[¨S¥Îvfp
°O±o¥H«e¦³¤@Ó¶W¤è«Kªº¤º«Ø¨ç¼Æ¡A
¥i¥H±N¾ã¦CClass ¸ê®Æ½Æ»s¡B¶K¨ì¥t¤@ÓClassªºRow¤W±
¬d¤FÃöÁä¦r[VFP ¾ã¦C½Æ»s] ¨Ó¨D´N¤@¤U >/////< |
¥DÃD: ¦³Ãö«½Æ°O¿ýªº§R°£(Âà¶K) |
whh
¦^ÂÐ: 1
Æ[¬Ý: 4897
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤@ ¥|¤ë 13, 2015 10:32 am ¥DÃD: Re: ¦³Ãö«½Æ°O¿ýªº§R°£(Âà¶K) |
[quote="Ruey"]¥H¤U´N«½Æ°O¿ý§R°£ªº°ÝÃD§@¤@ÄÄz¡C
¦³¨âÓ·N¸q¤Wªº«½Æ°O¿ý¡A¤@¬O§¹¥þ«½Æªº°O¿ý¡A¤]§Y©Ò¦³Äæ¦ì§¡«½Æªº°O¿ý¡A¤G¬O³¡¤ÀÃöÁä¦r¬q«½Æªº°O¿ý¡A¤ñ¦pNameÄæ¦ì«½Æ¡A¦Ó¨ä¥LÄæ¦ì¤£¤@©w«½Æ©Î³£«½Æ¥i¥H ... |
¥DÃD: 64¦ì¤¸¾÷¾¹¡A³s±µ Oracle DB ¥X¿ù |
whh
¦^ÂÐ: 3
Æ[¬Ý: 5328
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤G ¤T¤ë 10, 2015 8:36 am ¥DÃD: 64¦ì¤¸¾÷¾¹¡A³s±µ Oracle DB ¥X¿ù |
¨S¸gÅç¡A¦ý¬O¡AOracle ªº ODBC driver name ¤£À³¸Ó¬O "{Microsoft ODBC for Oracle}"
§A¥i¯àn¶}±±¨î¥x¸Ìªº ODBC ¬d¤@¤U¡C
{Microsoft ODBC for Oracle}
Code À³¸Ó¬O¨S°ÝÃD¡A¦]¬°Â¹q¸£¤]¬O Windows 7 64 Bit ... |
¥DÃD: 64¦ì¤¸¾÷¾¹¡A³s±µ Oracle DB ¥X¿ù |
whh
¦^ÂÐ: 3
Æ[¬Ý: 5328
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤@ ¤T¤ë 09, 2015 1:50 pm ¥DÃD: 64¦ì¤¸¾÷¾¹¡A³s±µ Oracle DB ¥X¿ù |
³Ìªñ¤½¥q§Ë¤F¥x·s¾÷¾¹¡AµL¥~ºôªº§¹¥þ´X¥G¥u¦³64¦ì¤¸...
Oracle Client ·íµM¤]¥u¦³¸Ë 64¦ì¤¸
¤]ÂêºÞ²zªÌÅv¤F
¶â~ ©Ò¥H³nÅé³q³q¤£¯à¸Ë
¦nÀI Oracle ©x¤èºô¯¸¦³ 32¦ì¤¸ªº Oracle Client §K¦w¸Ëªº
( ¸ÑÀ ... |
¥DÃD: ½Ð°Ý¦³¤@¥÷ xlsx ÀɮסA¦p¦óµLµhµL¸£ import ¶iVFPªºDB |
whh
¦^ÂÐ: 4
Æ[¬Ý: 8002
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤G ¤Q¤ë 07, 2014 4:33 pm ¥DÃD: ½Ð°Ý¦³¤@¥÷ xlsx ÀɮסA¦p¦óµLµhµL¸£ import ¶iVFPªºDB |
garfield ¤j¤j
¥i¥H½Ð°Ý½d¨Ò¶Ü T.T
AppendFromExcel(m.lcXlsFile, "Sheet1", "MyTable", "column1,column2,column3", "Recnum Is Not Null", "field1,field2,field3", "field1 > 14000")
EX:
AppendF ... |
¥DÃD: ½Ð±Ðsqlexec¬O§_¦³ªø«×¨î? |
whh
¦^ÂÐ: 12
Æ[¬Ý: 16927
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤G ¤Q¤ë 07, 2014 3:22 pm ¥DÃD: ½Ð±Ðsqlexec¬O§_¦³ªø«×¨î? |
_CLIPTEXT ¬O¤£¬O¥Nªí°Å¶K鷺®eªº·N«ä??
³o´N¬O windows ¤U¼gµ{¦¡ªº¦n³B, ¦³«Ü¦h·N·Q¤£¨ìªº¸ê·½¥i¥Î
¨S¿ù!!
_CLIPTEXT = ¨ä¹ê´N¬OÀ°§A°µ Ctrl +C ªº·N«ä
¶W¯Å¶W¯Å¦n¥Î |
¥DÃD: ½Ð°Ý¦³¤@¥÷ xlsx ÀɮסA¦p¦óµLµhµL¸£ import ¶iVFPªºDB |
whh
¦^ÂÐ: 4
Æ[¬Ý: 8002
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤G ¤Q¤ë 07, 2014 2:46 pm ¥DÃD: ½Ð°Ý¦³¤@¥÷ xlsx ÀɮסA¦p¦óµLµhµL¸£ import ¶iVFPªºDB |
http://i.imgur.com/u3QHFuK.png?1
¦]¬°·|¦³¸ó¦~ªº¸ê®Æ¡A©Ò¥H·|n©î¦¨¨âµ§~@@
1. import from IMPORT from d:\xxx.xlsx TYPE xl8
VFP 9·|ª½±µ±¾ÂI
2. ¥ý±NExcleÂন¡A«D±`ª©ªº Excle (95)¤~¯à¶¶§Q¶×¤J
... |
¥DÃD: ½Ð±Ðsqlexec¬O§_¦³ªø«×¨î? |
whh
¦^ÂÐ: 12
Æ[¬Ý: 16927
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤T ¤E¤ë 24, 2014 9:53 am ¥DÃD: ½Ð±Ðsqlexec¬O§_¦³ªø«×¨î? |
·PÁ¦U¦ì¸Ñ´b¡A´N¦p¦P2¼Ó¤j¤j©Ò¨¥¡A§Ú¥Ø«e¬O¥Î³oªº¤èªk¡A´N¬O§â¦r¦ê©î¦¨¼ÆÓ¡AµM«á¦A¥
¬°¤°»ò¤£ª½±µ¥Î¦P¤@Ó¦r¦êÅܼƴN¦n¤Far ?
EX:
Test_str1="Update myTable "
Test_str1= Test_str1+ "Set A='" + C_A + "' ... |
¥DÃD: §ó·s½Ä¬ð |
whh
¦^ÂÐ: 4
Æ[¬Ý: 4446
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤G ¤K¤ë 12, 2014 5:45 pm ¥DÃD: §ó·s½Ä¬ð |
¦³¤@ӫܪº¤èªk¡A¶}¤@Ó Table ¡÷ ¬ö¿ý¥Ø«e¨Ï¥Î¤¤ªº¹q¸£¦WºÙ
EX: ÂIקï«ö¶s ¡÷ ¥ß°¨¼g¤J¨ºÓTable ¡÷ ¦³¤H¤]¬ðµMÂI¨ºµ§nק諸¸Ü¡A´NÅã¥Ü¡y¥Ø«e¡z¬Y¬Y¥x¹q¸£²§°Ê¤¤¡A¤£¥iקï!
¦sÀÉ«á°O±on§âTable¸ê®Æ¬å±¼ ... |
¥DÃD: ¦³¨S¦³DBFÅýÄæ¦ì¶W¹L10½Xªº¤èªk ? |
whh
¦^ÂÐ: 2
Æ[¬Ý: 4230
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤G ¤K¤ë 12, 2014 3:17 pm ¥DÃD: ¦³¨S¦³DBFÅýÄæ¦ì¶W¹L10½Xªº¤èªk ? |
«e´X¤Ñ¾aµÛ¤j¤jÌ´£¨Ñªº¸ê°T¡A²×©ó¼g§¹¤F!!
Oracle Table ¡÷ ¦Û°Ê¤ÀªR¥X¸êDB®Æµ²ºcClass & «Øºc¤l¡C
¦P¨ÆÌ«Ü·PÁ§Ú~ ¤Ó¶}¤ß¤F
http://i.imgur.com/eJnAN5s.jpg?1
¦³¹Ï¦³¯u¬Û
µe±½Õ¨ì§Ú«Üº¡·N¤~ ... |
¥DÃD: AFIELD ¨ú±oÄæ¦ìªø«×°ÝÃD ? |
whh
¦^ÂÐ: 10
Æ[¬Ý: 11365
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤ ¤K¤ë 08, 2014 11:28 am ¥DÃD: AFIELD ¨ú±oÄæ¦ìªø«×°ÝÃD ? |
«e±¦³´£¨ì:
"¦ý³oÓ¤]¤£¯à§¹¥þ»¡·Ç.
¦]¬°¦³ ODBC FIELD ¹ïÀ³°ÝÃD"
http://msdn.microsoft.com/en-US/en-en/library/windows/apps/xaml/0d6d6c1e(v=vs.80).aspx
¦]¬°FOXPRO ¬O¥Î VFP Åܼƫ¬ºA <= ... |
¥DÃD: AFIELD ¨ú±oÄæ¦ìªø«×°ÝÃD ? |
whh
¦^ÂÐ: 10
Æ[¬Ý: 11365
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤ ¤K¤ë 08, 2014 11:26 am ¥DÃD: AFIELD ¨ú±oÄæ¦ìªø«×°ÝÃD ? |
Y¤£·R¥Î AField
¨º¥Î COPY STRUCTURE EXTENDED ¤]¦æ§r
·PÁÂ ckp¤j6250 ¤j¤j
³oÓ function ¤è«K¦n¦h |
|