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!

  • Congratulations strongm 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

    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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. Paul Gibson

    Adding and moving images in a running form

    All of the adding images and saving the position of them is fairly easy, it's all data. For example when it comes to saving you can just iterate through all the applicable controls on the form, capturing the position (Left, Top) and storing that in the manner that you require, for loading...
  11. Paul Gibson

    Generate a qr code on a report.

    This won't be the only way to do it but what we do is have a program which can be called from anywhere in the application, in a routine for generating the QR codes, or on a picture object on the report layout. For us the program is called get_qrcode, we pass in the data required to generate the...
  12. Paul Gibson

    WhatsAPP and VFP9 SP2

    OK, that was the assumption that I was going on so thanks for confirming it. You said, in your original message: so the assumption I'm making from that part, is that the ShellExecute bit of the code is working absolutely fine, the correct app is loading and within the app it's going to the...
  13. Paul Gibson

    WhatsAPP and VFP9 SP2

    There's at least another two assumptions that the code makes that I didn't mention in the initial reply. The code doesn't double-check it just assumes that nircmd.exe exists, and it exists in the path you've specified. In the "simulate typing" part the run command is built up using the...
  14. Paul Gibson

    WhatsAPP and VFP9 SP2

    I have no familiarity with this, I just happened to read it and was curious enough to reply. There are no error messages because for one, the generated code doesn't do any error checking - it is written making a lot of assumptions, the main one being that everything will work fine, no checking...
  15. Paul Gibson

    Set a TAG for a field programmaticaly

    Look at the INDEX command, for example: INDEX ON CCIDA TAG CCIDA The default order is ASCENDING so you don't need to specify that but as the help says: By default, Visual FoxPro displays and accesses records in ascending order. However, you can include ASCENDING as a reminder of how records...
  16. Paul Gibson

    settings in config.fpw

    Regarding the positioning of the window elements in the VFP IDE (Data Session, Command Window, Document View, Properties), I also like those elements to remain in very specific places which suit my habits and as others have said, the IDE will remember where you left them when you closed the IDE...
  17. Paul Gibson

    What's the difference between scan for and scan while...?

    There are many great answers so I hope I don't contradict any but one thing I'd make clear is the FOR and WHILE clauses are not mutually exclusive, I frequently use both together. There are scenarios where using both together can be beneficial. Especially if you want to reduce the amount of...
  18. Paul Gibson

    Combobox populated with data from a table

    When it comes to Comboboxes/Drop-down lists so there are so many different ways to set them up and use them. It mostly comes down to preference of how you want your UI to look and operate. Just setting them to directly use the "lookup table" or "data table" or whatever you are basing the...
  19. Paul Gibson

    Windows 11 - any problems noted?

    For us, we've supported our applications on Windows 11 for as long as it's been out and I only know of one issue that appeared to be unique to Windows 11 and that was a laggy OS problem regarding generating a file. This particular issue could have been due to Adobe rather than Windows 11 but...
  20. Paul Gibson

    Help with setting up the report (error message band 1 is too large to fit

    It takes about 5 to 10 minutes to split the details into multiple sections as I described in my previous reply. I split it up across 16 details sections, you could probably get away with only doing 3 or 4 if you wanted to but doing it in much smaller sections means that if you are printing...

Part and Inventory Search

Back
Top