Re: Uppercase to lowercase trigger?

On 05/03/12 12:50 AM, Ken Tanzer wrote:
> What if you created separate tables with the fields in uppercase,
> either with different names or better yet the same names and a
> different schema?  It seems you could put triggers on those tables,
> and have your trigger translate the field names and make the updates
> to the real tables instead.

if one of the applications is read only on this table,  you could use a
view with the alternate version of the names.





--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast