Multiple Insert / update statements get error SQL?

From: pam (pdianne_at_hotmail.com)
Date: 02/24/04

  • Next message: Brian Bushay TeamB: "Re: Importing the type library" 
    Date: 23 Feb 2004 16:00:53 -0800

    I'm trying to run a single SQl statement containing multiple inserts /
    adds / deletes. I need to be able to trap errors and the associated
    offending SQL statement. TAdoConnection.Errors gets me some useful
    information on the error, but I can't seem to find how to extract the
    offending SQL statement.

    Interesting side problem: If the collection of SQL statements
    completes without errors and I go to chech the RowsAffected property,
    it's always 1.

    TIA,

    Pam

  • Next message: Brian Bushay TeamB: "Re: Importing the type library"

    Relevant Pages

    • Re: HELP WITH UPDATE QUERY
      ... each selected items in the list, and, in the example, make an SQL statement ... the user wants to select MULTIPLE items from this list ... query named qrProd and the list box is from that same query, ... I ASSUMED the control name was. ...
      (microsoft.public.access.queries)
    • Re: Idea of SQL integration
      ... this issues like compiler directive e.g. ASM. ... is no general solution for multiple DB vendors (sas for multiple ... It gets a SQL statement and another parameter: Open, Execute, ExecuteAndFree. ...
      (borland.public.delphi.non-technical)
    • Re: Conditional test to combine multiple records
      ... >> current sql statement. ... (or just switch to the query grid and do the ... >>> one record becaue I count the total number of shipped orders in another ... >>> over the course of multiple dates. ...
      (microsoft.public.access.queries)
    • Re: Is this possible
      ... When you are unsure of a more complex SQL statement try opening Access and ... Multiple States ... > Multiple Codes from another field, ...
      (microsoft.public.vb.general.discussion)
    • Re: confusing transactions with sqldmo
      ... > Like I said, when running from many different Query Analyzer windows, ... I don't think just because you are running multiple threads you can run ... one SQL statement per connection unless ... one SQL statement per connection. ...
      (microsoft.public.sqlserver.programming)