Paradox Community

Items in pnews.paradox-programming

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


Copyright © 2004 thedbcommunity.com