Subject Re: [IBO] FieldsVisible Question
Author Svein Erling Tysvær
OK, as long as all fields are required :o}

try something like
counter: Integer;
for counter:=0 to lee_query.fields.ColumnCount-1 do

I've never done anything like this so you probably have some fiddling
around to do - for all I know it may not even work. It certainly won't work
until you've prepared the query.


At 13:59 09.03.2001 -0000, you wrote:
>Sorry that I used the word Table, I use a Query but coming from
>Access the word Table is branded in my mind.
>I am doing the things you propose, but in this case the (Table) is a
>customer table and a lot of fields are not used all the time but are
>needed to check on other conditions.
>So I only need maybe 5 fields to display to the customer but I need a
>lot more fields to do processing on.
>It would be handy to set all the fields to not visible and then set
>only the ones who must be visible to visible.
>--- In IBObjects@y..., Svein Erling Tysvær
><svein.erling.tysvaer@k...> wrote:
>> Lee,
>> my best advice is to stop thinking tables and start thinking
>queries. For
>> desktop databases tables are a nice invention, but for
>client/server they
>> are a nightmare. It takes time to transfer rows from the server to
>> client, so try to minimize
>> a) the number of rows
>> b) the amount of information in each row
>> Use a TIB_Query (or TIBOQuery) and set the sql to something like
>> SELECT <fieldlist>
>> FROM <table>
>> WHERE <somelimitingcondition>
>> where <fieldlist> includes only those fields you want to display +
>> fields you want to process (for these last fields you set visible to
>> false). Also, try to make the <somelimitingcondition> as limiting
>as possible.
>> HTH,
>> Set
>> At 13:24 09.03.2001 -0000, you wrote:
>> >I have a Table with 150 fields.
>> >For some grid's I only need 5 fields to be visible.
>> >If I understand it correctly, I can , in a Prepare_Sql only change
>> >the FieldsVisible parameter to 'False', I can set it to 'True' but
>> >this hase no purpose since implicitly all fields are visible.
>> >So implicitly all fields that are not 'False' will be visible.
>> >Wich means that I have to set manually 145 fields to 'False'.
>> >I really hope there is some other way to do this.
>> >Is there a way to say in one statement that all fields are NOT
>> >visible, so that I only have to put 5 fields to Visible ?
>> >
>> > with FieldsVisible do begin
>> > Values['NAME'] := 'F';
>> > end;
>> >
>> >Regards
>> >
>> >Lee
>> >
>> >
>> >
>> >
>> >
>> >Your use of Yahoo! Groups is subject to
>> >
>> >
>> >
>Your use of Yahoo! Groups is subject to