I have a job restructuring a DB. I am taking a set of tables I created a long time ago for
a client & improving them structurally.

They want to preserve the data they have. Therefore I am writing scripts to transfer the
old data into the new tables. This requires fairly complex SQL code to be written, with
quite a lot of multi-part scripts.

Does anyone out there have a "SQL IDE" ... i.e. a tool that will syntax check SQL line by
line & spot lines where errors have been made. At the moment I am working with DBSys plus
some little tools I have written myself. With a very long script the DBSys error message
such as "FROM expected but ( found" is not very useful!

I already have a simple SQL editor that I have written myself in Delphi that can test sets
of SQL statements & report errors, but it doesn't report errors line-by-line in the way
the Delphi IDE does with pascal code.

Adam,

<< At the moment I am working with DBSys plus some little tools I have
written myself. With a very long script the DBSys error message
such as "FROM expected but ( found" is not very useful!  >>

Is this 3.x or 4.x ?  DBSYS 4.x points directly to the position in the SQL
where the error is.

--
Tim Young
Elevate Software
www.elevatesoft.com

3.30 ... I *really* am going to have to upgrade! ... I am waiting for v 5, any news on when?

Adam

Adam,

<< 3.30 ... I *really* am going to have to upgrade! ... I am waiting for v
5, any news on when? >>

Still working.  We're really being tight with the SQL standards, so I have
to dot all of the I's and cross all of the T's, so to speak.

--
Tim Young
Elevate Software
www.elevatesoft.com