Good Afternoon TOAD team,
I'm using TOAD beta 12.11.0.16. I had a customized, edited, SQL statement with a filter. Nothing unusual. When I changed the filter name (and copied some of the fiter) the SQL was destroyed to this:
SELECT common.DEC (w2w_password, common.fk (101)) “Grantee_Password”,
(SELECT PROGRAM FROM COMMON.EIMS_PROGRAMS
Where
/* Dave McEachern test
*/
(CONT_EMAIL in (‘dmceachern@cds2.com’, 'dmceachern1@cds2.com ', ‘dmceachern@kc.rr.com’)
OR STATE = ‘KS’)
AND SEQ_NO = 1
ORDER BY DATE_LAST ASC NULLS LAST
It has like this:
SELECT common.DEC (w2w_password, common.fk (101)) “Grantee_Password”,
(SELECT PROGRAM FROM COMMON.EIMS_PROGRAMS where PROG_CODE = w.PROG_CODE and INST_TYPE = w.INST_TYPE ) PROGRAM,
ROWID, RCIP_NO, SEQ_NO, W2W_PASSWORD,
W2W_PIN, CONT_NAME, ADDR1,
ADDR2, CITY, STATE,
ZIP, CONT_PHONE, CONT_FAX,
CONT_EMAIL, PROG_CODE, INST_TYPE,
DATE_LAST, DATE_NOTIFIED, DATA_ADDED_BY,
NOTIFICATION_SENT_BY, PRIM_CONTACT, RCIP_NAME,
CONT_TITLE, RCIP_TYPE
FROM COMMON.WHO_ARE_YOU w
Where
/* Dave McEachern test
*/
(CONT_EMAIL in (‘dmceachern@cds2.com’, 'dmceachern1@cds2.com ', ‘dmceachern@kc.rr.com’)
OR STATE = ‘KS’)
AND SEQ_NO = 1
ORDER BY DATE_LAST ASC NULLS LAST
Only happened once, so far…
Larry
703-508-4945