Hi all,
quick question about primary keys - in particular, creating these.
I know the standard methods will automatically create primary keys - but is it possible to supply these yourself at record creation?
The scenario i have in mind is that you can generate a set of multidimensional arrays in LiveCode and these would link to each other with primary/foreign keys which i create in LiveCode with UUID(). So far so good.
As far as i can see however there isn't a way to supply these keys to LiveCloud to use in place of the automatically generated cdbRecordID.
Not a major showstopper but does add an unnecessary layer of complexity retrieving records as I'd have to manage a 'PrimaryKey' field on top of the cdbRecordID field...
Unless i'm missing a something major? Very happy to be corrected
quick question about primary keys - in particular, creating these.
I know the standard methods will automatically create primary keys - but is it possible to supply these yourself at record creation?
The scenario i have in mind is that you can generate a set of multidimensional arrays in LiveCode and these would link to each other with primary/foreign keys which i create in LiveCode with UUID(). So far so good.
As far as i can see however there isn't a way to supply these keys to LiveCloud to use in place of the automatically generated cdbRecordID.
Not a major showstopper but does add an unnecessary layer of complexity retrieving records as I'd have to manage a 'PrimaryKey' field on top of the cdbRecordID field...
Unless i'm missing a something major? Very happy to be corrected