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
