Does this work for you?
SET VAR v_amp_yellowLine TEXT = +
('WHERE contributionYear =' & .vyearTxt & 'AND donationGross >' &
(CTXT(0))' )
... ALTERNATELY:
SET VAR v_amp_yellowLine TEXT = +
('WHERE contributionYear =' & (CHAR(039)) + .vyearTxt + (CHAR(039)) &
'AND donationGross >' & (CTXT(0))' )
CHOOSE ... +
... +
&v_amp_yellowLine +
...
Best, Bruce
Bruce A. Chitiea
SafeSectors, Inc.
1142 S Diamond Bar Blvd # 442
Diamond Bar CA 91765-2203
[email protected]
(909) 238-9012 m
------ Original Message ------
From "billnie50" <[email protected]>
To "RBASE-L" <[email protected]>
Date 1/13/2025 3:13:01 PM
Subject [RBASE-L] - CHOOSE and SELECT statements failing
I have used this code for several months and it has recently failed to
return results. When I remove the yellow portion the command works as
expected. Am I using too many resources with the original command? Is
there a way to predict when I am going to cause a problem with too long
of a command? Thanks much for any suggestions.
SET VAR vlines = 20
CHOOSE vcustIDselect FOR #VALUES +
FOR DISTINCT
((LJS(CustLastName,15))&(LJS(CustName,35))&'-'&(CTXT(custID))), custID
+
FROM memberDonation +
WHERE ContributionYear = .vyeartxt AND donationGross > 0 +
CHKBOX 1 TITLE 'Select one Member and click [OK] button'
+
CAPTION 'List of Members with Donations' LINES .vlines FORMATTED +
OPTION LIST_FONT_COLOR WHITE|LIST_BACK_COLOR BLUE +
|TITLE_FONT_COLOR NAVY|TITLE_BACK_COLOR WHITE +
|WINDOW_BACK_COLOR WHITE|TITLE_FONT_SIZE 18 +
|TITLE_FONT_NAME times new roman|WINDOW_CAPTION +
|BUTTONS_SHOW_GLYPH ON|BUTTONS_BACK_COLOR WHITE +
|THEMENAME .vInputTheme
--
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/d1ac2ab2-57e6-4d3e-b52b-3e219f051854n%40googlegroups.com
<https://groups.google.com/d/msgid/rbase-l/d1ac2ab2-57e6-4d3e-b52b-3e219f051854n%40googlegroups.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 visit
https://groups.google.com/d/msgid/rbase-l/em8a58fcea-2609-47ec-8d60-438e45948307%40fb462284.com.
