in trying to retrieve the 'last_value' internal param from a given table with :
SELECT __IDB_INTERNAL last_value FROM TEXT('id') IN TABLE asUser_seq
I get a number of results equal to the number of records in the table
returned. They are all the correct 'last_value' number, but is there
a way to simply get the value without the multiples?
P.S. -
If I use DISTINCT, I get only one return, but on a table with a large
number of entries, wouldn't this add a lot of overhead to the
procedure?
Thanks in advance.
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.
|