Recent content by Paul Gibson

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

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

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

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

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

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