I have a textbox wherein multiple Id's of 4 digits can be entered separated by commas and I can enter emp id and emp id or mgr id and mgr id at any point in time and should throw an error if I enter an emp id and a mgr id at the same time. Iam using this query below and if the count is greater than 1, then I need to show an alert message saying that it is an invalid entry.
ENGINE oracle SET DEFAULT_CONNECTION instance1 SQL SQLORA PREPARE SQLOUT FOR select COUNT(distinct(title)) from (select distinct title,type from table1 where id in ('ABCD','BCD1','CDE1')and title is not null ); END
This is really urgent and please help me on this.
Regards!This message has been edited. Last edited by: info4pal,
November 24, 2014, 08:16 AM
November 24, 2014, 08:44 AM
Please help me on this.
November 24, 2014, 08:53 AM
On a different note, I've noticed that many of your recent requests are of a "Very urgent" nature. Focal Pointers are very helpful, open to share their experience and regularly go to great extents to illustrate approaches and techniques (I've learnt lots from them) but as with many other forums' supporters, are not in the business of solving someone else's "Very urgent" needs as they have their own to deal with. I would advise you to get in touch with IBI Tech Support in order to get the kind of priority help you need in situations like these.