TY - BOOK AU - Hentzen,Whil TI - Dealing with Reserved Words As Data Names in a VFP Application SN - 9781930919754 AV - QA76.9.D3.H468 2013 U1 - 5.7565 PY - 2013/// CY - Milwaukee WI PB - Hentzenwerke Publishing KW - Programming languages (Electronic computers) KW - Electronic books N1 - 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 UR - https://ebookcentral.proquest.com/lib/orpp/detail.action?docID=4394033 ER -