Search results for query: *

Here's the scenario. I want to update a LAST_MODIFIED_DATE field in my table when only specifed fields are updated in a table and not others. So, of course, I use a trigger and I could easily hardcode each field in my trigger to something like: IF :new.field1 <> :old.field1 THEN SELECT...

I'm new to DB2 and I'm hoping someone can help me with a function or maybe suggest another way to accomplish the following: We have a Perergrine Service center app with a DB2 back-end. Peregrine stores it's multiline text boxes as an array with each line of the text box as an array element...

Beautiful, thanks a bunch

If I have a query grouped by a certain field, is there a quick way to display the sum of each field and also the total sum of all the groups like in the following example. I know how to get the group sum, but it's the SumOverAll that I'm not sure how to get. I need that in order to calculate a...

I am trying to set up my Crystal report to accept an ADO recordset, but the recordset is grouped to obtain the count of certain records. Since this new count field is not a part of the Oracle DB that my original report is structured on, I'm getting an error because it doesn't recognize the...

OK, let me see if I can explain what I'm trying to accomplish. ... I am passing a list of group id's in asp to my crystal report. So let's say I pass the following id's: &quot;299,123,356&quot; My crystal report will generate a report using the id's. No problem. &quot;Select * From table1...