date:20221208

Re: [RBASE-L] - Variable Lengths - X.5 Enterprise 10.5.5.11013

2022-12-08 Thread A. Razzak Memon


John,

As always, the pleasure is all mine!

Razzak

On 12/8/2022 1:28 PM, johnd...@gmail.com wrote:

Razzak,

Thank you very much. That was the issue - was 18, now 40.

I appreciate your help.

Regards
John Docherty

On Friday, December 9, 2022 at 4:18:17 AM UTC+13 A. Razzak Memon wrote:

John,

What is your *NAMEWIDTH *setting?

At the R> prompt: SHOW NAMEWIDTH

The default is 18 characters.

In my case, I have the NAMEWIDTH set to 40.

*SET NAMEWIDTH 40*

Hope it helps!

Very Best R:egards,

Razzak


On 12/8/2022 12:21 AM, johnd...@gmail.com wrote:

I have noticed that the variable lengths in one of my databases
are truncated at 18 characters, which I understood applied in X.5
and not the Enterprise version. I was just wondering if I am
doing something wrong or has something changed  ?  Any advice
would be appreciated. (These used to work with longer names - I
think.)

Thank you.
Regards
John Docherty
-- 
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 rbase-l+u...@googlegroups.com.
To view this discussion on the web visit

https://groups.google.com/d/msgid/rbase-l/2df8a282-5f7a-4a76-81ee-0fea12041f30n%40googlegroups.com

.


--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/a5882a51-ce1f-4033-9fe1-0b93bb42a8aen%40googlegroups.com 
.


--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/ae5d474e-ccf6-6bc2-24a1-ebff8fe57da8%40rbase.com.

Re: [RBASE-L] - Variable Lengths - X.5 Enterprise 10.5.5.11013

2022-12-08 Thread johnd...@gmail.com

Razzak,

Thank you very much. That was the issue - was 18, now 40.

I appreciate your help.

Regards
John Docherty

On Friday, December 9, 2022 at 4:18:17 AM UTC+13 A. Razzak Memon wrote:

> John,
>
> What is your *NAMEWIDTH *setting?
>
> At the R> prompt: SHOW NAMEWIDTH
>
> The default is 18 characters.
>
> In my case, I have the NAMEWIDTH set to 40.
>
> *SET NAMEWIDTH 40*
>
> Hope it helps!
>
> Very Best R:egards,
>
> Razzak
>
>
> On 12/8/2022 12:21 AM, johnd...@gmail.com wrote:
>
> I have noticed that the variable lengths in one of my databases are 
> truncated at 18 characters, which I understood applied in X.5 and not the 
> Enterprise version. I was just wondering if I am doing something wrong or 
> has something changed  ?  Any advice would be appreciated. (These used to 
> work with longer names - I think.) 
>
> Thank you.
> Regards
> John Docherty
>
> -- 
> 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 rbase-l+u...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/2df8a282-5f7a-4a76-81ee-0fea12041f30n%40googlegroups.com
>  
> 
> .
>
>
>

-- 
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/a5882a51-ce1f-4033-9fe1-0b93bb42a8aen%40googlegroups.com.

Fw: Re[2]: [RBASE-L] - capture autonumber field value | COUNT=INSERT

2022-12-08 Thread Bruce Chitiea


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 | rby...@safesectors.com

***
-- Original Message --

From "A. Razzak Memon" 

To rbase-l@googlegroups.com
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027F39DE5DF0671E6E6873BD41D9%40BY3PR19MB5027.namprd19.prod.outlook.com 
.




--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/436f1de3-b28b-42e1-872d-4ba5fec406e8%40rbase.com 
.


--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/em83ec150b-71f1-4313-b75d-98cee5a972a8%400884f916.com.

RE: [RBASE-L] - capture autonumber field value

2022-12-08 Thread jan johansen

I prefer Steve's way because as Karen already mentioned, forms work 
differently between ENTER USING and EDIT USING.







From: Steve Sweeney 
To: "'rbase-l@googlegroups.com'" 
Date: Thu, 8 Dec 2022 17:01:54 +
Subject: RE: [RBASE-L] - capture autonumber field value



Another option would be to INSERT INTO tablename (TEXT_columnname) VALUES 
(‘obscure_reference_code’) to establish the primary key (PK) first.

 

Then SELECT pk_columnname INTO variable_name FROM tablename WHERE 
TEXT_columnname = ‘obscure_reference_code’

 

Then you can “EDIT USING formname WHERE pk_columnname = . variable_name

 

 

