Clive's way works also, but in that case, an index on column consultnr will be ignored.
Bill On Mon, May 24, 2010 at 6:40 AM, Bill Downall < [email protected]> wrote: > Luc, > > Put the entire condition in parentheses: > > SELECT * FROM Consult WHERE (consultnr = .vconsult) > > Bill > > > On Mon, May 24, 2010 at 2:27 AM, Luc Delcoigne > <[email protected]>wrote: > >> Hi All, >> >> I've encounterd the following problem. >> >> I want to create and save a new view: >> >> "Select * From Consult where consultnr = .vconsult". >> >> THe problem is that when I save this view, my var vconsult is >> automatically replaced by the value of the first row in the table. >> So when I re-open the view the view definition is changed to; >> >> "Select * from Consult where consultnr = '10052301'". >> >> Is there a way to base a table on a view that doesn't automatically change >> the view definition ? >> >> Tx, >> >> Luc Delcoigne >> > >
