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!

  • Congratulations biv343 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: *

  • Users: zik
  • Content: Threads
  • Order by date
  1. zik

    IS IT POSSIBLE?

    We mistakenly created a new key as primary key even though we had a perfect candidate key for that. Now we want to delete that and make the candidate which is already a field on our table the primary key. Problem we did not want to delete that until is visible via erd. My question is, can we...
  2. zik

    count

    I decided to resend this thread because I was struggling making my point clear. I will like to see my output formatted like this: t.lname #Unsigned t.id t.fname t.spec t.docid Jim 91 13 eddy 15 30 This is what I have: select distinct t.lname...
  3. zik

    total count

    I am trying to get a total count of certain employees. I am using select colum1..columnN, count(*) from emp where empno = P_empno group by rollup(colum1,columnN) Say for instance there are 30 employees in dept 10, I want it like: ename dept total king 10 3 Right now I am getting...
  4. zik

    setting default date

    any time I run my report, i use date ranges. eg select * from emp where begin_date between to_date('01/01/1986,'mm/dd/yyyy') and to_date('12/30/1999,'mm/dd/yyyy'). Now, how can I set the begin_date to display at the top of the form like this: December, 1986 and then report follows? thanks!
  5. zik

    trigger not working

    I am trying to perform an action a forms field after an insert or update, depending on the situation. I have this code that is not working. Can anyone please look into this for me? I assumed it to be a pre-insert/pre-update trigger. My other problem with this code is understanding how to...
  6. zik

    deploying forms application

    Has anyone been involved in deploying dev2000 (forms, reports) application to windows (not web). If yes, PLEASE, PLEASE tell me the steps, if possible. I hear names like checkmap, oinus.msb, PRD etc. They are so novel to me that I don't even know where to start. I have developed the forms and...
  7. zik

    forms server

    to run forms and reports, do you have to have a server for the forms and reports to run on. My company is thinking about getting forms and reports but we need to know if they need server to run on. Please let me know urgently. thanks, zik
  8. zik

    Forms server - URGENT HELP

    to run forms and reports, do you have to have a server for the forms and reports to run on. My company is thinking about getting forms and reports but we need to know if they need server to run on. Please let me know urgently. thanks, zik
  9. zik

    cursor - URGENT, PLEASE!!!

    Can someone please tell me why this code is not working? CURSOR c_1 IS SELECT call, call2, call3, call4 FROM mytab WHERE ((caller = 'I') and (call_in = ' ' OR call_in is null) and (call_referrer = 'A' OR call_referrer = 'B' or...
  10. zik

    Char Versus Varchar2

    During a conversation with a coworker, I was told that it is BETTER to use varchar2(1) than to user char1(1). Can someone please shed some light into this. Thanks in advance. zik
  11. zik

    Problem with wwwroot

    Can anyone help, please! I have been trying to connect to an Oracle or Access databases using http://127.0.0.1 but I cannot get thru even though I have already created dsn using odbc. The most frustrating part is that I had someone actually get it to work for me but then my win2000 crashed and I...
  12. zik

    Data consolidation

    I have a requirement says that there three tables in different Oracle databases that need to be consolidated into one table. In order words, all data in those tables will to be moved into one table in a data warehouse set up. Can anyone give a head start on this. I am sorry that I don't have any...
  13. zik

    Table consolidation

    I have a requirement says that there three tables in different Oracle databases that need to be consolidated into one table. In order words, all data in those tables will to be moved into one table in a data warehouse set up. Can anyone give a head start on this. I am sorry that I don't have any...

Part and Inventory Search

Back
Top