Is there a way to allow the user to enter a search string or "where clause" ? I've done it in 2.11 by assigning a variable and having the variable filled in (fillin x using "Enter search criteria") and then taking that variable (x) and placing it after the Where in a select command ie. Select LName from Job where .x (x being something along the lines of - date eq 12/1/2009 or Month eq May and Week eq One). Remember, this is from 2.11 so eq works and quotes aren't needed. I have tried this kind of set-up in 7.6, but get a syntax incorrect error, even with correct use of = and '.
Thanks, David Fowler
