Updating binary links

[Ruslan Zasukhin]

On 16/2/07 5:14 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

> Hi Ruslan,
> 
> where in Mantis should I file the request ?
> Under Issues--Kernel ?

yes

> There is no real page for feature request is there ?

No. 

In each PROJECT present in menu category "Feature"
 
> Bart Pietercil
> 
> On 16-feb-07, at 10:38, Ruslan Zasukhin wrote:
> 
>> On 16/2/07 10:16 AM, "Danny Lewkin" <daniel.lewkin at cognosis.be> wrote:
>> 
>> Hi Danny,
>> 
>>> I have to 2 tables, tbl_usertypes and tbl_users. Between them there
>>> is a binary link, lnkusertype (so without objectpointers of foreign
>>> key).
>> 
>> And they are M:M, yes?
>> 
>>> I already have records in the tables, linked to eachother.
>> 
>>> If I want to change the usertype of a user, it's clear to me that I
>>> have to change the link between that user in the tbl_user and the
>>> usertype in tbl_usertype.
>> 
>> yes
>> 
>>> But I can't seem to find any other way to do this, other than first
>>> unlink the existing link user-usertype, en linking it again.
>>> Or is there another "update link" method in API or an "update link"
>>> SQL function, that I hav missed?
>> 
>> No, because I do not see HOW this can be written.
>> 
>> If you compare to MM link-table you also need do
>> 
>>     DELETE
>>     INSERT
>> 
>> Hmm, you know, may be we can do something as
>> 
>> 
>>     REPLACE link_name (r1,r2) ON (r1', r2')
>> 
>> This can work...
>> 
>> Can you add such request to Mantis?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]