Search results for query: *

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

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

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.

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

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

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

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

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.

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

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.

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

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

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

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

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

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.

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.

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.

You might want to translate the error into English as most people can understans English, but few understand Hungarian. So, what does "Ez a(z) autapp01wprlvmw oldal nem talalhato" mean in English?

Exactly why I do not use long file names.