From: rbase-l@googlegroups.com  On Behalf Of Doug 
Hamilton
Sent: Thursday, December 8, 2022 9:01 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - capture autonumber field value

 

whoopsie - NEXT is a bad idea if you just want the autonum value - because 
it increments the Autonum counter
Doug

On 12/8/2022 10:56 AM, Doug Hamilton wrote:

Dan - two other options might be:

1) If you're trying to get the next autonumber value, the NEXT function: 
(NEXT(tblname,autonumcol)) Returns the next value of an autonumbered column.
Subtract 1 to get the last assigned number.
See: https://www.rbase.com/support/rsyntax/rbgx5/next_functions_3.html

2) MAX function: SELECT MAX(ColumnName) FROM TableName

You might need to consider how many users are adding rows to the table to 
make sure you get the right number.

Doug

On 12/8/2022 9:45 AM, A. Razzak Memon wrote:

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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027F39DE5DF0671E6E6873BD41D9%40BY3PR19MB5027.namprd19.prod.outlook.com.


--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/436f1de3-b28b-42e1-872d-4ba5fec406e8%40rbase.com.

 

 



This email has been checked for viruses by Avast antivirus software.
www.avast.com





--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/c025e046-ce92-0cf8-b9f1-2dc21e4c3489%40wi.rr.com.

 

--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/812fc3be-0dbf-5e17-1c6a-06a41658d1a4%40wi.rr.com.




--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/BYAPR03MB371879136A57A16DB60E068E891D9%40BYAPR03MB3718.namprd03.prod.outlook.com.

-- 
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit

RE: [RBASE-L] - capture autonumber field value

2022-12-08 Thread Steve Sweeney

Another option would be to INSERT INTO tablename (TEXT_columnname) VALUES 
(‘obscure_reference_code’) to establish the primary key (PK) first.

Then SELECT pk_columnname INTO variable_name FROM tablename WHERE 
TEXT_columnname = ‘obscure_reference_code’

Then you can “EDIT USING formname WHERE pk_columnname = . variable_name


From: rbase-l@googlegroups.com  On Behalf Of Doug 
Hamilton
Sent: Thursday, December 8, 2022 9:01 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - capture autonumber field value

whoopsie - NEXT is a bad idea if you just want the autonum value - because it 
increments the Autonum counter
Doug
On 12/8/2022 10:56 AM, Doug Hamilton wrote:
Dan - two other options might be:

1) If you're trying to get the next autonumber value, the NEXT function: 
(NEXT(tblname,autonumcol)) Returns the next value of an 
autonumbered column.
Subtract 1 to get the last assigned number.
See: https://www.rbase.com/support/rsyntax/rbgx5/next_functions_3.html

2) MAX function: SELECT MAX(ColumnName) FROM TableName

You might need to consider how many users are adding rows to the table to make 
sure you get the right number.

Doug
On 12/8/2022 9:45 AM, A. Razzak Memon wrote:
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


[cid:image001.png@01D90AE3.B72576C0]


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 
rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027F39DE5DF0671E6E6873BD41D9%40BY3PR19MB5027.namprd19.prod.outlook.com.

--
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 
rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/436f1de3-b28b-42e1-872d-4ba5fec406e8%40rbase.com.



[Avast logo]

This email has been checked for viruses by Avast antivirus software.
www.avast.com


--
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 
rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/c025e046-ce92-0cf8-b9f1-2dc21e4c3489%40wi.rr.com.

--
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 
rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/812fc3be-0dbf-5e17-1c6a-06a41658d1a4%40wi.rr.com.

-- 
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

Re: [RBASE-L] - capture autonumber field value

2022-12-08 Thread Doug Hamilton

whoopsie - NEXT is a bad idea if you just want the autonum value - 
because it increments the Autonum counter

Doug

On 12/8/2022 10:56 AM, Doug Hamilton wrote:

Dan - two other options might be:

1) If you're trying to get the next autonumber value, the NEXT 
function:(NEXT(tblname,autonumcol)) Returns the next value of an 
autonumbered 
 column.

Subtract 1 to get the last assigned number.
See: https://www.rbase.com/support/rsyntax/rbgx5/next_functions_3.html

2) MAX function: SELECT MAX(ColumnName) FROM TableName

You might need to consider how many users are adding rows to the table 
to make sure you get the right number.


Doug

On 12/8/2022 9:45 AM, A. Razzak Memon wrote:

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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027F39DE5DF0671E6E6873BD41D9%40BY3PR19MB5027.namprd19.prod.outlook.com 
.


--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/436f1de3-b28b-42e1-872d-4ba5fec406e8%40rbase.com 
.





Avast logo   

