Paradox Community

Items in pnews.paradox-programming

Subject:Re: datamodel
Date:Mon, 10 Sep 2018 12:08:41 -0500
From:Mark Bannister <markRemove@THISinjection-moldings.com>
Newsgroups:pnews.paradox-programming
Table name length is only if you are editing the form (.fsl) file 
directly.  For some reason you cannot change the file size (or maybe 
position of where the file name starts?) in the form.  I've never dug 
around to see what the mystery was.

On 9/10/2018 10:02 AM, Steven Green wrote:
>> The new table name has to be the exact length as the old
> 
> the formopeninfo() thing makes sense, thanks.. but why the tablename 
> length issue? what barfs if it's not the same?
> 
> -- 
> 
> Steven Green
> Myrtle Beach, South Carolina, USA
> 
> http://www.OasisTradingPost.com
> 
> Collectibles and Memorabilia
> Vintage Lego Sets and Parts
> - and Paradox support, too
> "Mark Bannister"  wrote in message 
> news:5b966ab8$1@pnews.thedbcommunity.com...
> 
> 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