Re: Getting SQL Server error

The error your getting is right, you have a space in the keyword FROM.
However, if you want more you can always checks the Errors collection.

hth,

brian

--
Got a big event coming up? Let us
help coordinate your event. For more
visit www.kissemgoodbye.com
"Emile Petrus Abi-Abib" <emile@xxxxxxxxxxxx> wrote in message
news:45420a22@xxxxxxxxxxxxxxxxxxxxxxxxx
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