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

    Based on user input go to cell

    The problem is this: I have 4 worksheets. Worksheet a contains a list of items which i will do a manual find on, when i find it and select the cell I want it to read worksheet b, column x, cell z say and read that value into the clipboard for pasting into another application. This isn't for...
  2. jaggiebunnet

    Based on user input go to cell

    hi I have this scenario, spreadsheet with 4 tabs. 3 of the tabs will have 4 columns and when a particular row, for column 3 is selected, I would like to copy the corresponding value from the other tab into the clipboard for pasting into another app. How easy would this be to do? Cheers R.
  3. jaggiebunnet

    Query to insert 300 recordsfrom one table into another

    if it is just to copy data from one table to another and the "other" table has not been created you can just use: create table other as select * from originalTable; or if it is to insert rows into an existing table then it could be a matter of building the insert statements with a sql select...
  4. jaggiebunnet

    Trouble with Timing?

    Hi I managed to solve this by following the advice on this link - if anyone else has a similar problem. http://www.summsoft.com/blogs/melodys_vsta_blog/archive/2007/08/07/using-a-messagefilter-to-avoid-ide-threading-and-timing-issues.aspx Cheers R.
  5. jaggiebunnet

    Case Changing

    Yes it is really an object - it belongs to the 3rd party library. I guess I am just trying to work out why it feels the need to change the case. The object is Designer and I am trying to instantiate one of its properties: dim myContext as Designer.Context instead when I press return I get...
  6. jaggiebunnet

    Trouble with Timing?

    hi there I have a vba app that I have tried to convert to vb net because it doesnt need to be tied to vba as it can access the library from vb - it doesnt need to update excel etc just update the 3rd party app. Anyway, I have a problem when I run the .net version I get the below error - if i...
  7. jaggiebunnet

    Case Changing

    hi thanks for the reply, I have checked them and removed and replaced the library it was referencing to make sure it was picked up ok but there is no change. The library the object is in is at the top of the non - required list and all the other object properties are capitalised correctly...
  8. jaggiebunnet

    Case Changing

    hi all I am trying to write some vba for a 3rd party application - the vba is not too bad but something has happened where one of my objects I reference, say Object B has a parameter say Value and when I type in B.Value vba changes it to B.value and my code doesnt work anyone have any...
  9. jaggiebunnet

    Good Oracle 9i Book

    have a look at the books by Tom Kyte (asktom.oracle.com) very good reading..
  10. jaggiebunnet

    tricky plsql question...

    Yep works perfect this time. Pretty cool way of doing it too!
  11. jaggiebunnet

    tricky plsql question...

    Nice. The only thing is I have tried that on my test table and it doesn't give me back the correct total. I am looking into it to see why that would be. will post any answer I get.
  12. jaggiebunnet

    tricky plsql question...

    ...jaggie@DEV>INSERT INTO T5 VALUES (1,'Feb','F','D','B') 2 / 1 row created. jaggie@DEV>SELECT SUM(cnt), MONTH 2 FROM 3 ( 4 SELECT COUNT(*) cnt, MONTH FROM t5 WHERE fld2 = 'B' GROUP BY MONTH 5 UNION 6 SELECT COUNT(*) cnt, MONTH FROM t5 WHERE fld3 = 'B' GROUP BY MONTH 7...
  13. jaggiebunnet

    Convert from signed integers to Hex

    Have you tried using to_char? jaggie@DEV>SELECT TO_CHAR(1139627840, 'xxxxxxxx') from dual; TO_CHAR(1 --------- 43ed5740 Also, just wondering, where do you get your value there from after you convert it to hex(BC12A8C0)? I have double checked this result in calculators and they agree with...
  14. jaggiebunnet

    Getting a date range for the Previous Month programatically

    em...I thought I had just said that?
  15. jaggiebunnet

    Getting a date range for the Previous Month programatically

    This should give you the start of last month and the end of last month, using sysdate as the current month. SELECT u.object_name, ADD_MONTHS(TRUNC(SYSDATE, 'mm'), - 1) start_month, TRUNC(SYSDATE, 'mm') - 1 end_month FROM USER_OBJECTS u WHERE created BETWEEN ADD_MONTHS(TRUNC(SYSDATE, 'mm')...
  16. jaggiebunnet

    Getting a date range for the Previous Month programatically

    try TRUNC(SYSDATE, 'mm') - 1
  17. jaggiebunnet

    Getting a date range for the Previous Month programatically

    What didn't work exactly?
  18. jaggiebunnet

    Getting a date range for the Previous Month programatically

    Here is the sql doing most of what you need, you should be able to customise as required: jaggie@DEV>SELECT SYSDATE, ADD_MONTHS(SYSDATE, -1), TRUNC(SYSDATE, 'mm'), ADD_MONTHS (TRUNC(SYSDATE, 'mm'), -1) 2 FROM dual 3 ; SYSDATE ADD_MONTH TRUNC(SYS ADD_MONTH --------- --------- ---------...
  19. jaggiebunnet

    TABLE ACCESS FULL - INDEX PROBLEM?

    Are your statistics up to date? You're where condition is on the occured_dt field, I don't think it needs its own index but it might be worth looking at, but check the statistics first!
  20. jaggiebunnet

    ASP call a stored procedure

    Sorry I don't know anything useful about vbscript. Only that if you can catch sqlexceptions in other languages I am 99% certain you can catch it in ASP.

Part and Inventory Search

Back
Top