Hi,
In my ODBC Stage i have selected user defined queries, I want to write a two queries in Enter SQL box. How do i separate two quries, Whether its possible???
First i have to delete records from the table and i have to insert into the same table, Please clearify...
ODBC Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 86
- Joined: Mon Nov 27, 2006 3:42 am
- Location: Wilmington
You can use DRS stage and write a the delete statement in the before sql tab.
When you say "first delete and then insert", an option already exists for it. Is this a selective delete. Give more info on the delete 'where predicate'.
When you say "first delete and then insert", an option already exists for it. Is this a selective delete. Give more info on the delete 'where predicate'.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: