G'day Luc,
Select * From Consult where consultnr = (.vconsult) Regards Clive Williams From: [email protected] [mailto:[email protected]] On Behalf Of Luc Delcoigne Sent: Monday, 24 May 2010 16:27 To: RBASE-L Mailing List Subject: [RBASE-L] - view with var problem 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 __________ Information from ESET Smart Security, version of virus signature database 5139 (20100523) __________ The message was checked by ESET Smart Security. http://www.eset.com
