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 >
