Hi all, I'm writing a one-to-many relationship to a database, and

cgoldsberry over 11 years ago

Hi all,

I'm writing a one-to-many relationship to a database, and am having trouble with some of the variables in my CDT which are supposed to be the same for all of the entries in my 'many' table, like today's date as a timestamp. When I pass in a single value for these variables (like 'today()'), only the first entry in the list gets the timestamp. What's the best-practice way to ensure that single-value variables can be correctly applied to each of the entries in my table when I write to a data store?...

Discussion posts and replies are publicly visible

Parents

0 cgoldsberry over 11 years ago

Gorgeous. Thanks! I was able to successfully use ={today()}[1+0*enumerate(length(pv!CDTvariable))] to create a list of today's date as long as my CDT
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 cgoldsberry over 11 years ago

Gorgeous. Thanks! I was able to successfully use ={today()}[1+0*enumerate(length(pv!CDTvariable))] to create a list of today's date as long as my CDT
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data