Data Access Worldwide Knowledge Base
Article ID 2323 Article Title HOWTO: Automatically change casing of filelist entries and column names Article URL http://www.dataaccess.com/kbasepublic/KBPrint.asp?ArticleID=2323 KBase Category VDF12 Date Created 06/12/2007 Last Edit Date 06/12/2007
Article Text
QUESTION:
As of Visual DataFlex 12.0 I can have column (field) names that are no longer uppercased. That is nice but am I supposed to go into database builder and change them all manually? That is a lot of work...
ANSWER:
While you can do that and you have full control over the action, you can also automate a part of the action by creating a Visual DataFlex program that uses the Database API commands.
The enclosed program runs through all filelist entries and updates the information by using a mixed_case function. Use as is or modify it yourself.
Contributed By:
Vincent Oorsprong
Company: Data Access Worldwide
email: vincent.oorsprong@dataaccess.eu
Web Site: http://www.dataaccess.eu
Web Links Related to this Article
File NiceCasingFileList.Src
URL=http://www.dataaccess.com/KBasePublic/Files/2323.NiceCasingFileList.Src
Email this Article
Email this Article to a Colleague
Send Feedback on this Article to Data Access Worldwide
Copyright ©2010 Data Access Corporation. All rights reserved.
The information provided in the Data Access Technical Knowledge Base is provided "as is" without warranty of any kind. Data Access Corporation disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. In no event shall Data Access Corporation or its suppliers be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of business profits or special damages, even if Data Access Corporation or its suppliers have been advised of the possibility of such damages. Some states do not allow the exclusion or limitation of liability for consequential or incidental damages so the foregoing limitation may not apply.