Thank you
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Freitag, 2. Dezember 2016 15:16
An: firebird-support@yahoogroups.com
Betreff: Re: AW: [firebird-support] Sequence
Hi
i do not read your whole info but maybe you need to use case
Olaf wrote 02.12.2016 10:43:
>Also I can do the following:
>
>Priority in steps of 1
>
>ID 10 Prio 1
>ID 20 Prio 2
>ID 23 Prio 3
>ID 11 Prio 4
>
>Now the user can Set the ID 23 to Prio 2, how can I realize this
without a loop?
>
>Update table set prio = newprio(1) where id = 20;
>Upd
Gesendet: Freitag, 2. Dezember 2016 10:44
An: firebird-support@yahoogroups.com<mailto:firebird-support@yahoogroups.com>
Betreff: AW: [firebird-support] Sequence
Okay,
I would simply change the prio new in steps of 10.
Also I can do the following:
Priority in steps of 1
ID 10 Prio 1
ID 2
groups.com
Betreff: AW: [firebird-support] Sequence
Okay,
I would simply change the prio new in steps of 10.
Also I can do the following:< /p>
Priority in steps of 1
ID 10 Prio 1
ID 20 Prio 2
ID 23 Prio 3
ID 11 Prio 4
Now the user can Set the ID 23 to Prio 2, how can I realize this withou
@yahoogroups.com
Betreff: AW: [firebird-support] Sequence
Okay,
I would simply change the prio new in steps of 10.
Also I can do the following:
Priority in steps of 1
ID 10 Prio 1
ID 20 Prio 2
ID 23 Prio 3
ID 11 Prio 4
Now the user can Set the ID 23 to Prio 2, how can I realize
:47
An: firebird-support@yahoogroups.com
Betreff: RE: [firebird-support] Sequence
Olag,
> Before
> Record 1 prio 3
> Record 2 prio 10
> Record 3 prio 18
> Record 4 prio 20
> Record 5 prio 30
>
> The user set the record 4 to prio 15, I would like to do this:
>
> R
Olag,
> Before
> Record 1 prio 3
> Record 2 prio 10
> Record 3 prio 18
> Record 4 prio 20
> Record 5 prio 30
>
> The user set the record 4 to prio 15, I would like to do this:
>
> Record 1 from 3 to 10
> Record 2 from 10 to 20
> Record 3 from 20 (should 15, Destination between record 2 and reco
Hello @ll,
in a table there a many records with prioritys 1, 4, ..
Now the user can set one record to 5 and after this, I would set all other
records before in steps of 10 and after this again:
For Example:
Before
Record 1 prio 3
Record 2 prio 10
Record 3 prio 18
Record 4 prio 2