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

    Easy Way to Update EXE to all Workstations

    One method I particularly like for the scenario where the exe is on a network share and the users run the application over the network is to use a simple launcher methodology: 1. Make the main exe that the user executes from their shortcut (or whatever) a miniscule launcher, the job of the...
  2. 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...
  3. 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...
  4. Paul Gibson

    T-SQL in vfp 8 to find same value

    ...ran my query again, I just took out the WHERE clause, for me because I only have the two different norekening values in it, as such: SELECT rnk.* FROM ( SELECT norekening, date1, date2, payment1, datediff(day, date1, date2) as difference, datediff(month, date1, date2) as...
  5. Paul Gibson

    T-SQL in vfp 8 to find same value

    ...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, datediff(month, date1, date2) as difference1...
  6. Paul Gibson

    T-SQL in vfp 8 to find same value

    ...BY norekening ORDER BY datediff(day, date1, date2) DESC) AS [Rank] FROM [zonaku] WHERE norekening = 1111125010021 ) SELECT cte.* FROM [cteWithDifferenceAndRanked] cte WHERE cte.[Rank] = 1 Obviously, doing it that way still relies on being able to use CTEs but I think that query looks...
  7. Paul Gibson

    T-SQL in vfp 8 to find same value

    ...difference, datediff(month, date1,date2) as difference1 FROM [zonaku] WHERE norekening = 1111125010021 ), cteRanked AS ( SELECT cte.* ,ROW_NUMBER() OVER(PARTITION BY norekening ORDER BY difference DESC) AS [Rank] FROM [cteWithDifference] cte ) SELECT cte.* FROM...
  8. 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...
  9. 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.
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Part and Inventory Search

Back
Top