I'm an old mainframer. I'm starting a rewrite of a legacy payroll program. What language will couple most conveniently to a MySQL backend? I would like something that can do BCD math and use generators to build code for screen forms under Windows. It would be nice if a generator was available to handle menus too. I don't really want to re-invent the wheel.
I am familiar with assembler, C, C++, fortran, cobol, apl, rexx, basic, clipper and some other archaic things.
The generators to build screen forms are part of a lot of programming language and have names like Resource Editor or GUI Builder... So you could use among others
- Visual C/C++
- Borlands C++ Builder
- Visual Basic
- .NET stuff
- Common Lisp
- and and and
to access Databases on Windows you usually want to use ODBC, or some other abstraction layer like e.g JDBC...
So let us assume you do not want to learn something new. Then you need either a basic, rexx, dbase, C or C++
Because it's used nearly everywhere I suggest you use some tools from Microsoft, it seems the way to go on Windows is with .NET.
The learning curve for MS tools is very different, without beeing extra carful you might get caught in the "just click it together" trap and end with a crude mixture of code for handling the GUI and program logic.
Or check out what path dbase has gone.
The requirements are such that a lot of tools are available. So what preferences you have? What system do you plan to run you application on? Have you considered some sort of Web access? Do you want to extend the program with some sort of scripting? Does it really have to be MySQL? how about some other "heavy weight" DB System? Maybe you want to migrate you software to something exsiting, because this applications are so common and there are so many alternatives available.