Recent content by Paul Gibson

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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