Search results for query: *

Is there a way of disabling the running totals in an excel pivot table ? Pivot ----- Sum of Count Total MM a 30 MM Total 30 --> Not Required PP a 10 d 10 PP Total 20 --> Not Required RM a 50 d 30 RM Total 80 --> Not Required Grand Total 130 Data (to create above pivot)...

I am exporting a grid view to excel using the the code as below; using System; using System.Data; using System.Configuration; using System.IO; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using...

How can I set a string as follows string mm="amt (€)"; ? When I display I am getting amt (€) thanks for any help.

I need to load a date as a constant into a table. I tried; LOAD DATA APPEND INTO TABLE "HLR_OWNER"."FOR" FIELDS TERMINATED BY ',' (MS, IM, Filedate "to_date('20090309','YYYYMMDD')" ) but I get; Record 1: Rejected - Error on table "FOR", column FILEDATE. Column not found before end of logical...

I need to pass a parameter having an * representing a list of files >touch mm1 >touch mm2 emacs tt.ksh FF=mm* echo call $FF >chmod u+x tt.ksh > ./tt.ksh call mm1 mm2 How can I display call mm* ? thx

I have a method public List<string> getMList() { List<string> listM=null; listContracts.ForEach(delegate(Cobj contract) { listM.Add(contract.M); }); return (listM); }...

Using Visual Studio 2005, c# I have in Source view; <td style="width: 193px; height: 31px;"> Name </td> <td style="width: 327px; height: 31px"> <asp:TextBox runat="server" ID="txtName" AutoPostBack="true"...

Exporting to excel (VS 2005 .Net c#), I am having problems with the €. 10660 56660 € 158,58 € 158,58 is becoming 10660 56660 € 158,58 € 158,58 It is the footer of a grid, extracted using if (gv.FooterRow != null) {...

I have a script that loads a huge array. Kind of Declare PROCEDURE pLoadArray (vaCustcode_num IN OUT vacustcodednno) IS iarraysize INTEGER := 3000; i INTEGER; vErrorMessage VARCHAR2 (256) := ''; BEGIN FOR i IN 1 .. iarraysize LOOP...

I need to use in xls v2003 the option; Edit --> Fill --> Series for some reason Series is shaded and cannto be selected. Down , Right , Up, Left and Justify are not shaded. If I start a blank worksheet it works so I am having to make series on a blank worksheet and paste them in. Any help...

Hi all, I was wondering if a way of doing select * from table name where column in array (); without looping as below; for i in 1 .. 100 loop select * from table name where column_name=array (i); end loop; which would mean retriving the values one by one which is not so good as the...

Is there an easy way of checking if a date is in the format YYYYMMDD ? I have a script that takes a date as input and need it to exist with error in the case of an invalid date. eg >check_report 20070788 ERROR invalid date thanks

Hi all, is dbverify not designed to handle temp tablespaces ? As below it works on system but will not accept a temporary tablespace. thanks C:\ora_920\oradata\IMSII>dbv file=SYSTEM0.DBF blocksize=8192 DBVERIFY: Release 9.2.0.1.0 - Production on Thu Apr 5 10:28:31 2007 Copyright (c) 1982...

Can any of you supply me with IZ0-032 study materials. Testking or any other is fine . Your help is appreciated Thanks

I am trying to run on a PC based Oracle installation the command below. I think it fails if I don't have enterprise edition. How can I check ? SQL> alter system set log_archive_dest_1='location=c:\temp', mandatory, 'reopen= 200'; alter system set log_archive_dest_1='location=c:\temp'...

I need to load a file into a table knowing that there are some duplicates on a column having a unique constraint. I set -m but it still exiting without loading the non duplicate rows. Any ideas how I can get bcp to load the non duplicate rows ? H:\>bcp nevent.dbo.nrocess in...

I have tried "C:\PROGRAm files\MICROSoft office\OFFICE11\OUTLOOK.EXE" /RegServer C:\PROGRA~1\MICROS~2\OFFICE11\OUTLOOK.EXE /RegServer from the run command but get 'The command line argument is not valid. Verify the switch you are using ' Any ideas ?

I am calling an excel macro by simply doing; START C:\auto\prog\macro_~1.xls I now need to pass the name of the database as this is a variable. START C:\auto\prog\macro_~1.xls db_name How would I change the macro to pick up the name ?

I am running a select count(*) query from an oracle database. It the count is greater than 0 I carry out further action. On executing Set oQt = ActiveSheet.QueryTables.Add( _ Connection:=sConn, _ Destination:=Range("a1"), _ Sql:=rSQL) oQt.Refresh I get...

How can I start to use OraDatabase in excel VBA ? Dim OraDatabase As OraDatabase gives user type not defined. I have no options to add in in the add-in Manager. thanks