Help  |   Contact Us  |   About Us  |   News and Events
Books, conferences, and other information about... Moving to Linux Switching to OOo Building Linux Apps Using Visual FoxPro
Buy      Download      Your Account      Catalog      Support      Conferences      Resources      Fun

Dealing with Reserved Words Used as Data Names in a Visual FoxPro Application
Table of Contents




1. Preface
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 vs keywords
Sources
Our list of reserved words

5. Problems, Problems, 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 tablename
Illegal characters in table name
Illegal characters in field name
Reserve word is too long
The spirit of the law, not just the letter
Summary of results

9. The Table Name Tests
General notes
The Tests
TEST1_TN.PRG
Conclusions

10. The Field Name Tests
General notes
The Tests
TEST2_FN.PRG
Conclusions

11. Why All The Fuss?
Table Names
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



* eof