Re: Closing recordset generates exception

Yes, the table exist within an old legacy database ( Pervasive SQL
9.5). Adding new records this way is no problem. This routine should
normally add only new records. Just during test/development phase I ran
into this exception and couldn't explain this 'Close exeption'
behaviour.

Have you examined the errors collection off your Conn object?
Is the number of errors > 0?
No clues from the errors collection?

In general I would expect either a
provider specific exception
ADO exception

I cant remember which category FK constraint violations fall in this.

Stephen Howe


.

Relevant Pages

  • Re: Getting SQL Server error
    ... I know that sql command has an error. ... if you want more you can always checks the Errors collection. ... When the error occurs, Delphi generates an exception ...
    (borland.public.delphi.database.ado)
  • Re: Why isnt ADOExpress throwing an exception on error?
    ... What i don't understand is why the same errorlevel causes an exception to ... the Errors collection so all errors are surfaced. ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: Error Question
    ... i dont know how to check the type of exception in my ... messageformat() Method ... Errors Collection in SqlException ...
    (microsoft.public.dotnet.languages.csharp)
  • Error Question
    ... i dont know how to check the type of exception in my ... messageformat() Method ... Errors Collection in SqlException ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Garbage collection and async operations
    ... routine or its delegate goes out of scope. ... mechanism is independent of whether or not I call EndInvoke. ... Delegate (which presumably holds the return value from the invoked ... and the Exception object thrown by the invoked routine). ...
    (microsoft.public.dotnet.framework)