Avatar of smokysteve
 asked on

What language to use for a total rewrite of a legacy payroll program?

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.
Programming Languages-OtherCOBOL

Avatar of undefined
Last Comment

8/22/2022 - Mon
F. Dominicus

Well that is mostly a question of preference. Usually all Languages with some C interface allow easy access to MySQL.
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
- Smalltalk
- Common Lisp
- Delphi
- Java
- 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.



Have you considered looking at purchasing an off-the-shelf payroll solution. These will tend to be much cheaper in the long run because of the ecomonies of scale etc. and they are tried and tested solutions. Most also provide several API's that can be used for customization and custom reporting functions.

View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck