Subject: | Re: Multiple Forms, Multiple Users
| Date: | Tue, 25 Aug 2020 21:13:24 -0800
| From: | Peter <peterspammenot@whiteknight.email>
| Newsgroups: | pnews.paradox-development
|
Yeah I have done that a couple times, there are two main problems that I
couldn't resolve
1. I can no longer do a relational link (master/child tbls) in the
form's datamodel
2. if someone changes the "real" table then all the private tbls need to
be updated with those changes
But okay I got the answer the answer I was looking for, client/server
model. I'l have to do some research on this. Thanks Tom.
Peter
On 8/25/2020 8:14 PM, Tom Krieg wrote:
> Emulate a client/server model using TCursors and libraries. Extract the
> data you want to private tables and use those in your forms. Whenever
> you need to update a "real" table use a tcursor.
>
> It's a lot of work to begin with but once it's set up it's RAD.
>
> But if you're going to do that, you may as well go all the way.
>
> On 26/08/2020 10:30 am, Peter wrote:
>> So far I have only developed apps that let users use one form (module)
>> at a time. I usually have a central form that lists all the modules
>> for the things they can do. They select one, do their thing and then
>> close it in order to go back to the central form and choose another
>> module.
>>
>> When I start dreaming of setting things up so that a user can have
>> more than 1 form open at a time the logistics of tbl/record locking is
>> mind boggling.
>>
>> For instance, they could have one form open which has one or more
>> locks on some tables in the datamodel of the form. If they opened
>> another form that had even one of the tables in the datamodel of the
>> first form then there would conflicts with record locking.
>>
>> How does one get around this? Thank you.
>>
>> Peter
>
|