Paradox Community

Items in pnews.paradox-programming

Subject:Re: datamodel
Date:Mon, 10 Sep 2018 08:00:27 -0500
From:Mark Bannister <markRemove@THISinjection-moldings.com>
Newsgroups:pnews.paradox-programming
You can change the master table when you open the form (just as you can 
on a report) with formopeninfo structure.  It cannot be done on init, 
although rather annoyingly Pdox has the ability to change any/all tables 
on opening. We've all opened a form with a bad alias or table name and 
had Pdox asked to find the table.

I actually do this with some fairly complex code by changing the table 
name on the .fsl form, writing the new form to the priv directory and 
then running that form.  The new table name has to be the exact length 
as the old and it can appear multiple times on the form.

On 9/9/2018 3:23 PM, Kevin Zawicki wrote:
> 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