Search results for query: *

Hi Ken, The database is on UNIX SUN 5.8 box and I am firing query through .NET program.

Hi SQL Gurus, I have a sql query which is taking too long to execute becasue of millions of data in database. I would like to identify and kill this sql query if it is taking more then 2 mins to execute. Yes, we can identify the session and kill the session. But I dont want to kill session. I...

Hi SQL Gurus, I have a sql query which is taking too long to execute becasue of millions of data in database. I would like to identify and kill this sql query if it is taking more then 2 mins to execute. Yes, we can identify the session and kill the session. But I dont want to kill session. I...

Hi, I am trying to create project using AMG API PA_PROJECT_PUB.Create_Project. The API is running fine in the 11.5.9 version but in 11.5.10 version I am getting the following error:- Failed to create the project for Project Number E45011800000000 ORA-00001: unique constraint...

Hi Mdwyer, Thanks, you are right. But in the SO_LINES_ALL there are lots of ID's like SHIPMENT_SCHEDULE_LINE_ID PARENT_LINE_ID,ATO_LINE_ID etc. we can not go straight forward and indsert this into target system. Our stretegy is first we extract the natural key corrosponding to the ID from...

Hi, I am going to write a script to load SO_LINES_ALL/SO_HEADERS_ALL data from 10.7 to 11i. As there are lots of IDs in the table and we have to create new ids in the target system. I need help how to find the natural/descrptive key corrosponding to these Id's so that I can derive new Ids in...

I am going to wite the data conversion script from 10.7 to 11i for Sales Order. I would to know what are the changes in the schema like table name and column name. Is there any API for loading data from 10.7 to 11i. Please help me find it out. Thanks in advance. GK

I am going to wite the data conversion script from 10.7 to 11i for Sales Order. I would to know what are the changes in the schema like table name and column name. Is there any API for loading data from 10.7 to 11i. Please help me find it out. Thanks in advance. GK

NO I am not using CFFORM. Please suggest me other method. Gaurav

Hi All, I am new to ColdFusion.I have a Input box as text field. I want this field should accept numeric values only. For example : 1,2,300,90,0 etc. It should accept NULL ot Blank also. Thanks in advance. Gaurav

Hi All, I am using RH5.0 i want to mail same matter to all the user how can i do this in single hit. Help Regards GK

HI ALL I AM USING RH 7.2 WHEN SENDING MAIL THROUGH OUTLOOK EXPRESS IT GIVES ERROR...... "The connection to the server has failed. Account: '192.168.1.2', Server: '192.168.1.2', Protocol: SMTP, Port: 25, Secure(SSL): No, Socket Error: 10061, Error Number: 0x800CCC0E" I CAN RECIEVE...

Thanks clonny2 it will do......

Hi all Starting RH 6.1 gives .. Starting eth0......delaying eth0 initialization [Failed] My Ethernet Card make is DFE-538TX Regards Gk

Hi All I want to Connect New IDE hard Drie in My Existing Linux Server Red Hat 5.0. & Further i want to mount /usr on new hard drive how ican achieve this... Regards GK

Hi All I want differencr between OLEDB and ODBC connection to the database. which is best. Regards GK

Hi All i want to make a function in sql-server 7.0 that takes three parameters and return one parameter. i am presently doing like this CREATE PROCEDURE hello @p1 integer, @p2 integer, @p3 integer, @dt1 datetime OUTPUT as DECLARE @DT AS DATETIME set @dt = '1/1/00' set @dt1 =...

Hi EveryOne my question: i have a crosstab showing followong information: Target_Amt(Rs) Actual_Amt(Rs) Varience Lub Oil 100 80 20 Diesl Oil 150 160 -10 Petrol Oil 80 70 10 First Two...

Hello ! I am using export option through coding in vb ( to export crystal report to XL file) But after exporting in the XL file Report Header is coming as coloumn instead of row & repeatition of the same is occur. Regards Gaurav

hello ! i want to send multile values for a single parameter through VB in to crystal report. How i can send..... One of answer given earlier is : Report.ParameterFields(1).ClearCurrentValueAndRange and then multiple calls to: Report.ParameterFields(1).AddCurrentValue(your_value) but after...