Dealing with Reserved Words As Data Names in a VFP Application.
Material type:
- text
- computer
- online resource
- 9781930919754
- 5.7565
- QA76.9.D3.H468 2013
Hentzenwerke's Visual FoxPro in 2013 Series Dealing with Reserved Words Used as Data Names in a Visual FoxPro Application By Whil Hentzen -- 1. Preface -- ISBN -- Copyright -- Revisions -- History -- New version -- Feedback and corrections -- References and acknowledgments -- Disclaimer -- Prerequisites -- 2. About the Author -- 3. The Crux of the Problem -- 4. Defining Reserved Words -- Reserved words versus keywords -- Sources -- Our list of reserved words -- 5. Problems, Problem, Problems -- Problem 1: SQL statement fails -- Problem 2: Failed words work interactively -- Problem 3: Some reserved words do work -- Problem 4: Inconsistency across statements -- Problem 5: Inconsistency within a statement -- Problem 6: Errors vary -- 6. Scope of Analysis -- DDL - data definition language -- DML - data manipulation language -- xBase language constructs -- Being smart about testing -- 7. The Testing Infrastructure -- Folder structure -- RW table -- Programs -- 8. Populating RW.DBF Flags -- Illegal words for table name -- Illegal characters in table name -- Illegal characters in field name -- Reserved word too long -- The spirit of the law, not just the letter -- Summary of results -- 9. The Table Name Tests -- General notes -- The Tests -- 1. Create table programmatically -- Example: -- Column name: -- Results: -- 2. Create table interactively -- Column name: -- Results: -- 3. Insert record programmatically -- Example: -- Column name: -- Results: -- 4. Insert record interactively -- Column name: -- Results: -- 5. Update record programmatically -- Example: -- Column name: -- Results: -- 6. Update record interactively -- Example: -- Column name: -- Results: -- 7. Open a table programmatically -- Example: -- Column name: -- Results: -- 8. Open a table interactively -- Column name: -- Results: -- 9. Select an open table programmatically -- Example:.
Column name: -- Results: -- 10. Select an open table interactively -- Example: -- Column name: -- Results: -- 11. Select an open table programmatically, using indirection -- Example: -- Column name: -- Results: -- 12. Select an open table interactively, using indirection -- Example: -- Column name: -- Results: -- TEST1_TN.PRG -- Setup -- Testing sections -- Error handler -- Conclusions -- 10. The Field Name Tests -- General notes -- The Tests -- 1. Create table programmatically -- Example: -- Column name: -- Results: -- 2. Create table interactively -- Column name: -- Results: -- 3. Create table using the VFP Table Designer -- Results: -- 4. Insert record programmatically -- Example: -- Column name: -- Results: -- 5. Insert record interactively -- Column name: -- Results: -- 6. Update record programmatically -- Example: -- Column name: -- Results: -- 7. Update record interactively -- Example: -- Column name: -- Results: -- 8. Update record programmatically, with alias explicitly included -- Example: -- Column name: -- Results: -- 9. Delete a record programmatically -- Example: -- Column name: -- Results: -- 10. Delete a record interactively -- Column name: -- Results: -- TEST2_FN.PRG -- Setup -- Testing sections -- Error handler -- Conclusions -- 11. Why All The Fuss? -- Table Names -- Automatic table creation -- Aliases -- Field names -- 12. Your To Do List -- RWINDS.PRG -- Your Action Plan -- Conclusion -- 13. Source Code for this Book -- 14. Where To Go For More Help.
Description based on publisher supplied metadata and other sources.
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2024. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
There are no comments on this title.