Limit on Unlinking/Linking Records

[Thorsten Hohage]

Hi Kay,

what Version of Valentina are you using? V4 or V5, there were several changes in V5.


On 2012-08-07, at 12:44, Kay C Lan <lan.kc.macmail at gmail.com> wrote:

> I what to update a 1:M link (newC:ozC), from recid 170 to recid 35 in newC.
> 
> The Wiki says this is NOT IMPLEMENTED
> LINK RECORD (26,…,204) OF Person TO RECORD (35) OF Phone INSTEAD OF (170);
> 
> So I will do 3 steps, determine the records linked to recid 170, then UNLINK them, then LINK them to recid 35
> 
> SELECT ozC.recid FROM newC JOIN ozC ON Link_newC_ozC WHERE newC.recid = '170'
> 
> I get this result
> 
> 26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,201,202,203,204
> 
> I build this query (programatically so there are no typing errors)
> 
> UNLINK RECORDS (26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,201,202,203,204) OF ozC FROM RECORD (170) OF newC
> 
> but I get this result:
> 
> Kernel error: 0x21502. It's too much values.
> 
> This is both via LiveCode (Revolution) and double checking using Val Studio.
> 
> This seems to suggest a limit on how may records I can unlink (and link) at a time, is this true, and if so, what is the limit?




regards,

Thorsten Hohage
-- 

Valentina Technology Evangelist
generic objects  GmbH - Leiter Solution Center Nord