Subject: | datamodel - query
| Date: | 13 Sep 2018 23:09:09 -0400
| From: | "Kevin Zawicki" <numberjack@wi.rr.com>
| Newsgroups: | pnews.paradox-programming
|
Add a query to the datamodel, run the form.
The attached table grid binds and seems to work like any other tableframe.
The tablename property viewed shows:
:PRIV:__Q7980F.DB
but this table does not physically exist in the PRIV (even hidden)
Guessing it is a like an in memory tcursor.
so
attach a tcursor and
isInMemoryTCursor() is true
!!!
This opens up a few ideas about the times I need a small temp table in a
form or need to change the child table contents.
Conceivably you could have a unique table name of the same structure in a
DM for every instance of a form that is not the main table.
"Steven Green" <greens@diamondsg.com> wrote:
>I have not tried that.. you might have to experiment with the results..
the
>objects that make up the tables and fields, all have "full path" properties
>to the actual tables, I'd start with that
>
>
>--
>
>Steven Green
>Myrtle Beach, South Carolina, USA
>
>http://www.OasisTradingPost.com
>
>Collectibles and Memorabilia
>Vintage Lego Sets and Parts
>- and Paradox support, too
>"Kevin Zawicki" wrote in message
>news:5b95815a$1@pnews.thedbcommunity.com...
>
>
>
>
>I was referring to doing this in on the fly in the init via code.
>
>The "second table" is not linked.
>If the table is not there on design open you get prompted to choose another
>table... I am trying to do that in code.
>
>I want to open a form more than one time and have a unique master and unique
>second table. Same structure.
>
>
>I am also experimenting with using a query in the DM. It seems to work as
>a table, a table in memory? I have to test, would each instance of the form
>open unique table in memory?
>
>
>
>
>"Steven Green" <greens@diamondsg.com> wrote:
>>right-click on a field or table frame, define field / define table, hit
>the
>>little thing in the top left corner and it's the "data model" for the form,
>
>>without saving as a DM.. you can change everything from there, but it
>>screws
>
>>up everything on the form, of course, and you have to re-size, re-place,
>etc
>>
>>
>>--
>>
>>Steven Green
>>Myrtle Beach, South Carolina, USA
>>
>>http://www.OasisTradingPost.com
>>
>>Collectibles and Memorabilia
>>Vintage Lego Sets and Parts
>>- and Paradox support, too
>>"Kevin Zawicki" wrote in message
>>news:5b94616e$1@pnews.thedbcommunity.com...
>>
>>
>>
>>I have worked around this for years...
>>thought I would ask.= again.
>>
>>Any way to change table in the data model that is not the "master" table
>>on form init or open?
>>
>>or open a form based on a saved datamodel?
>>
>>
>
|