Hello Helen,

thank you for your detailed response.
I will have a look at the specified locations to gather more information.

>If you want a specific column order, then don't use SELECT *. Use the

In the meanwhile I found, that the "GridLinks" property of Ib_Grid allows me to determain the column oder even with a query using select *.
The grid displays the columns in the order I put them into the GridLinks.

Thanks again
Rainer




-----Ursprüngliche Nachricht-----
Von: Helen Borrie [mailto:helebor@...]
Gesendet: Mittwoch, 1. Oktober 2003 10:54
An: IBObjects@yahoogroups.com
Betreff: Re: AW: [IBO] IbQuery , IbGrid question


At 10:30 AM 1/10/2003 +0200, you wrote:

>Hello Helen,
>
>sorry for my stupid question, but conserning IBObjects I am still quit a
>newbie.
>Reading your respons, im must be quit easy to do this, but how can I tell
>the grid wich colums do display in wich order?
>The select I use is a "SELECT * FORM...".

If you want a specific column order, then don't use SELECT *. Use the
Query Editor to specify the columns (including non-visible ones) in the
left-to-right order that you want. This isn't anything particular to IBO -
it's basic SQL technique. However, it happens that IBO -- along with other
interfaces that accept output sets -- needs to get the output in the right
column order for certain things.

In the IBO case, the behaviours of the native controls are "controlled by
the data" - the reverse situation to the VCL, where the controls control
the behaviours of the data sets.

So all of your UI rules for the the data are set in the dataset
objects. If you double-click on an IB_Query or IB_Cursor component, you'll
find a lot of properties there. Look through those - Fields properties and
ColumnAttributes - and experiment with their effects on your ib_grid. (You
can also set most of these properties and attributes in run-time code - see
documentation referred to below).

>
>Just in general, is there some documentation available, answering this typ
>of questions?
>all I have at the moment is the "gettingstarted.hlp"

Actually, all of this is intensively documented in the GSG. You will also
find more stuff in the TI papers at the TechInfo page of the website, and
working demos in the Samples folder of your IBO installation.

Helen




Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=256694.4002236.5216697.1261774/D=egroupweb/S=1705007183:HM/A=1784493/R=0/id=noscript/SIG=11q7p9e7k/*http://webevents.yahoo.com/universal/intolerablecruelty/>
<http://us.adserver.yahoo.com/l?M=256694.4002236.5216697.1261774/D=egroupmail/S=:HM/A=1784493/rand=797380555>

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]