Search results for query: *

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

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.

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

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.

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

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

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

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

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

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

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.

Try this (I changed some of the data just to show 2 months) jaggie@DEV>CREATE TABLE T5 (pk NUMBER, MONTH VARCHAR2(10), fld2 VARCHAR2(1), fld3 VARCHAR2(1), fld4 VARCHAR2(1)) 2 / Table created. jaggie@DEV>INSERT INTO T5 VALUES (1,'Jan','B','C','D') 2 / 1 row created. jaggie@DEV>INSERT...

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

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

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

try TRUNC(SYSDATE, 'mm') - 1

What didn't work exactly?

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

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!

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.