Problem with column names
783898Sep 3 2010 — edited Sep 3 2010I have named my columns for exaomple column trasanctionid as "TransactionID".But when i write a process and run the query in the process it takes the column name as all in cappital letters.Hence it gives me follwing error.
ORA-00904: "TRANSACTIONID": invalid identifier
I want to know whether there is any constraint to name columns all inc apital letters in apex.I am finding it difficult to change column name and then make changes throughout the app for it.This error has popped up many times for me and I had to everytime change the column anme to all capitals to get rid of this error.
Edited by: dwitiya on Sep 3, 2010 10:52 AM