Search results for query: *

...V_BEGIN_DATE := '01-'||V_BEGIN_MONTH||V_BEGIN_YEAR; V_MONTH_END_DATE := M_REC.CALENDAR_MONTH_END; SELECT COUNT(*) INTO R_REC.TOTAL_REC FROM NEWPORT.TRAVEL_COMP_LOG WHERE CLAIM_STATUS = 'N' AND DATE_RECEIVED >= V_BEGIN_DATE AND DATE_RECEIVED <=...

oradba101 - I don't know enough about Crystal Reports. I am guessing they are similar products made by two different companies. Actuate allows Drag and drop reporting. Connecting to a database and choosing a data source ( I use pl/sql stored procedure). Also allows the user the ability to...

thargtheslayer - this is what I am stuck on. "modify it to work for a different month" I can't figure out how to get the results I want for the last to columns in the query to work for 12 different months. I can only get it to work for a single month.

I forgot to mention that I did make a suggestion, but the higher ups shot it down, was to run a batch job either weekly or monthly to accumlate the required record count TOTALS and save this information to a table in the database. Then when the user chose to generate the report the information...

Santa Musfa - my without success options are many but I can describe a few that I have tried. The big problem is getting the correct results for the last two SUM columns OUT_PLUS_2 AND OUT_LESS_2. These are record counts of what records are outstanding greater then 2 weeks or less then 2 weeks...

LKbrwnDBA - this won't work for the last two totals OUT_PLUS_2 and OUT_LESS_2. These fields represent outstanding record count (not completed) older then 2 weeks within each month and outstanding record count (not completed) less then 2 week old within the same month this is done by using the...

I'm stumped...I have researched and tried different ways to resolve this without success. Hopefully someone can give me some ideas because I'm all out. I am trying to populate a REF CURSOR in a PL/SQL stored procedure so that Actuate 8 reporting software can access to generate a report. I can...

I didn't think that at all .... [smile] Just wanted to let you know where I was coming from. I know that I could create a different function in the NewCompClass that would retrieve data from the database based on the sorted column selected by the user but I would rather not if thats what you...

Thanks for responding. The NewCompClass sets up private variables and public properties as well as performing all database functions such as getting (GetRecords below), inserting, updating and deleting records from the Oracle database. Public Shared Function GetRecords() As NewCollection...

I am new to VB.NET. I am working with VS 2003. My issue is that I want to sort the current binded datagrid without going back to the database to obtain the records based on the new sort criteria selected by the user. Upon intially loading the datagrid was binded using a collection. Public...

Thanks.. I will try that...

...messsage ORA-28002; the password will expire within XX days is no longer appearing in the output log. I have done some research and the SQL*PLUS release notes for V 10.1 dated December 2003 states this as a known issue. How can this be corrected? The account used to perform the batch...

Thanks everyone, I signed up to learn HTML on http://webdesign.about.com. I have not started yet but it looks like they send you a weekly syllabus and give you weekly lessons to practice what you have learned. I learn better by doing not just reading. This class also will discuss XTML. Upon...

Thanks monksnake, thats what I thought. I started reading the XML tutorial on W3C schools website and after the DTD section I quickly lost the picture.

I am interested advancing my career and becoming more marketable. I would like to start developing websites. I previously developed in COBOL now I am using PL/SQL. What do you suggest I learn first HTML, XML, or some other language?

Thanks for the free download information BUT since I support a government facility we are not allowed to download unauthorized or unapproved software.

Using DOS is there a way to obtain a (line count or record count) of a .DAT file. For example if I append two files together I would like to know the resulting total record count of appended file. Thanks in advance...

Eventhough I am really not suppose to download freeware, since I am located on a government site, I figured getting a reference from someone in this type of forum was safe. Context did give me exactly what I was looking for. Thanks!

I have WINDOWS 2000 PROFESSIONAL with WORDPAD V.50 (service pack 4) software. Is there an upgrade or utility that can provide me (the line number and character position) within a file where my mouse cursor is pointing? For example: I open a raw data file into WORDPAD containing 10 records. I...

How do I stop rounding in the below CTL for the TOTAL_AMOUNT field? Tried using ZONED DECIMAL but that did not work. Tried using no datatype (as shown below) and that did not work. Fields coming in (used in adding)are loading into the table correctly. In the database table the field is defined...