Subject Re: [IBO] Using EditSQL in a program
Author Helen Borrie
At 07:01 AM 21/04/2008, you wrote:
>Configuration
>1. IBO 4.8.7
>2. Examining the possibilities of 'integrating' a TIB_Query with a non
>IBO grid.
>3. Query contains a join - only one table being edited.
>4. Used the query to set up the EditSQL property.
>
>Question.. Can the EditSQL be used directly in a program to perform
>editing, when the query is not attached to any IBO data aware components?

No. It's a property of a dataset.


>Comment. The only way I have found to do this so far is to take the
>TIB_Query.EditSQL.text, insert into a TIB_dsql and use appropriately.

That's exactly what the dataset does anyway.

>Would be 'cleaner' to use the TIB_Query somehow, if possible.

Exactly. But if you want to use a non-IBO grid, why not just use a TIBOQuery and its own XxxxxSQL properties directly?

Helen