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

bt@irl3b2c.att.com writes: >Denis J. Pimple wrote in response to the following query: >>>One problem I have is how can an end-user update a number of records >>>in an identical manner without duplicating effort? ... >I must rise to the defence of ISQL because it is not as limited as you >might be led to believe. ... I didn't mean to denigrate ISQL, especially because I too am a greybeard (silverback?) who remembers the pre-SQL days (remember when Informix was Relational Data Systems?). When I saw the words "end-user update", I immediately assume the writer was refering to perform, and my answers were based on that assumption. I STILL this the writer was refering to perform, but Barry is that SQL is a powerful end-user tool ... IF your end-users are properly trained and aware of the dangers. Dennis >Don't be afraid to let users access the database via RDSQL (the Query >Language option) as well as through forms. I found the time spent >training users in sql paid off in a reduction in the volume >of queries that I (the DBA) have to deal with personally. >BTW, does anyone else remember the pre-SQL version of Informix? >That had an *interactive* update command which gave you the opportunity to >confirm or abort the update on a row-by-row basis. >Alas, it was eliminated in the *improved* Informix-SQL, proving once more >that the latest is not always the greatest. >** Opinions expressed are my own and not necessarily those of my employer >========================================================================= >Barry Toomey Phone +353-1-2822333 >AT&T Network Systems Ireland Fax +353-1-2822864 >Corke Abbey Avenue, email: bt@irl3b2c.att.comm >Bray, uunet: att!irl3b2c!bt >Co. Dublin >Ireland >=========================================================================