All:
I searched R:SYNTAX for "COUNT = INSERT" (Found under "WHERE (Short
Name: WHER)" | "Basic WHERE Clause Conditions")
Can someone clarify?
"Refers to the last row inserted in a table by the current user, even if
it has been modified by another user. "
Q. If I am the "current user", does COUNT=INSERT reference MY last row
when "another user" ADDS one or more rows after mine?
"If there is not a newly inserted row in the table ..."
Q. What is the time frame/session condition which determines "newly"?
Thanks much, Bruce
Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
+011 (909) 238-9012 m | [email protected]
*******************************************************
------ Original Message ------
From "A. Razzak Memon" <[email protected]>
To [email protected]
Date 12/8/2022 7:45:30 AM
Subject Re: [RBASE-L] - capture autonumber field value
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
<https://groups.google.com/d/msgid/rbase-l/436f1de3-b28b-42e1-872d-4ba5fec406e8%40rbase.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/em83ec150b-71f1-4313-b75d-98cee5a972a8%400884f916.com.
