Print Page | Close Window

ORACALIZE_TABLE_FIELDS.zip

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Farthing, Randy
Forum Description: Randy Farthing's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=204
Printed Date: 28 Mar 2024 at 4:23pm
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: ORACALIZE_TABLE_FIELDS.zip
Posted By: Randy Farthing
Subject: ORACALIZE_TABLE_FIELDS.zip
Date Posted: 10 Jul 2008 at 5:36am
This app is designed to change field names for tables destined to move to Oracle. A button on the main form will capitalize field names, substitute "_"s in place of spaces, optionally place a "_" in front of upper case letters imbedded within the field name, the turn the whole field name to upper case. It will change format for all fields, but reports any fields longer than the 30 char Oracle limit. This may not be perfect, but in aN Oracle conversion, this did save me more time than it took to create.

This is written in Access 97. Hasn't been tested in any other version.

Download Access 97: http://www.rogersaccesslibrary.com/forum/uploads/11/ORACALIZE_TABLE_FIELDS.zip - uploads/11/ORACALIZE_TABLE_FIELDS.zip



-------------
--

Email: mailto:randy.farthing@ci.austin.tx.us - randy.farthing@ci.austin.tx.us



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net