how do i delete a reference between rows
i have two tables that are linked
how do i delete a row reference without deleting the tathet object
12 replies
-
Click on the unlink button...
-
that button doesn't show on the iphone application.
-
and it doesn't show on the web application
-
On the iPhone tap the reference (relationship). then tap the Menu (top right, 3 dashes) and finaly tap Unlink
-
01 I am on my table view
02 I click on my parent record
03 I click on the child record "Sarah"
04 I click on the hamburger in the top right corner
there is no option to "unlink"
iphone 8+
ios 12.3
:-)
-
Maybe your record is locked (writable if)? Or try to unlick from the other side.
-
Ah, I am linking to the same table,
ie person <is-a-relative-of> person
-
I attached my sample test db, on the web I can "unlink" on the iPhone I can't Doh !
-
here is the People.ninox in base64 format. just do "pbpaste| base64 -d"
VUVzREJBb0FDQUFBQURKRnVFNEFBQUFBQUFBQUFBQUFBQUFMQUJ3QVkyOXRiV1Z1ZEhNdVpHSlZWQWtBQTBDdTUxeEFydWRjZFhnTEFBRUU1d01BQUFUbkF3QUFVRXNIQ0FBQUFBQUFBQUFBQUFBQUFGQkxBd1FVQUFnQUNBQXlSYmhPQUFBQUFBQUFBQUIyQUFBQUN3QWNBR0poWTJ0MWNDNXFjMjl1VlZRSkFBTkFydWRjUXE3blhIVjRDd0FCQk9jREFBQUU1d01BQUt0V3lreFJzbElxdFN6TUtVck16czVLTTAwdnowOHpVTkpSU2trQ3k2UW5saVVibFpjWmxGWGtaNEpGOHhKelU0SGlBYW41QlRtcFFKR1N6TnpVNHBMRTNBSWxLME5UVXdzekMzTWpTek5MSXhNZHBkTGkxQ0tneXNpZ2NOOFFaMHVYQ0tQVXlIeXZTTmNNcFZvQVVFc0hDSnJBVUZodUFBQUFkZ0FBQUZCTEF3UVVBQWdBQ0FBeVJiaE9BQUFBQUFBQUFBQWhEUUFBQ2dBY0FHaHBjM1J2Y25rdVpHSlZWQWtBQTBDdTUxeEFydWRjZFhnTEFBRUU1d01BQUFUbkF3QUE1VlZOYitJd0VMM3ZyMWo1c3Bkb1JleDh3YTE4dElKdHQ0V2liU3RVVlNFeHhDVWtxWk5BcTRyL3Z1TTBBVVBZQmxyMXRKZklzV2VlMzV0TTNvelEzZURtWXRpcXQyOHh2UXQ3ZHgwUEthcXVXNFpscWpWTnJ4TUZ4WTVINXpaU1hsRk1uMUJEVmRDQzhwaUZBV3BnQlFYME9SbStSTFRyWnE4SkxHUFVlRVVuNGlFT1R4bjFYWEdxS2NpeG95UkxSRmNBQVFzRmVjeDFLZXhNYkQrbUNwcUk2QTNBMkk0cFJNY0paOEVVeVFCRGdJWU5UcDlTeHFtN0JnaTVTemxxMUFBcTVQTWI1aVlldlAzVUZaU21ETUpRYjlaK0RLNGpOdFBPTG4xMjJRU1FxUitPYmYrYTJ0eUI0SVNuZ09QWmNUZHc2Zk1hK0kzRFNacUVUc2c1ZFpJaTh1M2dJdlVUNXJPQXJoTTh5cVllUktrckJUVWxNWnhPdHBSY3BzazRUQU4zbnhxSUxZb0xCY25lMS9WRXJRd21kbXlYN3NvWEg0blJaU3NNSm13cTdwNkhJZ2dsOXRpbmFMVXV4dElibkErdEhoNEU0L0NhWHdnT1V0blU3RUxLYWVEUUFZVnFjSUdOb2pCS0l3SFMybEsxMkZMVkRUYWkzdEVneXA5enhnZHlmcGsxQnhlRFA4TnV1OTh5ejRtQUxFcHRsT21MWHBYSlp3MkdWZ0tPaVQ3YjRFNmJMQmozakt0ZXIyLyttaS8zTjhacXRici9ObnJ2cjFGVnM1YVhIMVdGYXRnRXlnNm5ka0xodWhOVi9HVVBHUnV4Umc4T0xIZWlIK2I3OWxKSTJYTVRJUHp6SklhZm1WU3B3YVJPYWpKRkxGSEV1eFR6NkMySzY3MFBVdFFxS1dyRUFtOUpJMWV1SXRnSGF0c0xhSnpLZEdQN0l4QkpJU2twZkl2ZVZsanNmVkNoVVVXUllJc1lza0lpSy93UmZ6L2xERHE4VWlyQmRjdVVwV3FTVkcxWGFoNjlKWFc5ZDd4VU1Jc1J1YzhsV3dkUzNaSGNQS0FkZEVLMGNyRWdNMGg5LzhCa1R1ZmhJcTlRVlViZE5DMDVBMWRsR0lhbDRsSy9OZy80R1V1Wm1iVE1oZFhDbnQ2SHdBU2JOYTA4MDdFMDFNa3hROTM0ajRkNit5dUdldWZ6US8zV0hmUi9tOGJ5c2VPY3RYWGFQMjZvZHo0LzFOdkhEL1dicU51ZGpZZVBVelpMbHlxWkhqZlVjN1F2RytyZzhIVU55ODZwUzg2cDd6aG5FUzA3NTJidmVPZUVMekpTQytkVXExeWl1R25IWDZCWjlhcE1Rd1UvMjVkNWdIV1drN01TZFhKenlqcTVzc3hHdmFadTJhOWVZYWJZTkUzZDJFZTVza3lsVENMekxjejBMMUJMQndnLzJuRWtLd01BQUNFTkFBQlFTd01FRkFBSUFBZ0FNa1c0VGdBQUFBQUFBQUFBTlFBQUFBMEFIQUJ6WlhSMGFXNW5jeTVxYzI5dVZWUUpBQU5BcnVkY1FLN25YSFY0Q3dBQkJPY0RBQUFFNXdNQUFLdFd5a3ZNVFZXeVVncEl6Uy9JU1ZYU1VjcE16czhEOGxNU1N4S1RFb3RCSXNuNU9mbEZRQ0ZsWTJOTHk1UVVwVm9BVUVzSENJNUNhRU15QUFBQU5RQUFBRkJMQXdRVUFBZ0FDQUF5UmJoT0FBQUFBQUFBQUFCY0JBQUFCd0FjQUdSaGRHRXVaR0pWVkFrQUEwQ3U1MXhBcnVkY2RYZ0xBQUVFNXdNQUFBVG5Bd0FBalpOTmM5b3dFSWJ2L0lyT1h0ck9lRHExQVp0d0k0R2toa2tKaEpSd1l2eXgyQUlqT2JJRmFUdis3MTJaWUQ2YWRyaDRKTzJyWi9kZHJiUDJiOGp3QmRxbVpjQUdaY1lFaDNiZEFJNnYrZVJuaW00SWJRcmx0TXlBeEIzOTBjRmJoa21vbzdZQmdaZm01VVY0SUFRdERJaFpHQ0tkTEx3a1F3TVdXbjBBK0Y2R3BNNXl5WGdFeDRBSm9lbEE0b3RpRXNNS0lHU0lFdHBmQ1NYa2VzckNQS2JkbDZZQlNqR1NRWC9WWGZMSGxLMGFkOE9FRGE4SkVpWEM5NUpIOUdSQTRsd3E0c1JlNXZJUVh5dndyb2FPeWtVZ3BNUWczeXQzZ1h1VjVDeGhIS3NMTWJJb0pwVlpHTkE5TWlOeGNlSmtxSEpmS0I2KzU0YTArK1pTUThwOTFVL29sWmdzOEVJOHQyL1NJekhjM2dpK1lKSE92UlphQkxubkp3aEYxWXpuY0R6Njd0amJaUys0NnpaeEJDZHRNOHVFS0pFSE9FYnFodFJzU0VXcVVnM3BuYmphbkxoeStjSFVmengwb2FyWnVyRG1hZXE2SzMreWpOaEtiYzI2SG90OXErMi95OWV6ZWx6OEcwM2ptSjZ6QXplNlp0enYydy85L3NnWnJMZnZEMFpSRkxVZlVxdzJtNmR2Zzlhdk1YZE5IRkN0SmVIOEhIYi93NXZ2UTI4K2VVbnlXWjlVVmlzWmxWUCtabFpSZStxWUZKa0hSRGFielpiZGNreXpZVG5rY1I0b0VzL0cwL3ZKelZYMzJjS1o2TTk2TVJIbjY0UGFjaHlucWRYcmY2azcrZ0c4RFVJNW9IV2RzbjZlMG1yWWw2YzA2OVpWeTdrazVjZnN3NjFrOUN4UTFQNEFVRXNIQ05hRDhQd0hBZ0FBWEFRQUFGQkxBUUllQXdvQUNBQUFBREpGdUU0QUFBQUFBQUFBQUFBQUFBQUxBQmdBQUFBQUFBQUFBQUNrZ1FBQUFBQmpiMjF0Wlc1MGN5NWtZbFZVQlFBRFFLN25YSFY0Q3dBQkJPY0RBQUFFNXdNQUFGQkxBUUllQXhRQUNBQUlBREpGdUU2YXdGQlliZ0FBQUhZQUFBQUxBQmdBQUFBQUFBRUFBQUNrZ1ZVQUFBQmlZV05yZFhBdWFuTnZibFZVQlFBRFFLN25YSFY0Q3dBQkJPY0RBQUFFNXdNQUFGQkxBUUllQXhRQUNBQUlBREpGdUU0LzJuRWtLd01BQUNFTkFBQUtBQmdBQUFBQUFBRUFBQUNrZ1JnQkFBQm9hWE4wYjNKNUxtUmlWVlFGQUFOQXJ1ZGNkWGdMQUFFRTV3TUFBQVRuQXdBQVVFc0JBaDRERkFBSUFBZ0FNa1c0VG81Q2FFTXlBQUFBTlFBQUFBMEFHQUFBQUFBQUFRQUFBS1NCbHdRQUFITmxkSFJwYm1kekxtcHpiMjVWVkFVQUEwQ3U1MXgxZUFzQUFRVG5Bd0FBQk9jREFBQlFTd0VDSGdNVUFBZ0FDQUF5UmJoTzFvUHcvQWNDQUFCY0JBQUFCd0FZQUFBQUFBQUJBQUFBcElFZ0JRQUFaR0YwWVM1a1lsVlVCUUFEUUs3blhIVjRDd0FCQk9jREFBQUU1d01BQUZCTEJRWUFBQUFBQlFBRkFKSUJBQUI0QndBQUFBQT0K
-
How do you unlink in code?
-
Set the table reference equal to 0. So if you wanted to unlink the current record in the many table you would use code like this...
let curRec = this;curRec.(YourTableReference := 0)If you wanted to unlink all the records, you would use code like this...
for i in select ManyTable doi.(YourTableReference := 0)end -
Yup, thank you. I worked it out when the error wanted a return value.
Content aside
- 4 yrs agoLast active
- 12Replies
- 2649Views