1

Topic: Outswapping of the data in with the help sql request

All good afternoon!
There is such problem. There is some table: And, I preempt in cursor all fields from the given table and if in the table And with this field work (the network version) I also preempt the given (occupied) record, but only with the selected color - we admit the red.
As at level sql request to trace that record, which is occupied then to mark with separate color.
Thanks

2

Re: Outswapping of the data in with the help sql request

1. To preempt something in  it is impossible basically for  anything in itself does not store.  - means of interactive operation with the tabular data lying in the cursor/table and no more of those.

dima_18 wrote:

All good afternoon!
There is such problem. There is some table: And, I preempt in cursor all fields from the given table and if in the table And with this field work (the network version) I also preempt the given (occupied) record, but only with the selected color - we admit the red.
As at level sql request to trace that record, which is occupied then to mark with separate color.
Thanks

2. In any way. For about record employment knows only occupied it. Remaining learn about record employment only receiving  at attempt it to occupy.
3. As item 1 corresponds with 2. - it is absolutely not clear.

3

Re: Outswapping of the data in with the help sql request

dima_18, It is possible to add an additional field which will store for example the manager code if a zero it is free if is not present it is occupied also each time you re-read the data and you adjust color gamma, in an ideal it is possible even under everyone the manager to make the color.

4

Re: Outswapping of the data in with the help sql request

AngelOKES;
Many thanks for the answer. I operate under your plan.

5

Re: Outswapping of the data in with the help sql request

dima_18;
Only at once think over what to do, if record is occupied, and occupied for a long time fell off.

6

Re: Outswapping of the data in with the help sql request

asdor;
At the principal manager it is possible to make the reset button, or to deduce the message what manager it is blocked, if territorially the manager are far apart the reset button mandatory if all nearby it is possible to manage the message and then that manager which occupied record and fell off, comes into the program and clears all records occupied with self.
Yes by the way do not forget that at an output each manager removes locks and simultaneously only one record can be blocked one manager

7

Re: Outswapping of the data in with the help sql request

AngelOKES;
Well, to deduce the message what manager it is blocked, I think guesses.
The approach is not pleasant. Though  there the pair of the clients nearby sitting, in general depends on the task.
And so to show in the list that record is occupied... Faugh-u-u (I pay attention, from request)
Here at attempt to open record, it should be checked, and to tell that record it is occupied by that, then that.
Once again, all depends on the task. If hundreds users actively click - one.
Para-triple of old women, another.

8

Re: Outswapping of the data in with the help sql request

asdor if one hundred and is more unambiguously the approach is necessary more serious

9

Re: Outswapping of the data in with the help sql request

AngelOKES;
Yes is not present. The approach is not true.
It is easy to invent a situation when 3 users howl from such system!
, the task) is important
Can there the data of times in 3 days change.
Then all super to spit and forget)
All remaining...
The HARDWARE does not understand that the list, this photo, that instant when there was a sampling!!!