Hi,


I need  BigInt type generated values,  and  they need to be shared between tables.
(Something like a IB/Firebird generator.)

Anyone have implemented this already? What would be the best way to do it in ElevateDB?



Thanks in advance,

Leslie
   

Leslie

>I need BigInt type generated values, and they need to be shared between tables.
>(Something like a IB/Firebird generator.)
>
>Anyone have implemented this already? What would be the best way to do it in ElevateDB?

I'm not sure what you mean by <<shared between tables>> but I'm guessing you mean one sequence shared between tables in record creation order eg

table a gets 1
table b gets 2
table a gets 3
table c gets 4
table a gets 5

In which case all I can suggest is a single column, single row table holding the value. The exact implementation would depend on wether you want to do it using sql or tables.

Roy Lambert [Team Elevate]

Roy,

Yep, that's it.

I think I will do it on the component level, it suits better what I need it for.
Just wanted to make sure there is no easier way to do it.

Thanks,
Leslie