This email has been checked for viruses by Avast antivirus software.
www.avast.com 


<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/c025e046-ce92-0cf8-b9f1-2dc21e4c3489%40wi.rr.com 
.


--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/812fc3be-0dbf-5e17-1c6a-06a41658d1a4%40wi.rr.com.

Re: [RBASE-L] - capture autonumber field value

2022-12-08 Thread Doug Hamilton


Dan - two other options might be:

1) If you're trying to get the next autonumber value, the NEXT 
function:(NEXT(tblname,autonumcol)) Returns the next value of an 
autonumbered  
column.

Subtract 1 to get the last assigned number.
See: https://www.rbase.com/support/rsyntax/rbgx5/next_functions_3.html

2) MAX function: SELECT MAX(ColumnName) FROM TableName

You might need to consider how many users are adding rows to the table 
to make sure you get the right number.


Doug

On 12/8/2022 9:45 AM, A. Razzak Memon wrote:

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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027F39DE5DF0671E6E6873BD41D9%40BY3PR19MB5027.namprd19.prod.outlook.com 
.


--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/436f1de3-b28b-42e1-872d-4ba5fec406e8%40rbase.com 
.



--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/c025e046-ce92-0cf8-b9f1-2dc21e4c3489%40wi.rr.com.

Re: [RBASE-L] - capture autonumber field value

2022-12-08 Thread 'Karen Tellef' via RBASE-L

Are you doing an "enter using" form?  I think the autonumber doesn't get "set" 
until you save the record.  My experience has been that when you exit the form, 
your variable would then be populated and can be referenced in code after the 
form is exited.  But if you need it while still in the form, you'll have to 
issue a "saverow" to assign the autonum

Karen
 
 
 
-Original Message-
From: Dan Goldberg 
To: rbase-l@googlegroups.com 
Sent: Thu, Dec 8, 2022 9:34 am
Subject: [RBASE-L] - capture autonumber field value

 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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027F39DE5DF0671E6E6873BD41D9%40BY3PR19MB5027.namprd19.prod.outlook.com.

-- 
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1131986925.2185178.1670518105949%40mail.yahoo.com.

Re: [RBASE-L] - capture autonumber field value

2022-12-08 Thread A. Razzak Memon


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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027F39DE5DF0671E6E6873BD41D9%40BY3PR19MB5027.namprd19.prod.outlook.com 
.


--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/436f1de3-b28b-42e1-872d-4ba5fec406e8%40rbase.com.

[RBASE-L] - capture autonumber field value

2022-12-08 Thread Dan Goldberg

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


[cid:image001.png@01D90AD7.6FB8AAC0]


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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027F39DE5DF0671E6E6873BD41D9%40BY3PR19MB5027.namprd19.prod.outlook.com.

Re: [RBASE-L] - Variable Lengths - X.5 Enterprise 10.5.5.11013

2022-12-08 Thread A. Razzak Memon


John,

What is your *NAMEWIDTH *setting?

At the R> prompt: SHOW NAMEWIDTH

The default is 18 characters.

In my case, I have the NAMEWIDTH set to 40.

*SET NAMEWIDTH 40*

Hope it helps!

Very Best R:egards,

Razzak

On 12/8/2022 12:21 AM, johnd...@gmail.com wrote:
I have noticed that the variable lengths in one of my databases are 
truncated at 18 characters, which I understood applied in X.5 and not 
the Enterprise version. I was just wondering if I am doing something 
wrong or has something changed  ?  Any advice would be appreciated. 
(These used to work with longer names - I think.)


Thank you.
Regards
John Docherty
--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/2df8a282-5f7a-4a76-81ee-0fea12041f30n%40googlegroups.com 
.


--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/8d15b317-f162-028c-6c12-ea42b5768799%40rbase.com.

Re: [RBASE-L] - Variable Lengths - X.5 Enterprise 10.5.5.11013

Re: [RBASE-L] - Variable Lengths - X.5 Enterprise 10.5.5.11013

Fw: Re[2]: [RBASE-L] - capture autonumber field value | COUNT=INSERT

RE: [RBASE-L] - capture autonumber field value

RE: [RBASE-L] - capture autonumber field value

Re: [RBASE-L] - capture autonumber field value

Re: [RBASE-L] - capture autonumber field value

Re: [RBASE-L] - capture autonumber field value

Re: [RBASE-L] - capture autonumber field value

[RBASE-L] - capture autonumber field value

Re: [RBASE-L] - Variable Lengths - X.5 Enterprise 10.5.5.11013

11 matches

Site Navigation

Mail list logo

Footer information