Limit on Unlinking/Linking Records

[Kay C Lan]

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?

Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20120807/9f7c0a19/attachment.html>