Razzak, Here's the WHERE clause from the WHERE Clause block in the DB-Edit ....
WHERE EmpStatus = 'Y' AND EmpLevel NOT IN (0) ORDER BY EmpFirstName ASC TITLE 'Select Technician...' CAPTION 'Employee Name...' LINES 20 OPTION LIST_FONT_NAME Courier | LIST_FONT_SIZE 12 Once I removed everything from TITLE to the end the popup worked fine. I had removed from LINES to the end just to see if it would work at first but it didn't. Jan ----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Tuesday, July 26, 2005 2:06 PM Subject: [RBG7-L] - Re: 7.5 problem > > At 04:29 PM 7/26/2005, Jan Johansen wrote: > > >I know what the problem is with my bad ORDER BY message. I just > >don't know how big an issue it is. > > > >Back when I first started putting some of my forms together in > >7.1 I got quite a lot of good information and tricks from the > >list. One of them in particular was using the pop-ups for > >DB-Edits. You could put all kinds of formatting and stuff like > >that in the WHERE section. > >Apparantly since you can now do message and title and different > >fonts when you set up the pop-up, 7.5 doesn't like them in the > >where box. > > > Jan, > > Can you post the text for WHERE clause? > > Better yet, prepare a sample along with all "details" and send > it to mailto:[EMAIL PROTECTED] > > Let's take a look at your form and see what else is going on. > > Very Best R:egards, > > Razzak. > >
