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