Uppercase lower case issue..
627047May 12 2009 — edited May 12 2009I am fiinding this throughout all the oracle stuff.
If I create a view or stored procedure, it always returns the column names in uppercase...
This is an issue, becuase some of my code uses keys in grids that are case sensitive.
And my app has to work with both MS SQL and Oracle..
So the view listed below, returns the column names in uppercase instead of the case I have specified..
Is there any way around this?
SELECT View_AssetCurrent.AssetID,
View_AssetCurrent.ItemVar1 ,
View_AssetCurrent.ItemVar2 ,
View_AssetCurrent.ItemVar3 ,
View_AssetCurrent.ItemVar4 ,
View_AssetCurrent.ItemVar5 ,
View_AssetCurrent.ItemVar6 ,
View_AssetCurrent.ItemVar7 ,
View_AssetCurrent.ItemVar8 ,
View_AssetCurrent.ItemVar9 , View_AssetCurrent.ItemVar10 ,
View_AssetCurrent.ItemVar11 ,
View_AssetCurrent.ItemVar12 ,
View_AssetCurrent.ItemVar13 ,
View_AssetCurrent.ItemVar14 ,
View_AssetCurrent.ItemVar15 ,
View_AssetCurrent.ItemVar16 ,
View_AssetCurrent.ItemVar17 ,
View_AssetCurrent.ItemVar18 ,
View_AssetCurrent.ItemVar19 ,
View_AssetCurrent.ItemVar20 ,
View_AssetCurrent.AssetDate , View_AssetCurrent.ProfileID , View_AssetCurrent.Carrier ,
View_AssetCurrent.CurrentID ,
View_AssetCurrent.DestinationID ,
View_AssetCurrent.OwnerID ,
View_AssetCurrent.IntraUserName ,
View_AssetCurrent.ClientName ,
View_AssetCurrent.HDate ,
View_AssetCurrent.HStatus ,
View_AssetCurrent.HParent ,
View_AssetCurrent.HVar1 ,
View_AssetCurrent.HVar2 ,
View_AssetCurrent.HVar3 , View_AssetCurrent.HVar4 ,
View_AssetCurrent.HVar5 ,
View_AssetCurrent.HVar6 ,
View_AssetCurrent.HVar7 ,
View_AssetCurrent.HVar8 ,
View_AssetCurrent.HVar9 ,
View_AssetCurrent.HVar10 ,
View_AssetCurrent.SignatureID ,
View_AssetCurrent.ImageID ,
View_AssetCurrent.UpdatedByParent ,
View_AssetCurrent.ExplicitOwnerID ,
View_AssetCurrent.ExplicitDestID ,
View_RecipAndLoc_All.EmpID ,
View_RecipAndLoc_All.FullName ,
View_RecipAndLoc_All.RecipVar1 ,
View_RecipAndLoc_All.RecipVar2 ,
View_RecipAndLoc_All.RecipVar3 ,
View_RecipAndLoc_All.RecipVar4 ,
View_RecipAndLoc_All.RecipVar5 ,
View_RecipAndLoc_All.RecipVar6 ,
View_RecipAndLoc_All.RecipVar7 ,
View_RecipAndLoc_All.RecipVar8 ,
View_RecipAndLoc_All.RecipVar9 ,
View_RecipAndLoc_All.RecipVar10 ,
View_RecipAndLoc_All.DYNAMIC ,
View_RecipAndLoc_All.Download ,
View_RecipAndLoc_All.STATUS ,
View_RecipAndLoc_All.LastModified ,
View_RecipAndLoc_All.EmailAddress ,
ClientList.Client_Type ,
RTRIM(f_getRecipName(View_AssetCurrent.CurrentID, View_AssetCurrent.ProfileID)) CurrentName,
RTRIM(f_getRecipName(View_AssetCurrent.DestinationID, View_AssetCurrent.ProfileID)) DestinationName ,
RTRIM(f_getRecipName(View_AssetCurrent.OwnerID, View_AssetCurrent.ProfileID)) OwnerName ,
Signatures.Sig_Data "Sig_Data"
FROM View_AssetCurrent
LEFT JOIN Signatures
ON View_AssetCurrent.SignatureID = Signatures.Sig_ID
LEFT JOIN ClientList
ON View_AssetCurrent.ClientName = ClientList.Client_Name
LEFT JOIN View_RecipAndLoc_All
ON View_AssetCurrent.ProfileID = View_RecipAndLoc_All.ProfileID
AND View_AssetCurrent.DestinationID = View_RecipAndLoc_All.EmpID