graeme_edwards2000 wrote:

> I take the point that in most cases Select * is not good practice.

Let me put that more strongly. The ability to use SELECT * outside of
interactive utilities is the single worse feature of SQL. Among the
strengths of relational databases and Firebird in particular are the
separation of the physical and logical format of data and the consequent
flexibility of the logical format. You can add fields, change fields,
drop fields, and reorder fields as your application requirements change.
Unless you use SELECT *, in which case that whole powerful mechanism
runs up against somebody who needed to learn to type, and applications
get unpredictable errors.

Regards,


Ann