Search results for query: *

Hi, I want to delete a record from a table called File_Upload. I need to execute this sql statement from DOS prompt using a batch file. Any idea on how this can be done. The necessary user id and password will have to be passed to this bat file. Thanks and Regards Balachandar Ganesan.

Hi All, I have a table with the following details EMPID,EFFDT,EFFSEQ,JOBCODE. Now from this table, I need to find the current Jobcode and the previous jobcode for every employee using EFFDT and EFFSEQ. For example for the following rows 1000, Employee1,01-Jan-2005,1,'JobCode1' 1000...

Hi, I would like to get the list of foreign keys in a table and present the information in the following format. Foreign Key Foreign Key References Referred Constraint Name Column Name Table Name Column Name How I can...

Hi All, The SQL Server that we use does not have FullText Search installed. How do I install it and enable it? Also let me know if we can install FullText Search on Windows NT or Windows 2000. Regards Balachandar Ganesan

Hi, We have a Visual C++ project. With each release,Every developer has to build the entire application in their own PCS. To avoid that we just compiled the application in one of the PCS and copied all the folders (Including Debugging information) into other developer PCs and registered all the...

Hi All, I am trying to design the database for a bug tracker application. This is the information I am trying to model. There are n number of products in the project. Each product has one or more modules. There are some modules that are common to more than one product. (i.e) Each module(child)...

Hai All, I have a activeX control application developed in VC++ running in a Internet explorer window. I need to open a given URL in a new browser window from this application. I tried the ShellExecute() function to launch a new Internet explorer window from my ActiveX appliction (from the...

Hi, I would like to know if any one has used XSL-FO from ASP. I need to generate the PDF based on the values supplied by the user in a form. I should generate this as a PDF document using XSL-FO from ASP. Please guide me and provide me with some samples as well.

Hi, I have set the Focus to an edit box and am exiting the OnInitDialog() with the return value 0. This gives the expected behaviour of setting the focus but the cursor is not visible in the edit box util the keyboard is used. I tried using ShowCursor(TRUE) multiple times but even that does...

Hi, What should be the parameters and return type for the functions implementing the handler of an DISPID_KEYUP event in a SINK_MAP? How do we handle DISPID_KEYUP event in a SINK_MAP? Thanks & Regards, Balachandar Ganesan

Hi, I have a strange problem with tab order. From the first control, Instead of going to the second control, It goes to the toolbar(address bar) and if there are any other customized bars(Ex: google search bar) it goes there next, After that only control goes to the second control. I could find...

Hi All, We are going to migrate applications developed in VC++ running on NT to XP. If any body has done it before please share the experience. Also please let me know if there are any documents(white papers) available for NT to XP migration.

Hi, I am building an application for conducting tests online. I am highly confused about displaying the various questions and extracting the user answer. These are the requirements. Question Types are : Multiple Choice, True/False, Fill in the Blanks, Match the following. The questions can be...

Hi All, I am new to ASP.NET. Once you a user logs into the web application, I want the following details : User Id,User_Name to be accessible in all pages. However once he closes the session, the information should be lost. What is the best strategy to achieve this functionality. Regards...

Hi All, How do I handle a situation where a text file contains multiple records types . i.e if there are two records first containing customer name related details and other contains the address. I have to target two different tables based on the record type. Thanks Balachandar Ganesan

Hi, Is there any way to recover the data from the log file in Oracle 9i. Some Oracle warehouse builder related data was deleted from Oracle 9i tables. We want to recover the data from the log file. Is there any tool with which we can do it ? Thanks and Regards Balachandar Ganesan.

Hi All, I am importing data from Flat File into Oracle database using Oracle OWB. Now we would like to verify weather we have done correctly. Is there any tool with which we can test? I mean is there any tool to compare the flat file data with database table data ?. Regards Balachandar Ganesan.

Hi All, I have got the following stored procedure. PROCEDURE Rpt_Manu_Sales_Sum_Bu_Prc(v_Data_Ref_Cursor IN OUT Rpt_Stored_Proc_Pkg.Data_Ref_Cursor,START_DATE IN DATE,END_DATE IN DATE,REP_NAME IN VARCHAR2,AGENCY_REGION_DESC IN VARCHAR2 ) AS BEGIN OPEN v_Data_Ref_Cursor FOR SELECT...

Hi All, I would like to know if we can integrate Dundas Charts with Crystal Reports. Can we integrate any other third party charting control with Crystal Reports Regards Balachandar Ganesan

Hi All, I would like to know what are the popular Oracle Admin and Developer tools. Please provide me with links. I do have one more question. Oracle 9i that can be downloaded from Oracle Site, How long we can use this downloaded software ? What are the licensing restrictions. Regards...