Recent content by balachandar

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, Thanks for the message. I have found a way to do it.... SELECT USER_CONSTRAINTS.CONSTRAINT_NAME AS NAME, 'Referential Integrity', USER_CONS_COLUMNS.COLUMN_NAME || ' References ' || X.TABLE_NAME || '.' || Y.COLUMN_NAME FROM USER_CONSTRAINTS, USER_CONS_COLUMNS...

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...

However , In the above schema, I will be able to add a module with out belonging to product. That should not happen. Parent child relationship still holds good. AS you can not have a module with out a parent. However there are modules which belong to more than one prouduct. I want to the track...

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

Yes. Very much Yes

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.