There must be an error in the property editor for the SQL Statement.
When I open the TIB_Query with a double-click and then close it
with OK, the SQL
text is sometimes gone (very often if I have no active connection).
But I did not search for the reason, why it is gone.

Andreas Hesse

jwharton@... schrieb:

> Not necessarily. You need to put the SQL in the appropriate statements. The editor is there for your convenience and for
> testing. I could look into the possibility of having it alter the SQL properties if it doesn't do that. I don't recall if I explicitly
> made it do that or not.
>
> Jason Wharton
>
> --------------------------------------------------------------------------------
> --------------------------------------------------------------------------------
> But when I double click and type my SQL into the component, then click
> OK and reopen the component, the SQL is gone. Shouldn't it still be there?
>
>
> --- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
>
>>At 04:41 AM 6/03/2004 +0000, you wrote:
>>
>>>The data pump appears straight forward. Double click and fill in the
>>>statements for the source and destination. However, when I do this the
>>>statements don't persist. What might I be missing?
>>
>>Prepare? (both statements)
>>
>>You have two databases, two statements one transaction.
>>
>>Source database:
>>Statement: select.................
>>prepare
>>
>>Destination
>>Insert...... (or execute statement if it's a SP)
>>check mappings
>>possibly massage
>>prepare
>>
>>Transaction: commit
>>
>>Helen