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