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

    FoxPro 6.0 project migration to python

    You might want to be aware of what the forum policies are lest you get banned. https://www.tek-tips.com/pages/postingpolicies/
  2. mmerlinn

    List Out Missing Numbers of a Number Range

    Nope, not accusing you of anything. Once I saw parts of your code that will not work for me, I quit examining your code. Compared to most code I see posted, yours looks a lot like plain jane FP code, so with a little time I could probably modify it to work in FP 2.6. Sometimes when I see VFP...
  3. mmerlinn

    List Out Missing Numbers of a Number Range

    OK, Mark, this code fixes the deficiency you noted. I also swatted two bugs that I found. ********** * * Get list of good, missing, or duplicate numbers within any range * Lists number of duplicates found in test range, but not locations. * * = NUMGAPS(qTableName, qFieldName...
  4. mmerlinn

    List Out Missing Numbers of a Number Range

    Was not designed to give total dups, but ez to fix by changing two lines of code. Will post "fixed" code shortly.
  5. mmerlinn

    List Out Missing Numbers of a Number Range

    If you are talking to me, I DID answer some of your questions, but only those that I could answer. Useless trying to answer questions that I have not looked into. And no point in digging deeper than I needed to dig to determine that your code would not fly in plain Jane Foxpro.
  6. mmerlinn

    List Out Missing Numbers of a Number Range

    I expanded and turned this into the function NUMGAPS() that I can now use myself, although I did not address the array length issue nor did I address decimal and scientific notation issues. ********** * * Get list of good, missing, or duplicate numbers within any range * * =...
  7. mmerlinn

    List Out Missing Numbers of a Number Range

    Two nit picking things pop out. Did not dig further. I (Integer) is not a field option Dot notation As for the array length, I was unaware of that since it has never bitten me, but the solution is simple, do a smaller chunk at a time. In this case an array is not likely to ever come close to...
  8. mmerlinn

    List Out Missing Numbers of a Number Range

    Since it appears that none of the proposed solutions will work in plain Jane FoxPro, I came up with this which should work in all versions. Quick and dirty so likely can be improved upon. Tweek to fit your parameters. Assumes your table is named "invoices" and the field is named "invnum"...
  9. mmerlinn

    Excel to Foxpro 2.6

    Whether you stay with FPD2.6 or upgrade to VFP, you have a lot of years left to use that "dead horse." And either way that dead horse will continue to prove that it is one of the most useful and easiest to use programs ever designed for managing relational databases. $50,000 to move to a new...
  10. mmerlinn

    Excel to Foxpro 2.6

    Maybe he cannot upgrade. Or maybe why fix that which is not broken? I still use FoxPro 2.6b for the Mac because the ONLY VFP for the Mac is VFP 3.0 WHICH IS TOO BUGGY TO USE.
  11. mmerlinn

    Valid event fires when clicked outside of test box

    Ok, until I figure out why ESC is acting "erratically" in my code, I am going to use the CHR(1) method to CANCEL edits. Regardless, this change (a huge improvement) solves many of the problems I have been having with canceling edits. At least now my code is not likely to break when editing it. I...
  12. mmerlinn

    Valid event fires when clicked outside of test box

    Ok, did not know about SETting ESCAPE OFF. Will try that. I saw about property in the Hacker's Guide, but so far as I know, there is no PROPERTY function in FPM 2.6b.
  13. mmerlinn

    Valid event fires when clicked outside of test box

    Thanks for posting that - It elegantly solves a problem I have had for decades - Now I can throw away my clunky solution. However, it does not tell me where to and how to add the escape code to the buffer without causing an *** INTERRUPTED *** program error. But, if I stuff the buffer with...
  14. mmerlinn

    How necessary is an antivirus?

    Depends a lot on what system you are using. My gut feeling is that as long as you do not use your computer for CRITICAL information, INCLUDING WHEN YOU ARE OFFLINE, that you should be ok. I quit using anti-virus years ago because every one I tried would choke all of my computers, often to the...
  15. mmerlinn

    Custom format values

    So, exactly how are you displaying the data now? Numeric fields directly from your numeric data (with the resulting anomalies)? Text fields with manipulated data from your numeric data (with no anomalies)? How many screens display this data? Can you change the screens? Are you looking to create...
  16. mmerlinn

    Custom format values

    It seems to me that the simplest way would be to add 2 more columns for the text representation that you desire, then going forward fill the text columns, leaving the numerical columns empty. When you need a value, check the text column for with/without value. If it has a value, use it, but if...
  17. mmerlinn

    Anyone try using Grok AI to write FoxPro code? It actually works

    I am impressed. I told Grok to design a simple 2-box input screen without telling it what language to use. It whipped up an HTML screen with Javascript and CSS and it worked. Then I told it to recode the input screen using FoxPro 2.6 code. It assumed for DOS and it whipped out another...
  18. mmerlinn

    Opening and reading from a binary file larger than 2GB

    One of the main reasons I still use FPM 2.6 even though it is ancient. Just wish I could use it on modern equipment.
  19. mmerlinn

    VFP File Lock Issues with Windows Server

    Tripping on itself? That suggests timing issues. Try inserting some timing delays in your code to see if that solves the problem. If it does, then you will have a better idea how to attack the problem.
  20. mmerlinn

    Need to build web service, pronto :)

    It probably would have, but it is in a tiny font and grayed out. Once you mentioned it, I had to look at the page 3 times before I found the error message.

Part and Inventory Search

Back
Top