Paul
You can make use of a (temp) view and then it is possible to change the where clause. CREATE TEMP VIEW V_CCT_CLIENT AS SELECT ALL FROM CCT_CLIENT WHERE &V_CLIENT_SELECTIE Be sure to make use of & variable If you use a variable in the where clause make sure to use extra brackets. Otherwise Rbase will possibly replace the variable by its content the moment the view is cretated. In the form you can use statements in an EEP like: PROPERTY TABLE V_CCT_CLIENT 'CLOSE' n Change the where clause PROPERTY TABLE V_CCT_CLIENT 'OPEN' BTW: Be aware it is possible to insert, update and delete in an one table view. It could be very handy Tony From: [email protected] [mailto:[email protected]] On Behalf Of Paul Buckley Sent: zondag 1 mei 2016 22:06 To: [email protected] Subject: [RBASE-L] - Change the Where Clause from a Button on the Form Good Afternoon, I’m using the latest 9.5(64) and I’d like to open a form normally using: Edit Using Form1 where column1 = ‘A’. Then from a button (or whatever) on the form change the where clause and refresh the data, i.e. where column1 = ‘B’. Any blue’s clues would be greatly appreciated. Thanks, Paul Buckley -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
