|Subject||Re: [firebird-support] sql question.|
> As a habit - I would recommend adopting NOT using the * in your selects.Understood. Bad Example. It was taken as-is from my prototype code and
> Don't be lazy define the fields you want.
the reason it's done this way is because the DB Design is still not
finished yet. I suppose it *is* 'laziness'...:)
> Secondly - you may want to create views for this select, then you can returnA view, ok. A bit difficult in my case, but workable. Thank you.
> the field>100 clause.
Would appreciate any other workaround to the problem.
TIA & Regards,