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.
