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. 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...
  16. Paul Gibson

    Include non-foxpro EXE within Foxpro EXE

    As Griff says, I think you can embed anything inside a compiled VFP exe. The project has the "Other" tab and the "Other Files" section for anything that doesn't fit in any other sections. I think you can probably put absolutely anything (within reason) into that section. I only say "within...
  17. Paul Gibson

    numeric equivalent of space() in select

    I'd say try it, plus read the docs/help as well but to answer your question CAST needs a value to cast (convert), so you can't just leave it at nothing before the AS or you'll get a syntax error. CAST isn't too picky about what you feed it as long as the source can be easily converted into the...
  18. Paul Gibson

    numeric equivalent of space() in select

    Assuming that you are using a version of VFP that supports it, you can use the CAST function: Select custno, ; Space(3) As Type, ; Space(10) As bill_stat, ; Cast(0 As N(5,2)) As numbs ; From test123 ; Where Resto = '5103' You could use cast for the strings as well if you...
  19. Paul Gibson

    Can NOUPDATE prevent a DBF corruption

    100% agree, it is my biggest regret in the main VFP application I manage that the previous developers didn't leave any hope for ever migrating to a different database, short of completely rewriting the application from scratch and that's not really possible because the application is gargantuan...
  20. Paul Gibson

    Can NOUPDATE prevent a DBF corruption

    I agree with Chriss in that it seems fairly redundant for the specific purpose you are describing but also be aware that if you aren't 100% certain that the table you are opening is only ever read from and you start to open it with NOUPDATE then you are also introducing an extra potential for a...

Part and Inventory Search

Back
Top