Any language you like as long as it can read and write text files and run another exe with command line arguments.
Some sort of rapid application development (rad) visual language is best, visual basic, delphi etc.
I wrote a simple program that shows how to call the compiler and compile code. It doesn't do it identically to the ide but works.
Download here, it's on a free server that goes down fairly often.
http://winch.8bit.co.uk/db/proedit.htm
Writeing a simple ide is relativly simple as it is just a glorified text editor. Making a more complex ide is a lot harder, sytax higlighting etc. can be quite hard to keep on top of.
I forget who posted this next bit, I think it was Ian M who reposted it and it was orignally by GuyS the ide coder, but I can't quite remeber.
Quote: "Quote: "On the command line, you pass the name of the temporary project file saved in the temp folder
During the compilation, the IDE monitors for termination of the compiler process
The compiler stores current line compilation messages in a filemapped file called DBPROEDITORMESSAGE that is mapped to the swap file
During compilation, you can update the status bar from the contents - it is a 4 byte integer that is updated by the compiler.
If there is an error, the compiler broadcasts WM_USER+0 message to forms with a class name of TDBPROEDITOR. If it appears, you can open the filemap and pull out the string that was stored in the filemap. You can then parse the string for a line number, then open the offending source file, highlight the line number reported, and pop up the error message.""