Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: anuktac
  • Content: Threads
  • Order by date
  1. anuktac

    passing parameter to a query

    HI, I am really VB challenged. I am hoping some of you can help me. I am writing a Macro from Excel which simply executes a query with one parameter dynamic: With ActiveSheet.QueryTables.Add(Connection:= _ "ODBC;DRIVER={Microsoft ODBC for...
  2. anuktac

    How to specify a delimiter in a input # function

    Hi, I need to get a list of variables using the imput # function from a file having fields separated by "~". Does anyone know how to do this? Input #1, Sac, Sac_Desc, District, Site, Time_Period, Call_Type, Call_Group, No_Of_Calls, Revenue, Duration, Dummy The above are the list of variables...
  3. anuktac

    help with regexp

    Hi I have a rather complicated pattern matching code which I am not able to figure out. open (LU, &quot;> lookup.txt&quot;); open (NONLU, &quot;> lookup.rej&quot;); open (WISLU, &quot;wisdom.qsl&quot;); while (<WISLU>) { if (/n01/) { if...
  4. anuktac

    excel 2000 charts on pivot tables

    Hi all, Is there a way to create charts (say, line charts) in Excel 2000 based on Pivot tables, but which won't be pivot Charts? I want simple charts (Like it used to be in excel 97) taking its data source from a Pivot Table. -Anukta [ponytails]
  5. anuktac

    Problem with chart object in Excel 2000

    Hi all, I have a bit of code for drawing a chart using a macro. This is a part of an Application we have. The code is x=0 y=0 width=750 height=300 Set co = Sheets(Chapter).ChartObjects.Add(x, y, width, height) co.Chart.ChartWizard Source:=Worksheets(Chapter_2_1).Range(&quot;A32:I92&quot;)...
  6. anuktac

    Submitting a form to a different frame

    Hi, I have a page, which consists of a top frame, and two side-by-side frames at the bottom: <HTML> <HEAD> </HEAD> <FRAMESET ROWS=&quot;30%,70%&quot; BORDER=0> <FRAME SRC=&quot;/BusinessReview/html/br_top.html&quot; NAME=&quot;DisplaySite_frm&quot; noresize scrolling=&quot;no&quot;>...
  7. anuktac

    Compiler failed to execute error

    I am on Actuate version 6.0 SP1. Whenever I try to compile a report i get an error &quot;Compiler failed to execute&quot;. Any ideas what causes this? -Anukta c.
  8. anuktac

    Complicated SQL Query

    Hi, I have two tables SITE_MASTER and MODIFIED_SITES. The structures are as follows: SITE_MASTER --------------------- site_no varchar2(8) primary key, adress varchar2(50) same for MODIFIED_SITES. My query should be like this: select site_no,address from SITE_MASTER if there is no matching...
  9. anuktac

    Getting the first 30 rows for each combination

    Hi, I have a really huge table (CALLS_DATA) which has 584 million records. The table has a non-unique b-tree index on (district,site). This is what the table looks like: district, site,call_ designation,calling_number,called_number, call_charge, call_duration I have to find the top 30 called...
  10. anuktac

    PL/SQL large select &amp; update

    hi guys, I have a problem with a select and update on a large table (around 1.7 million rows), My table, which is called intersite looks like this:(I have separated the columns by a '|') INTERSITE TABLE ------------------------------- calling_site|called_site|no_of_calls|b_2_a_no_of_calls| A...
  11. anuktac

    Problem with auto-execution of DBMS_JOB

    Hi, I have a dbms_job set up to run every sysdate+(1/24)/25 interval. However, it does not get picked up automatically, even when the scheduled time (next_date and next_sec) have gone by. However, if I manually execute the job, then it completes successfully. Looking at the alert log, I find...
  12. anuktac

    Alter TBS read only waits for end of all sessions

    We have a daily batch that alters a tablespace to read only, then takes backups and puts it back to read-write mode again. The problem is, as long as there are users logged on to this database (even though they are simple select statements and accessing objects from other TBS), the alter...
  13. anuktac

    VBA runtime error 13 within error handler

    Hi, I have a function that looks like: Sub Get_Calls_Data_Build_xxxyyy(Appendix_A, In_file, No_of_Rows, Append_File, Template_Type) Dim killfile2 As String On Error GoTo File_Not_Found killfile2 = ThisWorkbook.Path & &quot;\SomeErr.log&quot; 'Check that file exists If Len(Dir$(killfile2)) > 0...
  14. anuktac

    Difference between Cumulative and incremental exports

    Hi, I am trying to find the difference between cumulative and incremental exports. From their definitions, they seem to be doing the same thing. Is there anything that I am missing? -Anukta [ponytails]
  15. anuktac

    &lt;b&gt;Excel Pagesetup property causing performance problem&lt;/b&gt;

    I have a VBA Excel application (Office 97) that uses a function repetitively maybe 12-13 times. This function uses the pagesetup property to format the pages. I have noticed that it is very slow, and the time taken to run the macro cumulatively adds up. When I use the pagesetup property, it...
  16. anuktac

    Starting with Excel-VBA

    Hi, I have never worked in VBA (though I know VB). But recently I have been given the responsibility of maintaining an Excel application which has been written in VBA. I am having trouble understanding the code, because only way I can see the code is when the application encounters an error, and...
  17. anuktac

    Problem passsing a condition to SQL script

    hi, I am having a problem regarding passing a flag/value to an SQL script. I am writing a tool that creates a DAT file from a table by selecting all its data. If a CTL(control file) exists, then it executes a UNIX shell script (unload.sh). If a CTL file does not exist then it executes an SQL...
  18. anuktac

    Where is the repository Located?

    Hi, I am new to Business Objets. If I want to know which database is the Repository in (which schema & database), how do I find out? I have access to the Supervisor module, though I am not the General Supervisor of the Repository.
  19. anuktac

    Using a prompt at the universe level

    I am new to Business Objects and I am designing a universe in which i have to prompt the user for a date & category every time he tries to run a report from this universe. Date and category are dimension objects. The user need not select date & category in the query panel while running the...

Part and Inventory Search

Back
Top