Recent content by mikeopolo

Hi, thanks to you all for your comments and suggestions. The programs are all running on a server. The Excel version runs as expected (ie fast) on the old server. I've looked at the ODBC trace files and can see a completely different structure in the vendor's driver calls, but since I have no...

Hi all, I hope someone can help me. We have developed a VFP app to read accounting files using the vendor's ODBC driver. There is no support for this driver now :(. The vendor's files use a Faircom c-tree database. A client wishes to migrate to 2016 server. In testing, we found that our app...

Thanks for both helpful replies. I also think my plan is beyond the design capabilities of the pivotcache. My current thinking is to: - ignore specialcells etc. when creating the pivot table - use VBA code built in to the target spreadsheet, linked to a "Refresh" button - copy the filtered...

Hi, I'm attempting to create a pivot table using a list table as the datasource, and if I filter the source table, then I would like the pivot table to reflect the same filter. My thinking is that the source range is defined as visible cells only. Code fragments: Create dynamic range (to...

I also had issues with automation code not working at all with Office 2013, so I installed Office 2010 (Excel only) to a separate Office folder, then uninstalled it (Office 2010 that is), now the code is working once more :). Regards Mike

Some bush research on different methods gave me the following results, using mm0000's cursor data with 000's of rows added> _VFPDatatoClip - <150,000 rows, then crashed with 'insufficient memory' Arrays: <75,000 rows, then crashed with 'storage error' VFP2XL (method from Cetin Basoz)...

Just in case (0.000000001% chance) you haven't read the release notes, and you're using xfrx v14.1: http://www.eqeus.com/whatsnew/whatsnew141.html Shows the procedure to set it all up in vfp9. Mike

From www.eqeus.com XFRX is available for Visual FoxPro 5.0, 6.0, 7.0, 8.0 and 9.0. It contains its own report engine which is used in VFP 8.0 and earlier. In VFP 9.0, XFRX plugs into the new reporting architecture of the native report engine. The individual output formats as well as the...

I've discovered that customers with no addresses were not being reported, due to an error in my original select statement; so just to set the record straight and not mislead future readers: SELECT distinct CUS.cardrecordid, addr.location, cus.name, ; streetline1 as delivery1,; FROM customers...

Hi all I'm using version 9 but with "eb70" turned on. The combination of group by and distinct definitely gets me only one address each time (I was having trouble with that), and it 'seems' to pick #2 if there is one, or #1 if no #2 exists. I'm still checking to see what it does if both exist...

Hi: As a general observaton I'd say addresses cause more coding trouble than any other piece of data...here's my current issue. I have an address table which can contain up to 5 addresses per customer. The address table has a location field (1 = mailing, 2 = street, etc. I want to select...

Thank you to all four contributors, that's the solution I require! Regards Mike

I'm developing a routine to group sales transactions by week numbers, and then group those into reporting months on qa 4-4-5 basis. 1st problem: given a date value, how would I find the nearest Saturday? so: ldDate1 = ctod("31/03/2008") ldSaturday = ????? Regards Mike

This works, note extra password line added: #DEFINE True .T. #DEFINE False .F. #DEFINE xlSaveChanges 2 oExcel = CREATEOBJECT ("Excel.Application") oExcel.VISIBLE = .t. WITH oExcel .DisplayAlerts = .F. .Workbooks.OPEN ("c:\test-password.xls") *Extra line here .ActiveWorkbook.Password =...

This link may be of interest: http://www.fileheap.com/software-xl-report-for-sap-r-3-download-11494.html