|
|
| （6個中途的修訂版本沒有顯示） |
| 第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
| |
| | === 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 比較快 |
View 分為 Local Views 及 Remote Views, 事實上如果您在 Project 的 Data 也可以看到 Queries, 那應該也算 View。
View 的功能就像將原資料庫做 Select 的動作, 丟到 Cursor, 還可以設定回寫資料庫的功能。
