Search results for query: *

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

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.

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

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

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

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

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

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

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

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.

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

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

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

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

Yes, in this case it would be very omissive to not make use of RELATION to the next number as a very nicely working concept. Indeed the second part could also be done with workareas ordered descending and a relation to Invoice-1 instead of Invoice+1. Because that finds all gap ends and you then...

...is Invoices.dbf and the invoice field and index tag both are named Invoice, then this will do it best: Create Cursor Gaps (iGapStart I, iGapEnd I) *Insert Into Gaps Values (0,0) && optional for catching the gap of Invoices from 1 to Min(Invoice)-1, when Min(Invoice)>1 Use Invoices In 0 Order...

I agree. When you have no experience with any framework it's not a good time to begin with something that's unsupported by the framework developers, as good as reviews and testimonials are. Currently, the best thing you can do to extend native VFP is to get everything from VFPX that fits your...

I don't have hands on, but the names Qry01.02.03 suggest to me they are not tables, but views - queries. A query is just that - an SQL query. It has no data and if Access uses indexes, then only temporary. If you query data, to index it and then use the index to only fetch the data you actually...

Upfront: Whether an object releases does not depend on whether you set an object variable to NULL or release it, an object has a reference counter and is released only if that counter goes to 0,. So in a case you have 2 references on an object you could set a variable referencing it to .null...

The bad thing about it is that you can't use NODEFAULT consistently in any case you want to prevent base behavior, for example the form Load and Init reacts by not running the default behavior of actually creating and initializing a form instance by RETURN .F. instea. NODEFAULT has no effect...