At 11:21 PM 23/01/2006, Marcelo Machado wrote:

> Dear friends,
>
>My database possesses many fields in several forms. Is
>it possible to only create selects when a form is
>requested?

Could you explain what you mean by "create selects" ?

>I would like to only make that through the application. (I use IBO)
>How can I make that?

Are you asking whether you can bring a dataset into your application
without displaying the results in a visual control?

All SELECT statements are realised by a TIB_Dataset or TDataset
descendant object, through the SQL property of that object. Such
objects - an IB_Query, IB_Cursor, IB_StoredProc, IBOQuery or
IBOStoredProc - can be on a Datamodule (a non-visual container) or a
Form (a container that can display things via visual controls). If
the dataset is active, the application can "see" the records.

Or, are you asking whether you can assign the SELECT statement to a
dataset's SQL property at run-time? If so, the answer is Yes.

We seem to need more clarity about what you actually want to do...

Helen