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 Chriss Miller 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

    ...on the new server). The basic read command used is SQLEXEC(lnConn, lcCmd, lcCursor), where lnconn is a statement handle, lcCmd is a Select * from <whatever tablename>, and lcCursor is the name of the output cursor. The DSN-less connection is typically created by SQLSTRINGCONNECT(lcConnStr...
  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)

    ...Code fragments: Create dynamic range (to accommodate changes in the amount of data being placed on the worksheet): WITH loworkbook.ActiveSheet * lnFCount gives number of columns in the data range lncols = lnFCount - 1 *include column headings .Names.Add("data"...
  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

    ...; where addr.location <=2 OR addr.location is null ; GROUP BY addr.cardrecordid; INTO CURSOR tmpaddr readwrite From the resulting table, this *looks* like it will work, but will it? It's the join using <= that I'm not sure about - what's the guarantee of getting the 2nd adddress if they...
  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

    ...oExcel = CREATEOBJECT ("Excel.Application") oExcel.VISIBLE = .t. WITH oExcel .DisplayAlerts = .F. .Workbooks.OPEN ("c:\test-password.xls") *Extra line here .ActiveWorkbook.Password = "XXX" .ActiveWorkbook.WritePassword = "XXX" .ActiveWorkbook.ReadOnlyRecommended = True...
  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