|
詳細（に述べる）d （米）棚上げする／（英）提議する of Contents (PDF) here
一時期／支部 1: Why （弁護士の）依頼人-Server? Why VFP? Why MySQL?
一時期／支部 2: 開発 and （軍隊などの）展開，配備 シナリオs
一時期／支部 3: 任命する／導入するing MySQL on Windows
一時期／支部 4: 任命する／導入するing MySQL on Linux
一時期／支部 5: Configuration of 使用者s and Hosts
一時期／支部 6: Connecting VFP to MySQL
一時期／支部 7: Configuring MySQL
一時期／支部 8: The Interactive Use of MySQL
一時期／支部 9: Under the Hood: Where MySQL Keeps Its Data
一時期／支部 10: Creating Data 始める，決めるs from Scratch
一時期／支部 11: 居住させるing a MySQL Database: LOAD DATA INFILE
一時期／支部 12: 居住させるing a MySQL Database Programmatically
一時期／支部 13: 前進するd Data 問題／発行するs
一時期／支部 14: 建設するing SQL to Avoice SQL 注射
一時期／支部 15: 宗教的な Wars: Remote 見解（をとる）s, CursorAdapters, and SQL PassThrough
一時期／支部 16: A （弁護士の）依頼人-Server 明言する／公表する of Mind
一時期／支部 17: xBase to SQL 転換 問題／発行するs
一時期／支部 18: A （弁護士の）依頼人-Server 使用者 Interface for Querying
一時期／支部 19: A （弁護士の）依頼人-Server 使用者 Interface for 追加する/Edit/削除する
一時期／支部 20: Relational 正直さ
一時期／支部 21: Getting Started with 蓄える／店d 手続きs
一時期／支部 22: （軍隊などの）展開，配備
一時期／支部 1: Why VFP? Why MySQL?
VFP and MySQL make an incredible combination for fat-（弁護士の）依頼人, （弁護士の）依頼人-server and Web 使用／適用s. However, Microsoft's many years of marketing neglect has relegated VFP to 近づく invisibility. Thus, its 能力s are 大部分は unknown and its 選択 as a 開発 道具 has become a 疑わしい choice in the 注目する，もくろむs of many uninformed or prejudiced 使用者s. And MySQL, にもかかわらず its growing 受託 in many areas of the IT 円形競技場, is still a 親族 newcomer ーに関して／ーの点でs of mind-株 with many US 使用者s 予定 to its open source roots and European origins. This 一時期／支部 explains why VFP and MySQL is a 説得力のある combination, and gives you, the developer, 弾薬／武器 for those "discussions" with 管理／経営.
Since this 調書をとる／予約する covers both VFP and MySQL, it's likely that some readers are coming from an 'experienced in VFP, inexperienced in MySQL' 視野 while others are more familiar with MySQL and いっそう少なく so with VFP. And it's probable that some are new to （弁護士の）依頼人-server 完全に. As a result, after discussing （弁護士の）依頼人-server architecture in general, I'll cover what each 道具 is and the 利益s of using it.
一時期／支部 2. 開発 and （軍隊などの）展開，配備 シナリオs
Given that MySQL is a true cross-壇・綱領・公約 database that runs on Windows, Linux, and Macintosh (同様に as others), there are many combinations of 環境s in which VFP 作品 with MySQL. Together with the segregated 必要物／必要条件s of （弁護士の）依頼人-server 構成要素s and the disparate needs of a VFP/MySQL developer during 開発, 実験（する）ing, and （軍隊などの）展開，配備, it can be 混乱させるing to understand what pieces are 要求するd and where they fit. This 一時期／支部 discusses the さまざまな シナリオs, what the 構成要素s for each combination are, and how they fit together.
一時期／支部 3. 取り付け・設備 on Windows
取り付け・設備 is like finding the 緊急 ブレーキ in your car. Once you know where it is, it seems rather trivial. However, if you can't find it, you're not going very far. In this 一時期／支部, I'll show you how to 任命する／導入する MySQL on a Windows box, starting with downloading the 権利 とじ込み／提出するs, and finishing up with some troubleshooting steps. In その後の 一時期／支部s, I'll 述べる the 関係 過程 between MySQL and VFP.
一時期／支部 4. 取り付け・設備 on Linux
This 一時期／支部 補足（する）s the on-line documentation with a 詳細（に述べる）d, step-by-step description of how to 任命する／導入する MySQL from RPMs の上に a Linux machine. It's from the 視野 of an experienced Windows programmer who is new to Linux and 供給するs background and 視野 behind the steps. I'll show you how to 任命する／導入する MySQL on a SuSE Linux box, starting with downloading the 権利 とじ込み／提出するs, continuing with the 取り付け・設備, and finishing up with 演説（する）／住所ing 可能性のある problems. Then I'll discuss an 代案／選択肢 取り付け・設備 of MySQL on a Fedora 核心 5/6 machine. Finally, I'll 述べる what has happened as a result of the 取り付け・設備. In その後の 一時期／支部s, I'll 述べる the 関係 過程 between MySQL and VFP.
一時期／支部 5. Configuration of 使用者s and Hosts
Once you 確認する that the MySQL server is up and running, you need to do some configuration of 使用者s and hosts, and then 実験（する） connecting to the server 地元で. The 概念s and steps 伴う／関わるd are the same for both Windows and Linux, so you need to read this 一時期／支部 関わりなく which operating system you're using.
一時期／支部 6. Connecting VFP to MySQL
Now that we have MySQL server up and running with the 権利 使用者s and hosts, it's time to direct our attention to the Windows box running VFP. In this 一時期／支部, we will connect to MySQL from within Visual FoxPro, using the MySQL ODBC driver and a 簡潔な／要約する 始める，決める of VFP 命令（する）s.
一時期／支部 7. Configuring MySQL
MySQL's 操作／手術 is controlled by a configuration とじ込み／提出する. You can use a graphical 前線-end, called the MySQL 行政官／管理者, to change this とじ込み／提出する, or you can edit this とじ込み／提出する 直接／まっすぐに. In this 一時期／支部, I'll first show you how to 任命する／導入する and use the 行政官／管理者. Once you're comfortable with this 道具, I'll cover the 必須の configuration items you'll want to look at and かもしれない tweak yourself, and then 簡潔に cover the 残り／休憩（する） of the settings. Finally, I'll discuss how to edit the configuration とじ込み／提出する 直接／まっすぐに.
一時期／支部 8. The Interactive Use of MySQL
Once the database server is up and running, and you have proven that you can connect to it from Visual FoxPro, what next? You'll need to get comfortable using MySQL in an interactive way - creating databases and （米）棚上げする／（英）提議するs, and then 追加するing, editing, and 削除するing data from those structures. In this 一時期／支部, I'll discuss using the MySQL Query Browser to work with MySQL in an interactive 開会／開廷／会期. After covering 取り付け・設備, I'll 小旅行する the さまざまな parts of the interface, and then show how to use it to 成し遂げる data 鮮明度／定義 (creating databases and （米）棚上げする／（英）提議するs) 同様に as data 巧みな操作 (querying, 追加するing, updating, and 削除するing data). Finally, I'll 供給する pointers to some popular third party 交替／補充s.
一時期／支部 9. Under the Hood: Where MySQL Keeps Its Data
When MySQL starts up, what happens under the hood? How does it know where the databases are? How does it know who can connect to the system, and, once connected, which databases they can 接近, and what they can do to a database and the data inside? While this topic has been broached in 一時期／支部 7, "Configuration", there's plenty more still to come regarding how MySQL finds its data and how 接近 to that data (特権s) is 蓄える／店d and structured. This 一時期／支部 will finish up what we started in 一時期／支部 7 so you know how MySQL 運動s, and is driven, by its 特権 data 蓄える／店s.
一時期／支部 10. Creating Data 始める，決めるs from Scratch
This 一時期／支部 covers two separate topics. First, I discuss the differences between Visual FoxPro data types and MySQL data types, and how to choose which type you should use when creating a brand new （米）棚上げする／（英）提議する. Second, I cover how to create an empty database and how to 始める，決める all of the features of the （米）棚上げする／（英）提議する and field editors. For those of you who are worried about that big chunk of data sitting in an 存在するing database, do not fret! I'll cover 転換 from text とじ込み／提出するs to MySQL in the next 一時期／支部, and from DBFs to MySQL in the 一時期／支部 after that.
一時期／支部 11. 居住させるing a MySQL Database: LOAD DATA INFILE
Just as a database without （米）棚上げする／（英）提議するs or a （米）棚上げする／（英）提議する without fields isn't very 利益／興味ing, a database without data isn't likely to attract much attention. In this 一時期／支部, I cover the first of two 最初の／主要な 機械装置s for getting large 量s of data into your new MySQL database: using the native MySQL LOAD 命令（する）. In the next 一時期／支部, I'll cover 令状ing a 転換 program that spins through a DBF and 居住させるs the corresponding MySQL （米）棚上げする／（英）提議する 経由で SQL INSERTs.
一時期／支部 12. 居住させるing a MySQL Database Programmatically
In this 一時期／支部, I cover the second of two 最初の／主要な 機械装置s for getting large 量s of data into your new MySQL database: 令状ing a 転換 program that spins through a DBF and 居住させるs the corresponding MySQL （米）棚上げする／（英）提議する 経由で SQL INSERTs.
一時期／支部 13. 前進するd Data 問題／発行するs
Once you're comfortable with creating MySQL databases and 居住させるing them from VFP （米）棚上げする／（英）提議するs, you'll spend some time doing so and may かもしれない run up against some 問題／発行するs more sophisticated than 簡単に filling character and numeric fields as you did in the last 一時期／支部s. In this 一時期／支部, I'll cover tips and tricks with BIT fields, Blobs, Nulls, and ENUMs.
一時期／支部 14. 建設するing SQL to 避ける SQL 注射
Most people have heard the 称する，呼ぶ／期間／用語 "SQL 注射" but are often unconcerned about the 支配する, feeling it's a 安全 problem - and since they're just database developers - it couldn't かもしれない 適用する to them. Even if you're building 使用／適用s today where the 脅し of SQL 注射 isn't applicable, it behooves you to learn more about it and to develop best practices. So, if you do enter that 円形競技場 in the 未来, you're not suddenly 攻撃を受けやすい 予定 to long-developed habits that are suddenly 不適切な in a new 環境. In this 一時期／支部, I 述べる what SQL 注射 is, when you might run into it, and how to program defensively to 避ける it.
一時期／支部 15. 宗教的な Wars: Remote 見解（をとる）, CursorAdapters and SQL PassThrough
With the introduction of CursorAdapters in VFP 8, there are now three different ways to 接近 remote data in Visual FoxPro. How do you choose which one to use? In this 一時期／支部, I'll discuss the プロの／賛成のs and 反対／詐欺s of each 機械装置, and explain why I use SQL PassThrough in this 調書をとる／予約する.
一時期／支部 16. A （弁護士の）依頼人-Server 明言する／公表する of Mind
Fox developers are の中で the most 献身的な group of programmers in the world. …に出席する a 会議／協議会 and ask how many have been using the 製品 for more than ten years, and you'll get a large number of 手渡すs raised, and probably a few snickers ("Ten? Hell, I've been using Fox since it was dBASE II in 1981!") But with this depth of experience comes a 確かな mindset in the ways of doing things, and it can be hard to change habits ingrained over １０年間s of practice. It's time to consider changing that 見通し to a （弁護士の）依頼人-server 明言する／公表する of mind. This 一時期／支部 covers the conceptual differences and gets you thinking ーに関して／ーの点でs of （弁護士の）依頼人-server architecture and what it means to your systems when you work with 記録，記録的な／記録する 始める，決めるs instead of whole （米）棚上げする／（英）提議するs.
一時期／支部 17. From xBase to SQL - how to move xBASE code to work with
a SQL backend
During your career as a （弁護士の）依頼人-server developer, you're bound to run into a 状況／情勢 where a 顧客 or end 使用者 asks you to 変える a 伝統的な LAN 使用／適用 to work with a SQL 支援する end. Even if the 使用／適用 has been designed with this 転換 in mind, it's not an 平易な 職業; at the other end of the 範囲, such a 過程 can be arduous to the point of 要求するing a rewrite. As a result, there isn't a simple cookbook approach, nor a one-size-fits-all 戦略. Nonetheless, the tip sheet isn't 完全に blank. Here are some 問題／発行するs and 言及／関連 charts to help you along.
一時期／支部 18. 使用者 Interface for Querying
Up to now, this discussion has been all programmatic. What about forms? You know - those things that the 使用者 looks at data in? In this 一時期／支部, I'll cover the 創造 of a typical 使用者 interface for querying a database, made up of a filter form for 明示するing parameters, and a results form that 陳列する，発揮するs the matching 記録，記録的な／記録するs and 許すs the 使用者 to navigate の中で them. I'll show both a simple parent-child join 同様に as a form that uses a couple of lookup ('minor-（独立の）存在') （米）棚上げする／（英）提議するs.
一時期／支部 19. A （弁護士の）依頼人/Server Interface for 追加する/Edit/削除する
In the last 一時期／支部 we finally got into some code. Unfortunately, it was all read-only code. What about ENTERING and SAVING data? Or ADDING 記録，記録的な／記録するs? Maybe even getting rid of them! Sure, you probably want to save data once in a while. Remember the work you went through 15 years ago to learn how to make your 使用／適用s multi-使用者 - when you couldn't just assume that only one 使用者 was touching the data? A 類似の paradigm 転換 is 星／主役にするing at you now 同様に - except that you already have some experience with 扱うing 論争. In this 一時期／支部, I'll discuss the basic 機械装置 to 追加する, edit, and 削除する data both in 選び出す／独身 and 多重の （米）棚上げする／（英）提議する forms. I'll also cover a number of techniques that are useful during the 実施 of these forms.
一時期／支部 20. Relational 正直さ
Most Visual FoxPro developers are familiar with the 概念s of relational 正直さ,
and many have at least dabbled with having the database 施行する RI instead of 手渡す-令状ing custom code to do so. In this 一時期／支部, we'll 追加する RI to one of our 見本 使用／適用's forms.
一時期／支部 21. Getting Started with 蓄える／店d Proceduress
MySQL 5.0 made news with the 新規加入 of 蓄える／店d 手続きs, a feature that many （人命などを）奪う，主張するd 妨げるd MySQL from 存在 one of "the big boys" in the database server 円形競技場. In this 一時期／支部, we'll 調査する how MysQL's 蓄える／店d 手続きs work and how to use them from within Visual FoxPro.
一時期／支部 22. （軍隊などの）展開，配備
As the 説 goes, "It's all fun and games until someone gets 傷つける." So it goes with 開発 - it's also all fun and games until you 現実に have to make it work in 生産／産物. Isn't that someone else's 職業? Unfortunately, probably not. In this 一時期／支部, we'll discuss さまざまな 問題／発行するs with getting your VFP 使用／適用 up and running in a 生産／産物 環境.
|
