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 Shaun E 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. C

    Chilkat v11

    That's what google tells me. It would be great, if you give more details about how you used FindCert to see why things went wrong for you. This is Chilkats own example of using FindCert: https://www.example-code.com/foxpro/certStore_find_by_sha1_thumbprint.asp If you use Bill Andersons...
  2. C

    How to supply filename when doing SET PRINTER TO NAME "Microsoft Print to PDF"

    Thor is a tool manager that handles installation for many add ons that are offered under the roof of VFPX on github, see https://github.com/VFPX/Thor It's the first thing to install to have most other VFPX extensions managed in the VFP9 IDE.
  3. C

    How to supply filename when doing SET PRINTER TO NAME "Microsoft Print to PDF"

    FoxyPreviewer documentation: https://www.foxypreviewer.com/p/foxypreviewer-documentation.html And that object has properties, a lot of properties, for settings. For output type, name, etc. Regarding PDFCreator, I think it has more and better options about the output size/quality, as you can...
  4. C

    How to supply filename when doing SET PRINTER TO NAME "Microsoft Print to PDF"

    1. Yes. 2. See https://stackoverflow.com/questions/69169267/how-to-skip-choosing-folder-in-microsoft-pdf-printer/69169728#69169728 There are simpler options with other PDF printers like Bullzip PDF printer or PDFCreator 3. Depends very much on your needs. One more recent option is...
  5. C

    Searching ACTIVE-X for video capture with time-Shift

    Just a thought about how you can offer timeshift, even if a video recording OCX or DLL only allows recording or playback, not both at the same time: You record in short chunks, maybe only 1s each and then work with these, the only downside is that you have to wait 1s for being able to access...
  6. C

    Searching ACTIVE-X for video capture with time-Shift

    Timeshift has multiple meanings, could you clarify what feature you need. Timeshift sometimes is referred to prerecording up to a maximum length so when you press record you can choose the recording to begin up to that buffered length earlier, i.e. you can wait for something to happen and then...
  7. C

    List Out Missing Numbers of a Number Range

    Thank you for that kind and detailed feedback. Re the brute force code: Be aware that a) you will be recognized as a big mind in FoxPro if anyone just looks into the FAQ section of this forum. And b) beginners like dylim will therefore take for granted your code will be fine, maybe prefer it to...
  8. C

    List Out Missing Numbers of a Number Range

    I'd be interested, too. Just one point is, this is not just any set not in another set, you look exactly for +1 of all the numbers you have and you also expect most successor values to exist. Plus it's a special comparison with two equally large sets, as apart from the shift +1 it's a self join.
  9. C

    List Out Missing Numbers of a Number Range

    Well, the expression field NOT IN (query) actually means finding a set not in another set, just because the first field is a single field, it's not a single value, it's all the fields values in a subquery, so it's a set comparison. The best thing you can do is seeking all values in the other...
  10. C

    List Out Missing Numbers of a Number Range

    Of course, but even if you see them, you see them with the deletion mark, that's not rendering it wrong. SET DELETED ON is a standard setting in my IDE, unless I explicitly need to see deleted records, and it's recommended in an EXE, unless you don't want to be able to delete records so the...
  11. C

    List Out Missing Numbers of a Number Range

    MarK, I should have added how to interpret this and why this makes sense: If you have a missing 1 in your data, or any number of low values up to N, then this (0,0) will end up being 0,N-1 and whether you take 0 as non used or used number, you'll now the ap at the start of data with that. If...
  12. C

    List Out Missing Numbers of a Number Range

    Oh, I thought you were accusing me of nitpicking your code, while I was having questions about almost all lines of my code in conjunction with legacy FoxPro, blame me. You don't want to dig into it, okay. It's just a pitty your code is so brute force, that it hurts. I'm used far better code from...
  13. C

    List Out Missing Numbers of a Number Range

    Too bad you don't answer any questions. Well, so be it.
  14. C

    List Out Missing Numbers of a Number Range

    That's true, there's a lot of articles about any topic, though.
  15. C

    List Out Missing Numbers of a Number Range

    In general: Google, obviously. Just search whatever you search and add VFP as keyword in front. Tamar's site: http://www.tomorrowssolutionsllc.com/ Doug Hennigs blog: https://doughennig.blogspot.com/ Rick Strahl: https://weblog.west-wind.com/ Rick Schummer: http://www.rickschummer.com/blog/...
  16. C

    List Out Missing Numbers of a Number Range

    Since I know you're using MySQL, I thought it would also interest you. Besides, FoxPro whitepapers exist for very many topics from Tamar Granor, Doug Hennig, Rick Strahl, Rick Schummer, to name just a few.
  17. C

    List Out Missing Numbers of a Number Range

    Sidenote: Tamar Granor write a paper on how to use SQL for solving some general problems, VFP SQL, MSSQL and MySQL, too. Filling in missing values is one of the paragraphs, though it would be harder to adjust to your situation, it's worth mentioning, as it also includes the database server...
  18. C

    List Out Missing Numbers of a Number Range

    mmerlin, As you say yourself: "Quick and dirty so likely can be improved upon." So I won't address that. Just one thing: In FoxPro even up to version 8 an array can at max be 64k items. But could you point out what doesn't work with RELATION in "plain" FoxPro regarding my RELATION solution...
  19. C

    Excel automation pastespecial getting OLE exception

    Glad you got it working. I wonder if it's just the move to Paste instead of PasteSpecial that made it work. PasteSpecial gives you options like only pasting values, only pasting formats, only pasting formulas or some combination of these. That definately doesn't work. No, your code was already...
  20. C

    Excel automation pastespecial getting OLE exception

    You first Copy the Source Range, then PasteSpecial. You have both Workbooks in the same Excel Window through the automation. As those two boxes are checked, it should work. Unless the opening of the d:\model.xlsx fails, becuase it's already open in another Excel process you may have used...

Part and Inventory Search

Back
Top