Dan,
SET VAR vLastValue INTEGER = 0
SELECT colname INTO vLastValue INDIC iv1 FROM tablename WHERE COUNT = INSERT
Alternatively, you could also try:
SET VAR vLastValue INTEGER = 0
SELECT colname INTO vLastValue INDIC iv1 FROM tablename WHERE COUNT = LAST
Hope it helps!
Very Best R:egards,
Razzak
On 12/8/2022 10:34 AM, Dan Goldberg wrote:
I am trying to capture an autonumber field value in the after start
eep but it keeps showing 0. So I put the variable field on the form so
I can watch it(circled red). But when I step thru it I see the
variable value in the form but not in the eep. Is there a better way
after a form start and when a row is save to get the current
autonumber value when those are triggered? TIA
Dan Goldberg
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027F39DE5DF0671E6E6873BD41D9%40BY3PR19MB5027.namprd19.prod.outlook.com
<https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027F39DE5DF0671E6E6873BD41D9%40BY3PR19MB5027.namprd19.prod.outlook.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/436f1de3-b28b-42e1-872d-4ba5fec406e8%40rbase.com.
