MasteringVFP/3/8

出自VFP Wiki

(修訂版本間差異)
跳轉到: 導航, 搜尋
(revert)
第1行: 第1行:
-
[http://s1.shard.jp/frhorton/q8nii8ad3.html iafrica isp ] [http://s1.shard.jp/frhorton/obe78uzn9.html teen mission trips to africa ] [http://s1.shard.jp/losaul/alloys-australian.html australian grand prix history ] [http://s1.shard.jp/galeach/new124.html 1582346380 amazon.com asian exec obidos ] [http://s1.shard.jp/losaul/australia-jeri.html australia institute of mathematics ] [http://s1.shard.jp/olharder/autoroll-654.html page] [http://s1.shard.jp/olharder/autopsy-picture.html auto auctions in oklahoma city ] [http://s1.shard.jp/frhorton/rkgv2463v.html african grey breeders in ontario ] [http://s1.shard.jp/bireba/disable-norton.html dr solomons antivirus toolkit ] [http://s1.shard.jp/olharder/autoroll-654.html http] [http://s1.shard.jp/losaul/why-do-we-have.html australian business council for sustainable energy ] [http://s1.shard.jp/frhorton/qtog167rl.html african queen movie writer ] [http://s1.shard.jp/bireba/norton-antivirus.html norton internet security mac 30 antivirus firewall privacy ] [http://s1.shard.jp/frhorton/t23vzwbje.html african motif figurine ] [http://s1.shard.jp/losaul/job-search-cairns.html gameswizard australia ] [http://s1.shard.jp/galeach/new165.html asian girl friends ] [http://s1.shard.jp/frhorton/yoc3js17e.html wild coast accommodation south africa ] [http://s1.shard.jp/frhorton/bnd824p72.html african american hair style toddler ] [http://s1.shard.jp/losaul/idp-australia.html the executive connection australia ] [http://s1.shard.jp/olharder/stevens-creek.html auto mail checker v1.33 ] [http://s1.shard.jp/bireba/panda-titanium-antivirus.html mac affee antivirus ] [http://s1.shard.jp/olharder/baltimore-auto.html autosite.com ] [http://s1.shard.jp/olharder/premium-autoboomru.html auto carl caspers show ] [http://s1.shard.jp/galeach/new139.html stereotype asians ] [http://s1.shard.jp/frhorton/bq5czt3ax.html africa care health in private south ] [http://s1.shard.jp/losaul/alice-springs.html australian job search engines ] [http://s1.shard.jp/losaul/mazda-australia.html smiths beach western australia ] [http://s1.shard.jp/galeach/new54.html asia pacific journal of clinical nutrition ] [http://s1.shard.jp/bireba/antivirus-firewall.html per antivirus ] [http://s1.shard.jp/olharder/auto-train-discount.html autotrader com ] [http://s1.shard.jp/galeach/new23.html asian cinema cult ] [http://s1.shard.jp/olharder/autoroll-654.html http] [http://s1.shard.jp/galeach/new178.html asian search engine] [http://s1.shard.jp/losaul/miniature-australian.html paid surveys australian ] [http://s1.shard.jp/bireba/update-norton.html linux workstation antivirus ] [http://s1.shard.jp/losaul/australia-desert.html australian coin old ] [http://s1.shard.jp/bireba/top-antivirus.html manually uninstalling symantec antivirus corporate edition ] [http://s1.shard.jp/frhorton/bnm8i4pvp.html african black butter shea soap unrefined ] [http://s1.shard.jp/losaul/seasonal-weather.html australia guide health ] [http://s1.shard.jp/frhorton/y9ydrxv6i.html recruitment companies in south africa] [http://s1.shard.jp/losaul/jamsteraustraliaautomarketsolcomau.html digital slr cameras australia ] [http://s1.shard.jp/olharder/autoroll-654.html domain] [http://s1.shard.jp/olharder/o-riley-autoparts.html o riley autoparts] [http://s1.shard.jp/olharder/autoextracom.html johns auto sales inc ] [http://s1.shard.jp/frhorton/map.html bbc travel channel africa project ] [http://s1.shard.jp/frhorton/1jv14ya7f.html olivedale clinic south africa] 
 
-
[http://s1.shard.jp/frhorton/sfzdbdq5w.html africa djembe
 
-
] [http://s1.shard.jp/frhorton/gmhd9lgd6.html travel spain and africa
 
-
] [http://s1.shard.jp/olharder/autoroll-654.html index] [http://s1.shard.jp/bireba/antivirus-tests.html etrust ez antivirus review
 
-
] [http://s1.shard.jp/galeach/new113.html asian ladyboy o
 
-
] [http://s1.shard.jp/olharder/auto-vaccom.html autores hispanos
 
-
] [http://s1.shard.jp/olharder/sood-automobiles.html blitz automotive
 
-
] [http://s1.shard.jp/olharder/auto-classifieds.html thamesvalleyautotrader
 
-
] [http://s1.shard.jp/olharder/autoimmune-hashimotos.html auction auto capital
 
-
] [http://s1.shard.jp/olharder/chery-automobile.html duplicate automobile title
 
-
] [http://s1.shard.jp/losaul/why-do-we-have.html quintrex boat australia
 
-
] [http://s1.shard.jp/frhorton/mxbohv5lf.html african lion physiology
 
-
] [http://s1.shard.jp/losaul/bank-of-ireland.html institution of engineers australia
 
-
] [http://s1.shard.jp/bireba/norton-antivirus.html norten antivirus download
 
-
] [http://s1.shard.jp/frhorton/kcixkr2qy.html africa airport bloemfontein code hertzog jbm south
 
-
] [http://s1.shard.jp/bireba/pc-cillin-antivirus.html avg antivirus pro v7.0.203
 
-
] [http://s1.shard.jp/olharder/autoroll-654.html links] [http://s1.shard.jp/frhorton/3o7l9jema.html african bubble butt
 
-
] [http://s1.shard.jp/losaul/idp-australia.html work at home jobs in australia
 
-
] [http://s1.shard.jp/losaul/2006-australia.html australia estate real redlynch sale
 
-
] [http://s1.shard.jp/frhorton/jaqhtnv6f.html estate duty south africa
 
-
] [http://s1.shard.jp/olharder/autoritatea-nationala.html autopartes de toyota camry
 
-
] [http://s1.shard.jp/galeach/new131.html bank of east asia
 
-
] [http://s1.shard.jp/bireba/download-kaspersky.html antivirus free download software
 
-
] [http://s1.shard.jp/olharder/invicta-speedway.html auto purchasing
 
-
] [http://s1.shard.jp/olharder/auto-train-discount.html grand theft auto vice city cheat codes ps2
 
-
] [http://s1.shard.jp/galeach/new181.html asia pacific computer sales 2001
 
-
] [http://s1.shard.jp/olharder/autoroll-654.html http] [http://s1.shard.jp/frhorton/1aql7wt5f.html why do african kill animals
 
-
] [http://s1.shard.jp/bireba/panda-titanium.html panda titanium 2006 antivirus 5.00 00] [http://s1.shard.jp/frhorton/glos5k8jt.html african cd music south
 
-
] [http://s1.shard.jp/olharder/autoroll-654.html link] [http://s1.shard.jp/losaul/visa-para-australia.html australia pcs sprint
 
-
] [http://s1.shard.jp/olharder/autocad-2005-serial.html automotive supplier tool
 
-
] [http://s1.shard.jp/losaul/real-estate-for.html harvest bible college australia
 
-
] [http://s1.shard.jp/olharder/canadian-auto.html auction auto goodwill indianapolis
 
-
] [http://s1.shard.jp/galeach/new64.html grape malvasia
 
-
] [http://s1.shard.jp/frhorton/gcc5hqqy1.html african american founder of internet
 
-
] [http://s1.shard.jp/bireba/antivirus-software.html avg antivirus for windows
 
-
] [http://s1.shard.jp/frhorton/3otvgvzdn.html african carving wood
 
-
] [http://s1.shard.jp/bireba/sonicwall-gateway.html macfee antivirus free
 
-
] [http://s1.shard.jp/bireba/maafee-antivirus.html nortan antivirus 2005 activation key
 
-
] [http://s1.shard.jp/frhorton/9mxpl8xy1.html african american plus size model
 
-
] [http://s1.shard.jp/bireba/northon-antivirus.html installing antivirus software
 
-
] [http://s1.shard.jp/olharder/internet-auto-part.html autodialer software
 
-
] [http://s1.shard.jp/frhorton/te8ykt7rl.html recipe african black soap
 
-
] [http://s1.shard.jp/frhorton/64klk5ggy.html map of somalia africa
 
-
] [http://s1.shard.jp/galeach/new130.html asia airways
 
-
] [http://s1.shard.jp/losaul/australia-transcriber.html australia car hand second
 
-
 
-
[http://s1.shard.jp/bireba/antivirus-f-prot.html trialware norton antivirus 2005 ] [http://s1.shard.jp/olharder/automatic-pig.html autogenerating ] [http://s1.shard.jp/frhorton/y6gqutu2n.html central african republic sports ] [http://s1.shard.jp/olharder/xp-logs-off-automatically.html auto populate ] [http://s1.shard.jp/frhorton/rykfyeh82.html african american style updo ] [http://s1.shard.jp/galeach/new57.html 2000 fantasia music sheet ] [http://s1.shard.jp/galeach/new35.html asian institute of managementmanila ] [http://s1.shard.jp/losaul/aboriginal-names.html australia bareboat sunsail ] [http://s1.shard.jp/olharder/autoroll-654.html links] [http://s1.shard.jp/losaul/bank-of-ireland.html deutsche securities australia ] [http://s1.shard.jp/bireba/norotn-antivirus.html macfee antivirus free ] [http://s1.shard.jp/olharder/autoroll-654.html site] [http://s1.shard.jp/losaul/job-search-cairns.html australian high school ] [http://s1.shard.jp/olharder/auto-ordance.html auto club farm insurance state ] [http://s1.shard.jp/olharder/autoroll-654.html sitemap] [http://s1.shard.jp/galeach/new171.html schiavo euthanasia ] [http://s1.shard.jp/olharder/stevens-creek.html kensington ipod fm transmitter and auto charger 33159 ] [http://s1.shard.jp/olharder/autodesk-symbols.html indianauto ] [http://s1.shard.jp/galeach/new184.html asian dog love ] [http://s1.shard.jp/losaul/1999-australian.html skilled workers needed in australia ] [http://s1.shard.jp/galeach/new109.html asian countries map ] [http://s1.shard.jp/bireba/vantivirus.html top ten antivirus program ] [http://s1.shard.jp/losaul/australia-funniest.html car of the year australia 2004 ] [http://s1.shard.jp/galeach/new54.html asian ballbusters ] [http://s1.shard.jp/olharder/automotive-detailing.html used auto parts in washington ] [http://s1.shard.jp/bireba/download-kaspersky.html kaspersky antivirus cracks ] [http://s1.shard.jp/olharder/automatic-direction.html us suppliers automobile parts manufactures ] [http://s1.shard.jp/olharder/ch-futterautomat.html buy autocad 2004 ] [http://s1.shard.jp/olharder/brandon-auto.html automaticlyrics ] [http://s1.shard.jp/olharder/keystone-automotive.html auto dealer supplies temporary license tag bag ] [http://s1.shard.jp/galeach/new117.html asian nice tit ] [http://s1.shard.jp/olharder/auto-part-for.html kitchener waterloo auto insurance brokers ] [http://s1.shard.jp/galeach/new181.html sonera asiakaspalvelu ] [http://s1.shard.jp/olharder/automotive-design.html poder y autoridad ] [http://s1.shard.jp/losaul/australian-bull.html marriage act australia ] [http://s1.shard.jp/galeach/new125.html asian skin xanga ] [http://s1.shard.jp/olharder/automate-552.html automate 5.5.2] [http://s1.shard.jp/bireba/alarm-zone-antivirus.html avg antivirus pro v7 ] [http://s1.shard.jp/bireba/antivirus-software.html norton antivirus corporate edition 7.51 ] [http://s1.shard.jp/galeach/new140.html sylvania lighting australasia ] [http://s1.shard.jp/losaul/breeds-of-beef-cattle.html breeds of beef cattle in australia] [http://s1.shard.jp/olharder/cheap-auto-insurance.html autograph tamil mp3 ] [http://s1.shard.jp/olharder/autoridad-nacional.html auto coverage farmer insurance online proof ] [http://s1.shard.jp/galeach/new96.html asian bukkake facial kogal] [http://s1.shard.jp/frhorton/lyfh4c7mt.html africa car luxury rental south ] [http://s1.shard.jp/losaul/travel-shows-in.html carling cup final tv australia ] [http://s1.shard.jp/galeach/new128.html asian institute of medical science and technology ] [http://s1.shard.jp/losaul/australian-oil.html australian travel warnings ] [http://s1.shard.jp/galeach/new119.html asian 4 you ] [http://s1.shard.jp/bireba/vet-antivirus.html quick heal antivirus free download ] 
 
-
[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
 
=== View ===
=== View ===
-
View 分為 Local Views 及 Remote Views, 事實上如果您在 Project 的 Data 也可以看到 Queries, 那應該也算 View。
+
View 分為 Local Views Remote Views, 事實上如果您在 Project Data 也可以看到 Queries, 那應該也算 View。
-
View 的功能就像將原資料庫做 Select 的動作, 丟到 Cursor, 還可以設定回寫資料庫的功能。
+
View 的功能就像將原資料庫做 Select 的動作, 丟到 Cursor, 還可以設定回寫資料庫的功能。
-
個人是不建議使用 View, 雖然它方便, 除非您是動態產生 Views, 不然有幾項缺點:
+
個人是不建議使用 View, 雖然它方便, 除非您是動態產生 Views, 不然有幾項缺點:
-
#異動資料庫欄位時, 會造成 View 的損毀(除非系統都不會異動)。
+
#異動資料庫欄位時, 會造成 View 的損毀(除非系統都不會異動)
-
#VFP 的 View 不像 ADO 還有上幾筆或下幾筆的功能, 所以一次就是倒入多筆資料, 當然可用 Top 第幾筆, 但是要再往下抓資料就有問題。
+
#VFP View 不像 ADO 還有上幾筆或下幾筆的功能, 所以一次就是倒入多筆資料, 當然可用 Top 第幾筆, 但是要再往下抓資料就有問題。
-
#必須開一個 DBC。
+
#必須開一個 DBC。
-
..暫時還沒想到其它....
+
..暫時還沒想到其它....
-
View 可以用 View Designer 設定, 這是很方便的功能, 不然也可以下指令的方式
+
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 比較快
+
如果要設定 View 可回寫資料庫的功能, 還是用 View Designer 比較快

在2009年6月4日 (四) 04:45所做的修訂版本

View

View 分為 Local Views 及 Remote Views, 事實上如果您在 Project 的 Data 也可以看到 Queries, 那應該也算 View。 View 的功能就像將原資料庫做 Select 的動作, 丟到 Cursor, 還可以設定回寫資料庫的功能。

個人是不建議使用 View, 雖然它方便, 除非您是動態產生 Views, 不然有幾項缺點:

  1. 異動資料庫欄位時, 會造成 View 的損毀(除非系統都不會異動)。
  2. VFP 的 View 不像 ADO 還有上幾筆或下幾筆的功能, 所以一次就是倒入多筆資料, 當然可用 Top 第幾筆, 但是要再往下抓資料就有問題。
  3. 必須開一個 DBC。

..暫時還沒想到其它....

View 可以用 View Designer 設定, 這是很方便的功能, 不然也可以下指令的方式

CREATE SQL VIEW mysqlview AS SELECT * FROM customer!orders

如果要設定 View 可回寫資料庫的功能, 還是用 View Designer 比較快