Subject Re: [IBO] ib_query ignores my data!
Author David Trudgett
At 2001-03-23 10:35 +1100, "Geoff Worboys" <geoff@...>

> > In my experience, I have never felt the need to trim right spaces.
>Just curious, what sort of applications do you write? Business
>systems, scientific, repository or what?
>In the interactive business applications that I write, the users are
>given access to input data into fields. No assumptions are made about
>the users computer expertise or level of care. The data is all
>carefully validated and reformated according to the business rules -
>not according to user whim.

Seems to me that the trimming behaviour is only an issue on data entry
components, and not on database access components like IB_Query. It appears
to me that interactivity is the source of the 99% of cases that require
trimming. That means that the interactive components, or the forms, should
be responsible for trimming user input. Of course, what "should" happen is
often not what actually does happen when doing RAD development of business

David Trudgett