Tweet
Hi,
Situation:
We have a custom windows where by this will prompt the user to create a new oracle service or use a default which will then be assign to a custom variable e.g. %ServiceName%. We will then query the exsiting OracleService%ServiceName% to ensure that the service does not already exist.
Problem:
The problem comes when the user enter a value in small caps e.g. demodb and when we do a query for existing services OracleService%ServiceName% even if there is a service by the name of demodb e.g. OracleServiceDEMODB setup factory will not report this as a duplicate. It only works when the user enters demodb in caps DEMODB if not it will by pass this validation.
Question:
Does anyone have any ideas on how to solve this ? Thanks in advanced for any help offered.
Situation:
We have a custom windows where by this will prompt the user to create a new oracle service or use a default which will then be assign to a custom variable e.g. %ServiceName%. We will then query the exsiting OracleService%ServiceName% to ensure that the service does not already exist.
Problem:
The problem comes when the user enter a value in small caps e.g. demodb and when we do a query for existing services OracleService%ServiceName% even if there is a service by the name of demodb e.g. OracleServiceDEMODB setup factory will not report this as a duplicate. It only works when the user enters demodb in caps DEMODB if not it will by pass this validation.
Question:
Does anyone have any ideas on how to solve this ? Thanks in advanced for any help offered.