Search results for query: *

Anyone know how to run SSIS package from VFP 9.0?

I tried with XML code and it bit slow but worked fine. Thank you so much.

I created VS project and compile it. And I tried to run test program and I got following error on line o.DoBulkLoad(0): OLE IDispatch exception code 0 from System.Data: Keyword not supported: 'driver'... Is this code VS 2008 compatible? Or do I need any changes? Thanks.

Hi Cetin, Thanks for your patient. I am still not sure about your example, do I need to cut and paste c# code in VS project and compile it and then use in test.prg? Can you please explain me?

Hi Cetin, I checked the link you sent me, but I can not figure out how to use SQlBulkCopy from FoxPro, can you please explain me in details? Thanks.

Thanks Cetin for quick response. 1 and 2 out of questions for me, since this I have to include in FoxPro application where user can do it from application menu. I will check on third option, but not sure how to reset auto id to 1 everytime. I will post back once I figure out the final...

I have couple of tables on SQL server, and I need to insert records from Foxpro tables. Every month I need to delete old records from SQL tables and inserting new records from FoxPro tables. I don't want to do it with SPT, SPT requires looping for each record and I have over a million records...

It worked. Thanks a bunch. So what was the reason I was not able to see all formula fields? Now I am able to add chart with group rate for all 12 months but how do I lable each column as month name? Sorry for ny limited knowledge in Crystal. Thanks again.

LB, Do you mean I dont need any formula? Instead I can use direct fileds? If so how? Thanks.

@JulyRate whileprintingrecords; (100 * {SalesSumm.ItemSale7})/{SalesSumm.totalSale7}; @JulyGroupRate whileprintingrecords; NumberVar nJulyItemTotal/ NumberVar nJulyGroupSale * 100; @JulyRunningTotal whileprintingrecords; NumberVar nJulyItemTotal; NumberVar nJulyGroupSale ; nJulyGroupSale :=...

I have created crystal report using version XI. I have created formula field which calculates % of two database field. Which I display in detail section. I also created formula fields to display % for the group. Now I want to add chart for each group based on formula fields for group %. But I...

OK, Thanks for the answer.

Hi LB, Sorry for not explaining in details. Here is the explaination of each column in Data: Region : Region# (1 to 5) Hits1 : Total # of hits in January Executed1 : # of hits executed from Total Hits in January Hits2 : Total # of hits in February Executed2 : # of hits executed from Total Hits...

Hi, I am new to Crystal report and just started with version XI. Here is my data Region Hits1 Executed1 Hits2 Executed2 ... upto 12 months 1 15 9 16 4 2 30 18 40 28 3 10 4 12 3 4 45 18 32 16...

There might be a solution but I can't find it. Any help/suggesion will be appreciated. I want simple report which show % of sale of one item by each month (12 month) for all my 6 regions. Our management team would like to see all regions sales by month on first page with line chart of total...

I am trying to create new report based on dbase file. Crystal document says no odbc or ole driver need for dbase file. I am trying new connection and selecting Database files, I get following error: Query Engine Error: 'No database DLL has been specified' What could be the reason?

I want to dev. several versions appl. by VFP, but I found that in W2K, I cannot get what version the computer is (i.e., English, Portuguese, Chinese, etc.)<br><br>Any one can help me ?