Search results for query: *

Hey, Thanks all for these I have found the default trace option within SQL which gives some of the functionality that i was after however this doesn't really go into the detail that i needed. I have also found that you can script traces from profile which might be another way of going...

hmm...thanks for this :). I am coming to the same conclusion.. i have been looking through the master db to see if there are any sp's in there that would help..haven't found anyway of actually working out who is doing what tho Thanks for taking the time to reply though. I appreciate it.

HI All, We are building a application for users to make changes to the DB so we are building in some audit functionality to record who is doing what. The guy that is doing the application has been away so i was wondering whether there was any way that i can capture the log in information from...

Hi, I am confused at your response, but thank you nonetheless for taking the time to look. The code that you have highlighted is part of the set based update that is grouping by idcol etc (fair point, the other columns aren't really needed...shouldn't really be creating a problem tho) the...

HI All, After a little while out of the game i am getting back into coding in SQL, however i seem a bit rusty.. This cursor is not picking up the new @Auth code when it picks up the next @idcol of the next record in the loop can someone help me...i am sure its something really stupid but its...

cool. All seems to make sense :D Thanks again for this. Very helpful. Matt

Thanks Mufasa, I have had to slightly edit it to return the 1-23 as hours as it was putting them in the minutes, but apart from that small change it works perfectly. The : "substr('0000'||y,-4),x);" was a bit confusing. I am not sure what this is doing? I understand what you are setting...

Thats impressive. I dont really understand how it works though? I wrote code to temporarily do this and there were hundreds of lines of it! Thank you so much for this, its so much neater this way Matt

HI Everyone, I am fairly new to Oracle development having come from the world of TSQL and am struggling with the syntax slightly. I need to create a table that will find out a maximum ID from another table, then create a row for every ID from 0 - the maximum for every hour in the day. i.e...

Ignore that Lbass, I have had a play around with this, and it has worked :D Thank you very much. CC

HI Lbass, Thanks for this. That is what i am saying, but unfortunaltey I have already tried a selection of these type formulas, but they dont seem to work. Everytime you drill down the totals still appear. I need to find a way of convincing it that its not the last page, but then need a...

Hi guys, In the report footer section of a sub report I have a total based on the figures on all of the report. The sub report also provides a drill down of information contained on the main report that i want to appear at the end of the report should the user only want to see the top level...

Thanks Willif, i have done just that :D Apologies Dagon, i didn't realise that this was so important. I am truely very embarrased.I will try and stop this from now on.

Hey Mufasa (Dave of Sandy, Utah, USA), Thanks for this. This is exactly what i was after. There are a few subtle little difference with the way that the syntax is used and the error messages seem to be even less helpful than the ones thrown up by SQL!! The help pages of the program that i am...

p.s. i realise that there are errors in the logic of the above code, its just an example to give you an idea of the way in which i want to use the variables. Thanks again Matt

HI All, i am this is a very basic question but i am new to oracle syntax after 5 years of SQL and i am finding it hard to adapt. I am trying to work out how to use variables in oracle to do something similar to : declare @CompanyName char(100) declare @RMTID set @CompanyName = (select...

Thanks Dan, no other responses as yet. Thanks for the tip on the software, but i think that its unlikely that the company will purchase more software based on this one problem. I will forward the question to business objects and if still no joy i suspect the client will be told that we are not...

Hi Guys, I have a problem in Crystal XI that is very irritating. I am trying to do a conditional formula for the sort order on a Bar chart and am failing. If you run the report and then navigate into the formaula editer and create a formula then when you save and close the data changes to...

wow......thank you sooooo much for this. Your a total star :D I cant tell you how much i appreciate this....it was driving me mad

really...that would be handy. Its only SQL 2000 i am afraid. My company seem reluctant to upgrade for some reason! Thanks tho :D Matt