I have an EDIT USING FormName that edits one row in a table selected from a CHOOSE command. Any ideas on how to edit that selected row but still use Next & Previous buttons in DB Navigator to edit the other rows in the Choose command so we don't have to [exit the form and] go back to CHOOSE command to select the next Smith?
Example: Let's say John Smith, CustID = 150, is selected from all the Smiths in the Cust table (Cho CustID From CUST whe LastName = 'smith') and we edit it (Edi Usi CustMaint whe CustID = 150). What we want to do is use DB Navigator buttons Next & Previous to go through the other Smiths rather than exiting the CustMaint form, Choosing another Smith, and then doing another Edi Usi CustMaint whe CustID = [nextnumber].
As a side note, per ideas from this list, I tried something like EDI USING FromName WHERE CUSTID IN (150, 121, 208, 161,117) - all the Smiths by alpha first name. But the EDI automatically sorts the CUSTID. Is there a way to disable sorting so editing occurs in the given sequence? If not, would this be a worthwhile enhancement request so that Larry's GoNext & GoPrevious properties perform as expected?
Doug
Lawrence Lustig wrote:
edit using &vWhere Then at the click of a button Property TABLE TableName 'CLOSE' Set var vWhere = 'Where somevalue = '''SomeOtherValue'''' Property TABLE TableName 'OPEN' Property TABLE TableName 'REFRESH'and the Recordset changes to the new where condition.... C'mon, can I have it? Please... Please.. Can I??I like what you're thinking! (Although I'm not sure that exact syntax would work, since R:Base would have forgotten the special meaning of vWhere after the macro substitution.) For the sake of completeness, how about: -- To change the underlying where clause and sort order of the form's recordset PROPERTY RBASE_FORM WhereClause 'WHERE ya ya ORDER BY ya ya' -- To filter the current recordset PROPERTY RBASE_FORM Filter 'WHERE ya ya' -- To move to the first matching record in the recordset PROPERTY RBASE_FORM GoFirst 'WHERE ya ya' -- To move to the next matching record in the recordset PROPERTY RBASE_FORM GoNext 'WHERE ya ya' -- To move to the previous matching record in the recordset PROPERTY RBASE_FORM GoPrevious 'WHERE ya ya' -- Larry
