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

¦³ 166 µ§¸ê®Æ²Å¦X±z·j´Mªº±ø¥ó
VFP ·R¥ÎªÌªÀ°Ï ­º­¶
µoªí¤H ¤º®e
  ¥DÃD: ºµºµ§Ñ°O«ç»òª½±µ±q Oracle §â¸ê®Æ³z¹LODBC ¸ü¨ìVFP
whh

¦^ÂÐ: 1
Æ[¬Ý: 2692

µoªíª©­±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤@ ¤C¤ë 13, 2015 11:50 am   ¥DÃD: Re: ºµºµ§Ñ°O«ç»òª½±µ±q Oracle §â¸ê®Æ³z¹LODBC ¸ü¨ìVFP
Help §ä¨ì¤F

SQLEXEC Embarassed Embarassed Embarassed
  ¥DÃD: ºµºµ§Ñ°O«ç»òª½±µ±q Oracle §â¸ê®Æ³z¹LODBC ¸ü¨ìVFP
whh

¦^ÂÐ: 1
Æ[¬Ý: 2692

µoªíª©­±: 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
Æ[¬Ý: 3802

µoªíª©­±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤@ ¥|¤ë 13, 2015 1:04 pm   ¥DÃD: ¤º«Ø¨ç¼Æ¡G¾ã¦C½Æ»s¡B¶K¤W¡A§Ñ°O¨ç¼Æ¦WºÙ¨D±Ï....
§A­nªº¬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
Æ[¬Ý: 3802

µoªíª©­±: 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
Æ[¬Ý: 4811

µoªíª©­±: 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
Æ[¬Ý: 5197

µoªíª©­±: 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
Æ[¬Ý: 5197

µoªíª©­±: 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
Æ[¬Ý: 7820

µoªíª©­±: 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
Æ[¬Ý: 15370

µoªíª©­±: 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
Æ[¬Ý: 7820

µoªíª©­±: 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
Æ[¬Ý: 15370

µoªíª©­±: 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
Æ[¬Ý: 4326

µoªíª©­±: 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±o­n§âTable¸ê®Æ¬å±¼ ...
  ¥DÃD: ¦³¨S¦³DBFÅýÄæ¦ì¶W¹L10½Xªº¤èªk ?
whh

¦^ÂÐ: 2
Æ[¬Ý: 4136

µoªíª©­±: 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 Embarassed

http://i.imgur.com/eJnAN5s.jpg?1
¦³¹Ï¦³¯u¬Û
µe­±½Õ¨ì§Ú«Üº¡·N¤~­ ...
  ¥DÃD: AFIELD ¨ú±oÄæ¦ìªø«×°ÝÃD ?
whh

¦^ÂÐ: 10
Æ[¬Ý: 11129

µoªíª©­±: 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
Æ[¬Ý: 11129

µoªíª©­±: 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 Smile
 
²Ä1­¶(¦@12­¶) «e©¹­¶­± 1, 2, 3 ... 10, 11, 12  ¤U¤@­¶
©Ò¦³ªº®É¶¡§¡¬° ¥x¥_®É¶¡ (GMT + 8 ¤p®É)
«e©¹:  


Powered by phpBB © 2001, 2005 phpBB Group
¥¿Å餤¤å»y¨t¥Ñ phpbb-tw ºûÅ@»s§@