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!

Recent content by Paul Gibson

  1. Paul Gibson

    Slow excel

    100% agree. Coverage logging isn't a always catch-all, silver bullet solution, especially when interacting with external components. It can be an invaluable tool in many scenarios but it can very occasionally report that a line or function that you think it taking an extremely long time...
  2. Paul Gibson

    Slow excel

    I think you are going to struggle to get a comprehensive answer from here because it's going to be extremely difficult, from our end, to replicate your scenario since you are using an OleBoundControl. Your code shows you are appending the OLE object from a file (path) stored in the variable lcF...
  3. Paul Gibson

    T-SQL in vfp 8 to find same value

    My last query still only pulls one record "per group" even if all the days differences in their data set equals zero. That's the point of using the ROW_NUMBER() OVER(...) column to rank. To prove this, I took you sample and made a new group for norekening = 1111125010022, where every single...
  4. Paul Gibson

    T-SQL in vfp 8 to find same value

    I'm a bit dumb sometimes ;) Obviously, the easiest way to do that without a CTE and it's still fairly clear, is to just encapsulate one query inside the other, as such: SELECT rnk.* FROM ( SELECT norekening, date1, date2, payment1, datediff(day, date1, date2) as difference...
  5. Paul Gibson

    T-SQL in vfp 8 to find same value

    A small refinement to my previous suggestion is that if you don't like the two-CTE solution, I realised it would be fine to merge the two CTEs into one, which makes it look like this: WITH cteWithDifferenceAndRanked AS ( SELECT norekening, date1, date2, payment1, datediff(day, date1...
  6. Paul Gibson

    T-SQL in vfp 8 to find same value

    I'm not 100% clear on what you are trying to achieve as you've not described your aim of the SELECT. My guess is that you are attempting to a) calculate the day differences and the month differences and then b) pull out just the row where the day difference is the largest per norekening. If...
  7. Paul Gibson

    Properties sheet Visual Promatrix/FoxPro

    I replied to you on the other thread that you made, the one with the slightly different title but essentially the same question. What you are describing would likely be the behaviour expected when you've ticked "Non-Default Properties Only" on the properties window context menu. I suggest...
  8. Paul Gibson

    Properties missing from properties sheet

    Have you got the setting "Non-Default Properties Only" ticked on the context menu for the properties window: From what you've described it sounds like you just need to toggle that.
  9. Paul Gibson

    png file not displaying in image control

    I know you've said it now works but when I see code that is directly referencing paths then I wonder if it is necessary. I try to stay away from referencing paths as much as possible and only go there when it really is unavoidable. That can depend on what kind of resource you are referencing...
  10. Paul Gibson

    How to supply filename when doing SET PRINTER TO NAME "Microsoft Print to PDF"

    Just regarding the PDF printing, I'll answer your first two questions: 1. Yes you can do that, I don't think it's going to be your best bet for automatically creating PDFs from Fox without relying on users to manually specify the filename using the prompt though. I'll expand for #2 2. I don't...
  11. Paul Gibson

    Class definition EXCEL.APPLICATION is not found.

    VFP applications can definitely automate the 64-bit version of Excel, mine is 64-bit and automates fine from VFP applications, where the starting point is that same CreateObject("Excel.Application") function call. Whether the CreateObject("Excel.Application") function call works is entirely...
  12. Paul Gibson

    Extracting an Address from a Postcode input

    One potential solution is to use a different third-party provider, this can greatly simplify things for you but the downside being that you'll almost certainly have to pay the third-party for the privilege. That'll likely be a per-request charge or a recurring time-based charge, like an annual...
  13. Paul Gibson

    Extracting an Address from a Postcode input

    Also, I spotted the following at the docs link: https://developers.google.com/maps/documentation/places/web-service/search-text#maps_http_places_textsearch-txt This is for the formatted_address property that you are trying to extract from the JSON, for the UK: So if you are getting a valid...
  14. Paul Gibson

    Extracting an Address from a Postcode input

    I can't test your code without a Google API key and I don't have one to hand so I am getting an API Key error but if we assume you are not getting the API Key error, what are you getting in the ResponseText property? Are you saying it's just empty? The code you've written for extracting the...
  15. Paul Gibson

    delete having more than 1 count

    You've just said "having an issue", but haven't described what the issue is. More details will provide more information to those attempting to help. As the other people who've responded have suggested you are using the HAVING clause but haven't used GROUP BY, this isn't completely invalid but...
See more

Part and Inventory Search

Back
Top