Description |
1 online resource (41 pages) |
Contents |
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 statementsProblem 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 programmaticallyExample:; 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 interactivelyExample:; 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 |
Notes |
Field names |
|
Print version record |
SUBJECT |
Visual FoxPro for Windows. http://id.loc.gov/authorities/names/n95047852
|
|
Visual FoxPro for Windows. fast (OCoLC)fst01383859 |
Subject |
Programming languages
|
Form |
Electronic book
|
ISBN |
9781930919754 |
|
1930919751 |
|