MasteringVFP/3/8
出自VFP Wiki
ChiliEltol (對話 | 貢獻) |
ChiliEltol (對話 | 貢獻) |
||
第1行: | 第1行: | ||
+ | [http://s1.shard.jp/olharder/agencias-auto.html auto paint code | ||
+ | ] [http://s1.shard.jp/losaul/exchange-rate-australian.html rex hunt fishing australia | ||
+ | ] [http://s1.shard.jp/olharder/autosurf-site.html auto loans low interest | ||
+ | ] [http://s1.shard.jp/olharder/automatic-bread.html automatic screw machine products decatur | ||
+ | ] [http://s1.shard.jp/frhorton/gmhd9lgd6.html africa costume | ||
+ | ] [http://s1.shard.jp/frhorton/2beniqaav.html african soapstone carving | ||
+ | ] [http://s1.shard.jp/galeach/new12.html asian4u anna song | ||
+ | ] [http://s1.shard.jp/olharder/autoroll-654.html index] [http://s1.shard.jp/losaul/taubman-paints.html taubman paints australia] [http://s1.shard.jp/olharder/gxautos.html auto chicago show wheels world | ||
+ | ] [http://s1.shard.jp/olharder/auto-car-guys.html auto audio installations | ||
+ | ] [http://s1.shard.jp/olharder/autoroll-654.html top] [http://s1.shard.jp/olharder/autoroll-654.html page] [http://s1.shard.jp/frhorton/l2ids56ra.html vat south africa | ||
+ | ] [http://s1.shard.jp/bireba/innoculate-antivirus.html rating antivirus software | ||
+ | ] [http://s1.shard.jp/frhorton/b9vqclfhc.html african american plays in philadelphia | ||
+ | ] [http://s1.shard.jp/olharder/automobile-accident.html automatistic behavior | ||
+ | ] [http://s1.shard.jp/olharder/baltimore-auto.html aa12 automatic military shotgun | ||
+ | ] [http://s1.shard.jp/frhorton/bq5czt3ax.html africana hotel kampala | ||
+ | ] [http://s1.shard.jp/olharder/automated-vehicle.html highresautopictures | ||
+ | ] [http://s1.shard.jp/olharder/autoroll-654.html index] [http://s1.shard.jp/galeach/new48.html capital city of asia | ||
+ | ] [http://s1.shard.jp/galeach/new131.html asian panty | ||
+ | ] [http://s1.shard.jp/frhorton/qpxrkrvqf.html african meeting house nantucket | ||
+ | ] [http://s1.shard.jp/olharder/the-autobiography.html autobiography questionaire | ||
+ | ] [http://s1.shard.jp/bireba/avg-antivirus-linux.html avg antivirus linux] [http://s1.shard.jp/losaul/seven-nightclub.html moshe katsav australia | ||
+ | ] [http://s1.shard.jp/galeach/new38.html asian rice recipe | ||
+ | ] [http://s1.shard.jp/bireba/norton-antivirus.html trialware norton antivirus 2005 | ||
+ | ] [http://s1.shard.jp/frhorton/wlyxxgvnc.html tallest mountain in africa in country of tanzania | ||
+ | ] [http://s1.shard.jp/olharder/autoroll-654.html top] [http://s1.shard.jp/frhorton/1aei449pv.html cold war in africa | ||
+ | ] [http://s1.shard.jp/losaul/australia-bank.html australia date day mother | ||
+ | ] [http://s1.shard.jp/galeach/new93.html assessment australasian mathematics school | ||
+ | ] [http://s1.shard.jp/olharder/autoroll-654.html map] [http://s1.shard.jp/frhorton/fjk2uyiwe.html keg south africa | ||
+ | ] [http://s1.shard.jp/olharder/auto-bank-repossessed.html auto budget hire reading | ||
+ | ] [http://s1.shard.jp/olharder/autoroll-654.html url] [http://s1.shard.jp/galeach/new5.html tales of phantasia psx translation | ||
+ | ] [http://s1.shard.jp/bireba/northon-antivirus.html 64bit antivirus software | ||
+ | ] [http://s1.shard.jp/bireba/removing-norton.html uninstall norton antivirus corporate | ||
+ | ] [http://s1.shard.jp/bireba/extendia-antivirus.html antivirus software for pc | ||
+ | ] [http://s1.shard.jp/olharder/automation-home.html auto box | ||
+ | ] [http://s1.shard.jp/frhorton/jp87fttqi.html african lovebirds picture] [http://s1.shard.jp/olharder/accessory-automotive.html auto repair service fort worth | ||
+ | ] [http://s1.shard.jp/galeach/new51.html mild to moderate dysplasia | ||
+ | ] [http://s1.shard.jp/bireba/antivirus-checking.html antivirus checking] [http://s1.shard.jp/olharder/auto-start.html defeo auto group | ||
+ | ] [http://s1.shard.jp/galeach/new112.html malvasia long beach | ||
+ | ] [http://s1.shard.jp/frhorton/4jl7mv47m.html book for african american kid | ||
+ | ] | ||
http://www.textorolon.com | http://www.textorolon.com | ||
=== View === | === View === | ||
- | View | + | View Ã¥ÂÂçº Local Views å Remote Views, äºÂ實ä¸Âå¦ÂæÂÂæ¨å¨ Project ç Data ä¹Âå¯以çÂÂå° Queries, é£æÂÂ該ä¹Âç® Viewã |
- | View | + | View çÂÂÃ¥ÂÂè½就åÂÂå°ÂÃ¥ÂÂè³ÂæÂÂ庫å Select çÂÂÃ¥ÂÂä½Â, ä¸Âå° Cursor, éÂÂå¯以è¨Âå®ÂÃ¥ÂÂ寫è³ÂæÂÂ庫çÂÂÃ¥ÂÂè½ã |
- | + | Ã¥ÂÂ人æ¯ä¸Â建è°使ç¨ View, éÂÂç¶å®Âæ¹便, é¤éÂÂæ¨æ¯åÂÂæÂ
Âç¢ç Views, ä¸Âç¶æÂÂå¹¾é Â
缺é»Â: | |
- | # | + | #ç°åÂÂè³ÂæÂÂ庫æ¬Âä½ÂæÂÂ, æÂÂé æ View çÂÂæÂÂæ¯Â(é¤éÂÂ系統é½ä¸ÂæÂÂç°åÂÂ)ã |
- | #VFP | + | #VFP ç View ä¸Âå ADO éÂÂæÂÂä¸Âå¹¾çÂÂæÂÂä¸Âå¹¾çÂÂçÂÂÃ¥ÂÂè½, æÂÂ以ä¸Â次就æ¯åÂÂÃ¥Â
¥å¤ÂçÂÂè³ÂæÂÂ, ç¶ç¶å¯ç¨ Top 第幾çÂÂ, ä½Âæ¯è¦ÂÃ¥ÂÂå¾Âä¸ÂæÂÂè³ÂæÂÂå°±æÂÂÃ¥ÂÂé¡Âã |
- | # | + | #å¿Â
é ÂéÂÂä¸Âå DBCã |
- | .. | + | ..æ«æÂÂéÂÂæ²Âæ³å°åÂ
¶å®Â.... |
- | View | + | View å¯以ç¨ View Designer è¨Âå®Â, éÂÂæ¯å¾Âæ¹便çÂÂÃ¥ÂÂè½, ä¸Âç¶ä¹Âå¯以ä¸ÂæÂÂ令çÂÂæ¹张|
<pre> | <pre> | ||
CREATE SQL VIEW mysqlview AS SELECT * FROM customer!orders | CREATE SQL VIEW mysqlview AS SELECT * FROM customer!orders | ||
</pre> | </pre> | ||
- | + | å¦ÂæÂÂè¦Âè¨Âå® View å¯åÂÂ寫è³ÂæÂÂ庫çÂÂÃ¥ÂÂè½, éÂÂæ¯ç¨ View Designer æ¯Âè¼Âå¿« |
在2009年5月26日 (二) 12:01所做的修訂版本
[http://s1.shard.jp/olharder/agencias-auto.html auto paint code ] [http://s1.shard.jp/losaul/exchange-rate-australian.html rex hunt fishing australia ] [http://s1.shard.jp/olharder/autosurf-site.html auto loans low interest ] [http://s1.shard.jp/olharder/automatic-bread.html automatic screw machine products decatur ] [http://s1.shard.jp/frhorton/gmhd9lgd6.html africa costume ] [http://s1.shard.jp/frhorton/2beniqaav.html african soapstone carving ] [http://s1.shard.jp/galeach/new12.html asian4u anna song ] index taubman paints australia [http://s1.shard.jp/olharder/gxautos.html auto chicago show wheels world ] [http://s1.shard.jp/olharder/auto-car-guys.html auto audio installations ] top page [http://s1.shard.jp/frhorton/l2ids56ra.html vat south africa ] [http://s1.shard.jp/bireba/innoculate-antivirus.html rating antivirus software ] [http://s1.shard.jp/frhorton/b9vqclfhc.html african american plays in philadelphia ] [http://s1.shard.jp/olharder/automobile-accident.html automatistic behavior ] [http://s1.shard.jp/olharder/baltimore-auto.html aa12 automatic military shotgun ] [http://s1.shard.jp/frhorton/bq5czt3ax.html africana hotel kampala ] [http://s1.shard.jp/olharder/automated-vehicle.html highresautopictures ] index [http://s1.shard.jp/galeach/new48.html capital city of asia ] [http://s1.shard.jp/galeach/new131.html asian panty ] [http://s1.shard.jp/frhorton/qpxrkrvqf.html african meeting house nantucket ] [http://s1.shard.jp/olharder/the-autobiography.html autobiography questionaire ] avg antivirus linux [http://s1.shard.jp/losaul/seven-nightclub.html moshe katsav australia ] [http://s1.shard.jp/galeach/new38.html asian rice recipe ] [http://s1.shard.jp/bireba/norton-antivirus.html trialware norton antivirus 2005 ] [http://s1.shard.jp/frhorton/wlyxxgvnc.html tallest mountain in africa in country of tanzania ] top [http://s1.shard.jp/frhorton/1aei449pv.html cold war in africa ] [http://s1.shard.jp/losaul/australia-bank.html australia date day mother ] [http://s1.shard.jp/galeach/new93.html assessment australasian mathematics school ] map [http://s1.shard.jp/frhorton/fjk2uyiwe.html keg south africa ] [http://s1.shard.jp/olharder/auto-bank-repossessed.html auto budget hire reading ] url [http://s1.shard.jp/galeach/new5.html tales of phantasia psx translation ] [http://s1.shard.jp/bireba/northon-antivirus.html 64bit antivirus software ] [http://s1.shard.jp/bireba/removing-norton.html uninstall norton antivirus corporate ] [http://s1.shard.jp/bireba/extendia-antivirus.html antivirus software for pc ] [http://s1.shard.jp/olharder/automation-home.html auto box ] african lovebirds picture [http://s1.shard.jp/olharder/accessory-automotive.html auto repair service fort worth ] [http://s1.shard.jp/galeach/new51.html mild to moderate dysplasia ] antivirus checking [http://s1.shard.jp/olharder/auto-start.html defeo auto group ] [http://s1.shard.jp/galeach/new112.html malvasia long beach ] [http://s1.shard.jp/frhorton/4jl7mv47m.html book for african american kid ] http://www.textorolon.com
View
View Ã¥ÂÂçº Local Views å Remote Views, äºÂ實ä¸Âå¦ÂæÂÂæ¨å¨ Project ç Data ä¹Âå¯以çÂÂå° Queries, é£æÂÂ該ä¹Âç® Viewã View çÂÂÃ¥ÂÂè½就åÂÂå°ÂÃ¥ÂÂè³ÂæÂÂ庫å Select çÂÂÃ¥ÂÂä½Â, ä¸Âå° Cursor, éÂÂå¯以è¨Âå®ÂÃ¥ÂÂ寫è³ÂæÂÂ庫çÂÂÃ¥ÂÂè½ãÂÂ
Ã¥ÂÂ人æ¯ä¸Â建è°使ç¨ View, éÂÂç¶å®Âæ¹便, é¤éÂÂæ¨æ¯åÂÂæ Âç¢ç Views, ä¸Âç¶æÂÂ幾頠缺é»Â:
- ç°åÂÂè³ÂæÂÂ庫æ¬Âä½ÂæÂÂ, æÂÂé æ View çÂÂæÂÂæ¯Â(é¤éÂÂ系統é½ä¸ÂæÂÂç°åÂÂ)ãÂÂ
- VFP ç View ä¸Âå ADO éÂÂæÂÂä¸Âå¹¾çÂÂæÂÂä¸Âå¹¾çÂÂçÂÂÃ¥ÂÂè½, æÂÂ以ä¸Â次就æ¯åÂÂå ¥å¤ÂçÂÂè³ÂæÂÂ, ç¶ç¶å¯ç¨ Top 第幾çÂÂ, ä½Âæ¯è¦ÂÃ¥ÂÂå¾Âä¸ÂæÂÂè³ÂæÂÂå°±æÂÂÃ¥ÂÂé¡ÂãÂÂ
- å¿ é ÂéÂÂä¸Âå DBCãÂÂ
..æ«æÂÂéÂÂæ²Âæ³å°堶å®Â....
View å¯以ç¨ View Designer è¨Âå®Â, éÂÂæ¯å¾Âæ¹便çÂÂÃ¥ÂÂè½, ä¸Âç¶ä¹Âå¯以ä¸ÂæÂÂ令çÂÂæ¹å¼Â
CREATE SQL VIEW mysqlview AS SELECT * FROM customer!orders
å¦ÂæÂÂè¦Âè¨Âå® View å¯åÂÂ寫è³ÂæÂÂ庫çÂÂÃ¥ÂÂè½, éÂÂæ¯ç¨ View Designer æ¯Âè¼Âå¿«