Recent content by Kurjo

Hi Olaf and Mike - thanks for the response. I did not meant to say 'ERROR' when executing SQLEXEC, but I was under the impression that I should get -1 when there is nom rows are updated. Any way it was kind of misunderstanding. Anyway I applied Mike's suggestion using ROWCOUNT and it is working...

I am using VFP9 and try to update SQL 2008 R2 table using SQLEXEC. In my program I use the below code to update the sql table; lcSqlsting ="UPDATE [cdswms].[dbo].[ITEMS] SET [ORDID]='454879',[SEQ]='2',[QTYORD]= 3024,[QTYRES]= 3024,[QTYALL]= 3024,[QTYSHP]= 3024 WHERE SQLROWID =...

Thanks for the posing. I saw some of these codes in the oOO website. But none of these help my need. I need to execute a OO macro by passing some parameters. Since we can manipulate OO documents from VFP I have a confidence that we can do that just like MS Office. So I am still searching the...

I was going through openoffice.org website. There lot of articles and samples to automate OO, but a very few related to Visual Foxpro. I can create new OO documents or open existing OO documents from VFP, but I did not find a way to run a Macro by passing parameters. Borislav Borissov have...

I am using Microsoft Excel for all our reporting needs which is run from Visual Foxpro application - using automation. This is how I call the excel and run a macro to format or to do any other changes in the report. ocMacfile = " macro file name e.g c:\macros\testreport.xls " ocMacsub = "sub...

Thanks guys. Looks like I got enough info to work with.

I am looking for the formula for amortization table. The prameters will be Loan amount, intrest rate and term.

Does anyone know the formula to calculate mortgage payment. I know that we can do it in Excel easily, but I want to get the formula to put it in a VFP program. Thanks

I solved my issue as follows: With this .day=day(date()) .year=year(date()) .month=month(date()) endwith If we assign the month value at the end it takes. I hope it will help.

I also got this error but I am not sure how to resolve this. I get this error in the init event of the Olecontrol I set the value of the control as follows: ** ldStd is a variable with todays date With this .day=day(ldStd) .month=month(ldStd) .year=year(ldStd) Endwith

Stella740pl, The link you have given does not exist. Can you please verify it. Thanks.

Mike Lewis, I tested SP2 couple of PC with XP and all are giving the same issue and I am going to resintall the VFP9. I have not seen any reliable solution to fix otherwise. If anyone have done so please post it so that those who installed SP2 can fix it. Thanks

Do not install VFP9 service pack 2 on XP machines. It will give you Fatal error when you run the exceutables.

Thanks Mike. Kurjo

Hello, I searched the forum but I could not find one that suits my need. How to create a menu programaticaly in VFP7 using a table for menu items? What type of items need to be created in the table? Any help or FAQ ref is greately appreciated. Kurjo