thanks klegal. that is exactly what I needed.
I had tried public synonym before but it did not work.
I don't know it did not work the first time I tried it.
but it worked now.
I did not use the grant connect, resource syntax because it would not have worked anyway.
You use that when a new user...
I created a table called user_access
with user_name and password fields.
Next I created 5 users with the create user command.
When I try loggin to forms with my login info;
example zapata/egon@db00. I get connected but when I try loggin in with any of the 5 users I created, I always get
error...
I have two existing data blocks and try to add the 3rd one manuall but I cannot see in the forms canvas
Does anyone know how to make it visible?
thank you
yours truly concerned,
zapata
I created a sequence on my database table.
I was only going to implement the sequence on form level.
However, any time I try to insert records, the form gives an error that em_id (which is the sequence id) cannot be null.
Once you enter a value, it says that unique constraint has been violated...
come on guys!
there are some forms experts here who can tell me how to setup my forms application to allow a user to search with whatever they choose to search for.
Nomally, the forms defaults to id.
but the user wants to have the ability to search with either id, name, deptid or specialty.
how...
I need to be able to query my form with either id or name or deptno.
so far, anytime I try to do a search with an id or name, etc, i get message "do you want to save changes"?
if I say yes, it tells me the id already exists, which is good but when I say no, it asks me to enter f8 to...
thanks for your continued help, sem!
well, your idea of having one window is actually what I am trying to accomplish but still the way the original design was done, you have an item lets call it person_id as a database item.
then you have person_name as a non-database item.
so the idea is to...
sem,
please be patient with my threads on this issue.
According to response you gave(great by the way).
I have some difficulty putting it all together for following reasons.
If a caller calls looking for a certain information, an operator will do a search to see if that info is available. If it...
thanks pani2304. It is still not working.
When I ran your modication, it is not even allowing me to test for :
IF ((:J='A' OR :J = 'B' OR :J = 'X' OR :K = 'A' OR :K = 'B'). It just assumed the rest was null and crashed.
I modified it slightly but it works if any of these
:J='A' OR :J =...
I believe my logic is right but my bracketing is not.
My boolean requirement is that j can have an 'a' or 'b' or 'x' values as long as c or s or cont is not empty.
same holds true for k. k can have a value of 'a' or 'b' as long as c or s or cont are not empty.
any violation will throw some form...
thanks sem!
I wrote a stored procedure and the trigger to call each non-base table but I am running into "bad bind variable' error.
I am pasting the stored proc and the trigger to call.
Please see if there is something you can do to help me.
CREATE OR REPLACE PROCEDURE OTHER_NAMES (...
sem, thank you very much for responding.
Here is what my problem is.
I have 6 tables to select 38 fields from on one block.
29 of those fields come from one table.
Now I need to add the remaining 9 fields on the same block and some of those fields like I stated above have multiple values for one...
Ok, this forum i was told is great because quick responses.
Please I need u'r help.
I am creating forms and I have a field called phone_number.
What I want to do is have the phone form populate phone_number fields 3 times and caller's firs_name(caller1), madain_name(caller2), nick_name(caller3)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.