Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. zapata

    table access

    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...
  2. zapata

    table access

    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...
  3. zapata

    Creatings data block manually

    I have figured it out. thanks, z
  4. zapata

    Creatings data block manually

    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
  5. zapata

    sequence numbers URGENT!!!!!!!!!!

    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...
  6. zapata

    insert new record and query

    You just solved the problem! thanks lewisp!!!
  7. zapata

    insert new record and query

    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...
  8. zapata

    insert new record and query

    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...
  9. zapata

    forms development

    sem, you have been a professional and great help. thank you for your time and helpful hints and tips!
  10. zapata

    forms development

    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...
  11. zapata

    forms development

    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...
  12. zapata

    bracket error

    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 =...
  13. zapata

    bracket error

    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...
  14. zapata

    forms development

    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 (...
  15. zapata

    forms development

    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...
  16. zapata

    forms development

    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)...

Part and Inventory Search

Back
Top