Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mikeopolo

    ODBC read on 2016 server is very slow

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

    ODBC read on 2016 server is very slow

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

    Synchronise pivot table with filtered list table as source (Excel automation)

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

    Synchronise pivot table with filtered list table as source (Excel automation)

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

    Excel automation

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

    Not clear on exporting to XLSX format frm VFP9

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

    XFRX w/ VFP9 (or VFP7)

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

    Integrating XFRX into VFP5

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

    How to select nth (or below) address record

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

    How to select nth (or below) address record

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

    How to select nth (or below) address record

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

    Find nearest day of week

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

    Find nearest day of week

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

    Working with Excel thru Fox Pro code, PASSWORD

    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 =...
  15. mikeopolo

    Anyone ever integrated VFP frontend with SAP

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

    How to: Merge more than one record and the memo field

    Hello Lee Not sure why you get that error, but all I am doing is creating a blank memo field, so you may know other ways to do that. Regards Mike
  17. mikeopolo

    How to: Merge more than one record and the memo field

    Here's an idea (developed in vfp9): I have a cursor which holds transaction lines. This code sums the line values into one field, and in the second step gathers all the transaction line descriptions into one field: && step 1 - index source cursor and group by transaction SELECT tmptable INDEX...
  18. mikeopolo

    VFP EXE software copy protection

    Take a look at Software Passport/Armadillo (www.siliconrealms.com) - also not cheap but very effective.
  19. mikeopolo

    Random data changes VFP database on W2000 server

    Thank you; I am not developing this payroll app but I am writing reports with a VFP report writer against it. I should have said so in the beginning. The users were in the habit of editing several records then commiting the changes, and we thought that might be the cause. But now they are...
  20. mikeopolo

    Random data changes VFP database on W2000 server

    Thanks, I would need to refer this to the application developer for their comments, will advise.

Part and Inventory Search

Back
Top