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: *

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

    start trace without alter session

    Hi, Is it possible to start a trace without having the alter session privilege? We have a user that we have set-up to monitor DB activities for all users but we dont want to grant alter session privilege to it but we do want to allow the user to start/stop traces. We granted DBMS_MONITOR and...
  2. danmul

    Display multiple rows as 1

    Hi, I have a query that returns the last 3 salaries of employees but I want to display the results in 1 row as Sal1, Sal2, Sal3. Anybody know how to do this? My query is: select b.REFNO, s.SA02D, s.SA04P from basic b, salary_history s where b.BGROUP = s.BGROUP and b.REFNO = s.REFNO and s.SA02D...
  3. danmul

    CPU running at 100% - wmiprvse.exe eating up CPU

    Hi, I have a home PC that the CPU is running at 100% as soon as I login. The process that is causing the problem is a wmiprvse.exe process. I know that this is a windows management process and can also be a virus. I have checked the registry for entries (if it is a virus there are supposed...
  4. danmul

    problem seeing where process fails

    Hi, I can run a vb process from the command line o the server and it runs fine. when I call it from my application it fails half way. I use commands like this to view results when I run from command line Wscript.echo "Command = Did I get here " but when I run from the application it runs in...
  5. danmul

    problem running .bat on server

    Hi, Not sure if this is the correct forum for this but . . . I can run a .bat on server if I run it from the command line on the server and it works fine. If I run it from my application it fails halfway through (I cannot see wht it fails as it runs in the background). I s there a command...
  6. danmul

    Record Group too slow on forms6i

    Hi, I have an LOV using a record group that I am trying to use as to validate against a supplier ID or a supplier name. I have over 40,000 records. It was returning in about 2 seconds when I had only validate against ID. Now my first column uses concatenation for 3 columns. The query takes...
  7. danmul

    how to create n dimension array

    Hi, I can create a 2 dimension array. I tried to create an n dimension array. Is this possible? I did not get an error on creation but got an error when I tried to assign a value. Here is what I tried: type v_admin_type_record is record(v_index number...
  8. danmul

    cursor keeps jumping to first field in block on enter query

    Hi, I am using Tab Canvas in forms 6.0. I have 2 tabs which are based on one block. If I am in tab2 and click enter query, the cursor jumps back to the first item on tab1. How can I force the cursor to stay on the item it is on. Thanks, daniel.
  9. danmul

    File Type Association

    Hi, I have a script that adds a file type. My problem is that it only adds for each user. How can I run this once and it will be available for each user that uses the PC? Code I use is copied below. Any help will be much appreciated. Daniel. I have a .bat that contains this: assoc...
  10. danmul

    Can we change style of cursor in forms6i

    Hi, Is it possible to change cursor style in forms6i. I have users that are used to looking at a chunky cursor. Is this possible to change? Thanks, daniel.
  11. danmul

    read excel sheet into table

    Hi all, What is the easiest way to copy the contents of an excel sheet into a table. i am using forms 6i. Thanks, daniel.
  12. danmul

    error calling program unit

    Hi, I have a web page that I paste an excel sheet into a text area. When I click on save it calls an a program unit that uploads values into database. My problem is that if the number of characters is over 32,000 I get an error. This is a http limitation that variables cannot be over 32000...
  13. danmul

    cannot upload if char's over 32000

    Hi, I have a web page that I paste an excel sheet into a text area. When I click on save it uploads these values into the database. My problem is that if the number of characters is over 32,000 I get an error. This is a http limitation that variables cannot be over 32000 characters. Any ideas...
  14. danmul

    Script to add file type

    Hi, I have a script that adds a file type into the registry. my problem is that it needs to be run for each user that logs into the PC. Is it just as simple as an Admin user or is there another setting in the registry I need to set up. Thanks in advance for any help. daniel. Here is...
  15. danmul

    updating view from forms 6i gives ora-01733

    Hi, I have a form updating a view. All works OK until I add in a column from the view that is based on a function. I have the properties set on the field Enabled=NO keyboard navigable=NO update allowed=NO insert allowed=NO But I still get "ORA-01733: virtual column not allowed here" when I...
  16. danmul

    setting value of text area problem

    Hi, This is the code that is generated when I re-call. The value in the text area has been pasted from an excel sheet in the first form. I get an unterminated string constant error from the browser. Is there a way around this? Thanks, Daniel. <SCRIPT>document.insert.i_part_desc.value = "Part1...
  17. danmul

    limit on characters passed??

    Hi, I have a web page that I paste an excel sheet into a text area. When I click on save it uploads these values into teh database. My problem is that if the number of characters is over 32,500(around this figure, probably 37,760) the page fails. Is this because the most a value can hold 32,760...
  18. danmul

    option not showing spaces

    <option value="57742">57742 12D SOLUTIONS PTY LTD</option> Hi, Why does this not show spaces between the 57742 and the 12D? Thanks, Daniel.
  19. danmul

    trim entire column

    Hi, I have just received an excel file and I need to use the TRIM function on an entire column. I seem to be able to get it to work for a cell but not entire column. I know it's prob easy but I am new to this. Thanks in advance, Daniel.
  20. danmul

    value from function not appearing in url

    Hi, I have the url below. This is being called from the function below it. Why does it not put the value of bu_id into the url. I have tried all ways with the plus sign. http://intranet.lc.local:8000/webdev/test_xaps.load_cat?i_action=insert&i_bu_id='+bu_id' <SCRIPT>function...

Part and Inventory Search

Back
Top