Monday, August 16, 2024
Tip of the Day: Enhanced Character Limits for SELECT Functions
Product.......: R:BASE 11
Build.........: 11.0.1.40815 or higher
Section.......: Commands
Keywords......: SELECT, LISTOF, Characters, Functions
Did you know that you can now use up to 30,000 characters for the SELECT...LISTOF function return value?
The SELECT...LISTOF function return value size limit was increased to 30,000 characters from 10,000, allowing much more content to be retrieved.
The LISTOF function creates a text string of the values separated by the current comma delimiter character. The LISTOF function can be used with the "SELECT ... INTO" to populate a variable with a list of values, which can then be used in a CHOOSE command with the #LIST option.
https://www.rbase.com/support/rsyntax/selectfunctions.html
The SELECT command functions (MIN, MAX, LISTOF, etc.) were also enhanced to use up to the first 2,000 characters (from 80) for NOTE data type values. SELECT functions can provide summary data about a group of rows in a table or for all rows in a table.
Very Best R:egards,
Razzak.
R:BASE Technologies, Inc.
https://www.rbase.com
-- Tip of the Day: Enhanced Character Limits for SELECT Functions
Product.......: R:BASE 11
Build.........: 11.0.1.40815 or higher
Section.......: Commands
Keywords......: SELECT, LISTOF, Characters, Functions
Did you know that you can now use up to 30,000 characters for the SELECT...LISTOF function return value?
The SELECT...LISTOF function return value size limit was increased to 30,000 characters from 10,000, allowing much more content to be retrieved.
The LISTOF function creates a text string of the values separated by the current comma delimiter character. The LISTOF function can be used with the "SELECT ... INTO" to populate a variable with a list of values, which can then be used in a CHOOSE command with the #LIST option.
https://www.rbase.com/support/rsyntax/selectfunctions.html
The SELECT command functions (MIN, MAX, LISTOF, etc.) were also enhanced to use up to the first 2,000 characters (from 80) for NOTE data type values. SELECT functions can provide summary data about a group of rows in a table or for all rows in a table.
Very Best R:egards,
Razzak.
R:BASE Technologies, Inc.
https://www.rbase.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 [email protected].
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/578429349.4481643.1724077982869%40email.ionos.com.
