Ya, I just figured it out by messing around just before I got this. Thank you so much.
What was throwing the errors was: |POPUP_SELECT SELECT Cert, Holder, Shares, Issued, CertID FROM Cert Changed that to: |POPUP_SELECT Cert,Holder,Shares,Issued,CertID And R:Base was happy! On that note, the documentation for this needs to be reviewed. The following is Copy/Pasted from my F1 Help files of my RB76EE updated two weeks ago. --- POPUP_SELECT value Specifies the SELECT clause for Pop-up Menu Values. i.e. SELECT ALL FROM Customer --- At least for me... that says... POPUP_SELECT SELECT ALL FROM Customer *should* work. Maybe that's just me though. There's also no documentation stating that POPUP_RETURN_COLUMN *MUST* be placed *AFTER* your WHERE clause in the event that you use one, and it does if you only want that data returned. Otherwise it returns EVERYTHING specified in your POPUP_SELECT portion of the command. Matthew Burke Pioneer Bank - IT Department Computer Systems Technician 505-627-4415 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Walker, Buddy Sent: Monday, May 11, 2009 4:52 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Syntax Errors - DIALOG w/ POPUP_ENABLED ON Matthew Try setting the where to a variable and adding a order by clause If vholder isn't text then you can omit the (cval('quotes')) Buddy SET VAR vwhr = ('WHERE Cert =' & (cval('quotes')) + .vHolder + (cval('quotes')) & 'AND Holder =' & (cval('quotes')) + .vHolder + (cval('quotes')) & 'order by holder') DIALOG 'Certificate ID:' vCertIDTxt=7 vEndKey 1 + CAPTION 'Segregate Book Entry by CertID' ICON CONFIRM + OPTION BUTTON_OK_CAPTION &Segregate + |BUTTON_CANCEL_CAPTION &Cancel + |POPUP_ENABLED ON + |POPUP_DIALOG_TYPE LOOKUP + |POPUP_TABLE Cert + |POPUP_RETURN_COLUMN CertID + |POPUP_SELECT SELECT Cert, Holder, Shares, Issued, CertID FROM Cert+ |POPUP_WHERE &vwhr + |POPUP_RETURN_TYPE VALUE + |POPUP_CAPTION List of Certificates by CertID + |POPUP_TITLE_TEXT Select Certificate + |POPUP_LINES .vRowCount ***********This works on my database******** SET VAR vrowcount INTEGER = 5 set var vwhr = ('WHERE DeptID =' & (CVAL('QUOTES')) + 'Med' + (CVAL('QUOTES')) & 'ORDER BY CourseDesc') DIALOG 'Certificate ID:' vcertidtxt=7 vendkey 1 + CAPTION 'Segregate Book Entry by CertID' ICON confirm + OPTION BUTTON_OK_CAPTION &Segregate + |BUTTON_CANCEL_CAPTION &Cancel + |POPUP_ENABLED ON + |POPUP_DIALOG_TYPE LOOKUP + |POPUP_TABLE CourseDesc + |POPUP_RETURN_COLUMN CourseID + |POPUP_SELECT CourseDesc,CourseAbbrev,DeptID,CourseType + |POPUP_WHERE &vwhr + |POPUP_RETURN_TYPE VALUES + |POPUP_CAPTION Certificates BY CertID + |POPUP_TITLE_TEXT Certificate + |POPUP_LINES .vRowCount RETURN ****************************************** ________________________________ From: [email protected] on behalf of Matthew Burke Sent: Mon 5/11/2009 5:52 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Syntax Errors - DIALOG w/ POPUP_ENABLED ON I'm getting syntax errors with the following DIALOG command and I can't figure out why. Can't find much in the help files on proper POPUP syntax. DIALOG 'Certificate ID:' vCertIDTxt=7 vEndKey 1 + CAPTION 'Segregate Book Entry by CertID' ICON CONFIRM + OPTION BUTTON_OK_CAPTION &Segregate + |BUTTON_CANCEL_CAPTION &Cancel + |POPUP_ENABLED ON + |POPUP_DIALOG_TYPE LOOKUP + |POPUP_TABLE Cert + |POPUP_RETURN_COLUMN CertID + |POPUP_SELECT SELECT Cert, Holder, Shares, Issued, CertID FROM Cert + |POPUP_WHERE WHERE Cert = .vHolder AND Holder = .vHolder + |POPUP_RETURN_TYPE VALUE + |POPUP_CAPTION List of Certificates by CertID + |POPUP_TITLE_TEXT Select Certificate + |POPUP_LINES .vRowCount Matthew Burke Pioneer Bank - IT Department Computer Systems Technician 505-627-4415
