Wednesday, November 26, 2025 Tip of the Day: New QUOTEBLANKS Setting Product: R:BASE 11 Build: 11.0.3.11120 or higher Section: Settings Keywords: QUOTEBLANKS, Variable, Ampersand, NULL, QUOTES
A new QUOTEBLANKS setting has been implemented to control whether R:BASE automatically adds quote characters to blank string values derived from variables. This behavior occurs when using dotted or ampersand variables (`.VarName` or `&VarName`) and the NULL setting is configured to produce blank/space values. The quote characters applied are determined by the current QUOTES database setting. SET QUOTEBLANKS ON|OFF The default value is ON. When QUOTEBLANKS is set to OFF, and NULL is defined as blank/space values, NULL variable values will "not" be enclosed in quotes. The appropriate value for QUOTEBLANKS depends on your application logic. For example, consider a form that includes a list view with the following dynamic WHERE clause: SELECT DISTINCT DeliveryLocation, DeliveryDate + FROM Deliveries + WHERE &vDynamicCondition DeliveryDate >= .vDeliveryDate The variable vDynamicCondition may be NULL or may contain a condition that includes the AND keyword. If vDynamicCondition is NULL and QUOTEBLANKS is set to ON, the system adds quotes around the blank string. In this case, those quotes would cause the query to fail. Therefore, QUOTEBLANKS must be set to OFF for this scenario. The Support Team 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 visit https://groups.google.com/d/msgid/rbase-l/1102383629.414444.1764141767067%40email.ionos.com.
