Re: Ado, Transaction, Multiline statements?

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 01/24/05 

Date: Sun, 23 Jan 2005 22:04:19 -0600

>My concern is
>1) is it good form to do multi line inserts like this?
It is not bad form.

>2) Why didn't I get an exception or can I read an error from someplace? My
>program thinks everything was inserted and there were no errors; this is
>VERY bad.
Not all errors generated by SQL server will generate an exception in Delphi
You need to look at the TadoConnection.errors collection to find out what SQL
server is generating

> 

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com

Relevant Pages

  • Re: Field width
    ... In SQL server the following code will populate AdoDataset1 with the field ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: XP_CmdShell and OLE provider
    ... First is the Foxpro Oledb driver installed on the machine where SQL server is ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: Update Query
    ... >This syntax should work for SQL server and Access ... >Brian Bushay (TeamB) ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Re: ADO connection
    ... That is not something you can detect with ADO or SQL server ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: ADO Connection in a Service App
    ... Brian Bushay TeamB wrote: ... Not associated with a trusted SQL Server Connection ... When I run the same service as an application the connection works fine. ...
    (borland.public.delphi.database.ado)
Quantcast