Limit on Unlinking/Linking Records

Kay C Lan lan.kc.macmail at gmail.com
Tue Aug 7 06:59:40 CDT 2012


Val 4.9.1

Thanks

On Tue, Aug 7, 2012 at 6:47 PM, Thorsten Hohage
<thohage at genericobjects.de>wrote:

> 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
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20120807/aee1b602/attachment.html>


More information about the Valentina mailing list