Getting SQL Server error

I am using Delphi 7, ADO and SQL Server 2000. I want know a way to get
all the information about a sql execution error:



Command:

"Select

*

Fr om

Sales

"



Error message:

"Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'Fr'."



When the error occurs, Delphi generates an exception (EDatabaseError),
witch gives-me only a message "Line 3: Incorrect syntax near 'om'."



Emile Petrus












.

Relevant Pages

  • Re: Delphi 8 and ado.net
    ... > different to using say ADO in Delphi? ... The Delphi ADO implementation is basically a wrapper around the Recordset ... have cursors into the database, there are no cursors in ADO.NET. ...
    (borland.public.delphi.non-technical)
  • Delphi 2006 and SQL Server
    ... Congratulations to all the guys at Borland. ... Delphi 2006 is a great ... The application that I have developed is a Delphi VCL Win32 ... there has not been enough emphasis at Borland to support SQL Server. ...
    (borland.public.delphi.non-technical)
  • Re: sp_prepare statement
    ... >I have an application built in Delphi, that makes a connection to SQL Server ... the querys apear to be executed ... Does the Delphi, or de ADO used by Delphi, ...
    (borland.public.delphi.database.ado)
  • Re: Sub Selects?
    ... > some nice Delphi DB technique to do this, or should I just build up the ... Due to the way that the ado ... lets assume that you have a list called SelectedIds ... I'd recommend against using the filtering method. ...
    (borland.public.delphi.database.ado)
  • Re: recursive sp, fmtonly, ado,
    ... This was the first thing I've checked, because I suspect Delphi. ... It's in somewhere inside ADO or OLEDB. ... >> create procedure fmttest ...
    (microsoft.public.sqlserver.programming)