dynamic for each statements

[jaylaforte]

Re: dynamic for each statements

That's a great idea! I can conceptualize it but I don't know how to dynamically create a set. I'll do some searches and check the help.

I definitely think I'm too deep into the complexities at the moment and I'm glad I had your set of eyes to check this out. I really, really appreciate your help and if there's anything I can do for you, just ask!

-Jay

[G Gabriel]

Re: dynamic for each statements

if there's anything I can do for you, just ask!

:)
Looking to buy a new car! Either a Jaguar XJ8


or a Lotus:



As to dynamically create a set, look into:
<tbl>.set_create()
<tbl>.set_add()
etc..

[jaylaforte]

Re: dynamic for each statements

lol - when I make my millions I will definitely hook you up. I'm partial to BMW's so I'll get an M3 and race you in the Lotus!!! (too bad the M3s are so much heavier now...).

Thanks for the quick information on dynamic sets... I'll let you know how I do after a weekend full of work.

Thanks again!

[Peter.Greulich]

Re: dynamic for each statements

A SET.
...
That's all.
When you create a set, alpha creates a composite table. The records in that composite table reflects all possible combination between the parent and the child(ren).
...
So, all you have to do, is dynamically create a set.

Just to expand on Gabe's very clever idea (which immensely simplifies coding). Your set would require the following two conditions:

1. It must be a cascading 1:M set - otherwise you won't get all the combos (see image)
2. Use a universal linking expression such as 1=1, that way you won't need to worry about a linking key.

BTW: You could have your 20 blank tables pre-built and just populate the ones you need dynamically on the fly. Then zap them as step 1 of your code before building the next dynamic set.

Attached...

[G Gabriel]

Re: dynamic for each statements

BTW: You could have your 20 blank tables pre-built and just populate the ones you need dynamically on the fly. Then zap them as step 1 of your code before building the next dynamic set.

Peter:
I thought of that, but then you would have a set with 20 tables all the time as opposed to if you do it dynamically, you might have a set with as few as 2 tables, a much more efficient one.

[Peter.Greulich]

Re: dynamic for each statements

Peter:
I thought of that, but then you would have a set with 20 tables all the time as opposed to if you do it dynamically, you might have a set with as few as 2 tables, a much more efficient one.

Gabe,

I don't mean have a pre-built set, just pre-built (empty) tables. The user would automatically concatenate a set based upon the user selections. The set might be two tables or all twenty. By having pre-built tables (which presumably would always be used to one degree or another), it saves the xbasic step of creating tables on the fly - you only need to populate them.

[G Gabriel]

Re: dynamic for each statements

I don't mean have a pre-built set, just pre-built (empty) tables.

That's what I meant when I said:

This means, for each one of these items to choose from, create a table for that item

When I first read your post, I though you wanted to have a pre-built set in addition to these tables.