Search results for query: *

I have created a Com+ server application in the Windows 2003 server. When I instal the MSI file in windows 2000 machine it give me error that "error Registering COM+ application". While exporting the application i have checked the option "save the application in Com+ 1 format While creating the...

Suppose i have a table with following definition. CREATE TABLE myTable (col1 Int, col2 Varchar(10)) Now I want to add one more column colX (datetime) in between col1 & col2. So the new table structure should be like col1 Int, colX Datetime, col2 Varchar(10) Previously, i was doing this by...

Hi I am running a procedure on my SQL 6.5 server (service pack 5). It is having a loop to run 1500 times. I am constantly getting following error message: ----------- Server: Msg 910, Level 17, State 7, Procedure matsitelog_trig, Line 28 Could not allocate a new object descriptor for required...

Hi all, I am here again. May be with a sily question. :-) From our project we can do two type of printing. 1. Normal ----> Which goes directly to the default printer. 2. Label ----> Which should go the Label Printer. So, i have not written anything for the normal printing. But for the forms...

Hi, I am using export command to transfer data between my VFP tables and Excel files. I am using VFP6.0 & MSExcel 2000. But it seems that export only copy 16383 rows from the VFP table. I have checked the limitation section on microsoft and it says in respect of VFP3.0/3.0b that the limitation...

I have a VFP6.0 application. This application runs perfectly under WINNT/WIN2K. But when we try to run this application in WIN9X then we experienced a strange problem. The problem arises when we follow the following sequence : From the main form we call a child form (by clicking on a button on...

Dear All, I want to zoom my report in VFP to 200%. But the Print Preview Toolbar is showing 100 as the maximum limit. I would be very thankful, If anyone can give some suggestion about this.

Hi all, I want to call a win32 api function in foxpro. The api expects a strucuture like this : ------------- hWnd long pID long pszDN long lpszTl long ulFlg long lpfnCb long lParam long iImg long ------------- I had tried to create a class and then pass that class object to this api, But of no...

My application is suddenly started taking longer time while updating sql server data. In a particular form, I am updating TABLE1 with a single record. And on TABLE1 i had a trigger on update, which again updates two more tables. I want to check where is the bottleneck. I had opened the SQL...

Hi all, I am new user to MTS. I want to use MTS as a middle layer of my vfp application and sql server. So Can any one show me path to get initiated into this process. Thanks for your replies.. in advance.

psuedocode of my program is as follows: In visual foxpro: BEGIN TRANSACTION SELECT local_cursor DO WHILE ! EOF() EXETUTE SQL_PROCEDURE 'parameter 1','parameter 2' --to update tables in backend IF ERROR() ROLLBACK TRANSACTION SHOW_ERROR_MESSAGE RETURN ENDIF SKIP -- Move...

Is it possible to get the benefits of MTS while using VFP 6.0 and SQL 6.5? I am having a foxpro client with sql back end. If we run application from local sites (where sql server is in same LAN) it is fine. But when we run it from a remote location it gets burned. I had heard about doing the...