Re: RE : [Iodbc-list] Nested requests

[<iod...@li...>]

iod...@li... writes:

[snip]
>    2) Create a stored procedure in your Database to do the operations.
>    This will require support from your DB and place some limitations on
>    what you can do, or where you can output the results. Would likely be
>    1 SQL call.
>
>    The best way will depend on the skills, databases and development
>    environments you have available. There is not really a make a compound
>    statement like you appear to want.

On the subject of compound statements, one further tip that might come in
handy: transactions. You could, for example, do:

    begin work;
      select id from sometable;
      <other statements generated dynamically in your host language,
       based on the id>
      delete from sometable where id=whatever;
    commit;

In ODBC you can avoid the first and last lines, and use a SQLCommit() call
in conjunction with setting the autocommit behaviour, to delimit the
transactions.

HTH,

~Tim
-- 
Product Development Consultant
OpenLink Software
Tel: +44 (0) 20 8681 7701
Web: <http://www.openlinksw.com>
Universal Data Access & Data Integration Technology Providers