Search results for query: *

Hi all, I'm new to VB and I hope you can help me with this VB script. Here is the background of what I need to do. I have created 9 VB scripts that pull information from a database and display these results into a table. That is pretty much all that the VB script is doing. What I am having...

The problem I am having is trying to transfer the technique used into my script There is one thing though. The script that I need has to round to the next highest number at a defined number of significant numbers Each of the examples I put down are rounded to 2 significant figures: e.g...

I modified the code you gave me yesterday to work with my stuff and it came out like this Select Case when round(3.14159, 3) < 3.14159 then round(3.14159, 3) + (1/power(10,3)) else round(3.14159, 3) end from dual; Sorry to be annoying you but I am still completely lost, I can't modify the...

Hi all, I need to write a script that will round a figure to the next highest number at a defined number of significant figures examples of what I am looking for are: 0.0215 gives .022 0.215 gives 0.22 2.15 gives 2.2 21.5 gives 22 215.00 gives 220 2150.0 gives 2200 2149.0 gives 2200 21500.00...

Works perfectly, thank you. I have one more that I can't get my head around if you have time would you be able to have a look at it carp?! I don't want to be greedy but if you have time i'd really appreciate it. Just leave a message if you have time

thank you very much i'll try that and report back. Thank you again

thank you very much carp, thats exactly what im looking for I hope you can help I have a very very basic knowledge of this stuff and this is way out of my range. I hope you can help

No sorry it needs to round UP to so from your example (10.456,2) the result will be 10.46 the script needs to round up the value not just round another example is (3.14159,3) would be 3.142 I hope that clears it up thats why its driving me mad if it was just a round it would br fine...

Hi all, I am new to this site and oracle sqlplus in general. I need some help, I need to write a script that will round a figure to the next highest number at a defined number of decimal places e.g. (3.2,0) gives 4 (76.9,0) gives 77 (3.14159,3) gives 3.142 (-3.14159,1) gives -3.2...