| Reader's Clinic - Functions and Subroutines |
| Reader's Letters - Jim Owen |
| Playing with Scan Codes |
| Argument passing - Subroutines and Functions - Mike Pope |
| SecureUser |
| VERBatim - V25 |
| @ATTACK - @Files.System |
| Advanced Revelation Initialisation Sequence (Overview) by Mike Pope |
| REVMEDIA Revisted |
| Reader's Clinic - RList Column Names |
| Reader's Clinic - Blank Column Headings in RLIST |
| QTIPS - Column Heading Limit |
| @ATTACK - @File.Error |
| @ATTACK - @File.Error.Mode |
| QTIPS - Standardising Error Message Display |
| Version 3 Technical Highlights - ValidateName |
RevMedia FKB
| Document | V4I6A5 |
| Title | Version 3 Technical Highlights - ValidateName |
| Keywords | VALIDATENAME @FILE.ERROR SQL |
| Text | This is a function designed to check whether a given name will conflict with SQL/system reserved words or rules It is passed the name to validate and a Boolean flag which is used to indicate whether changes are permitted (true for yes false for no) It returns either the word the modified word or a pass/fail flag If changes are permitted the system will modify SQL reserved words or variables beginning WITH an integer by putting an "A" at the beginning (try using KEY as a column name in DEFINETABLE to see an EXAMPLE of this) It will ALSO truncate NAMES longer than 50 characters and convert lowercase to uppercase If changes are not permitted it will return a true/false flag to indicate whether the name conforms to SQL naming CONVENTIONS If a false flag is returned the reason is given in @FILE ERROR WITH return codes ranging from S110 to S115 WITH meanings as follows S110 Starts WITH a number S111 Longer than 50 characters S112 Contains invalid characters S113 Reserved by the system (in testing it proved impossible to produce this message WITH SYS table NAMES or VOC commands) S114 Reserved by SQL S115 Does not start WITH a letter (could only get this to fail if the name started WITH an underscore All other characters caused an S112 (Volume 4 Issue 6 Page 7) |
Page last modified: 08/02/03