RE: How to change many rows at once on a form?

Malcolm writes... > > One problem I have is how can an end-user update a number of records > in an identical manner without duplicating effort? > E.G. if a query on an ISQL form finds, say, 10 out of a hundred > records how can I update all 10 in the same way without going > edit/escape/next 10 times? > You could do this in 4GL but the user-interface would need careful design. If you're talking about something like "Increase all customers credit limit by 10", then you would most probably write a specific function to do so - trying to do these sort of changes via an ad-hoc query tool could be problematic. If you use 4GL you can provide a much better interface than you could with SQL e.g pop-up validators. It's quite a powerful language and you can write good business applications in it - on the whole it's one of the DBMS languages that I prefer. Paul Hatcher Graduate Associates Ltd +44 81 840 3110 - Phone phatcher@cix.compulink.co.uk +44 81 567 1894 - Fax