Howdy. New guy here. I have designed and coded software in VB and MS Access VBA for I guess about 30 years. I’ve developed some sizeable and successful apps along the way, to include one that I am currently looking to make cross-platform. It is important to note that my app is not a web candidate, not a Clouder, strictly desktop and hopefully someday soon, a mobile app.
One really great thing about MS Access, in addition to be an excellent rapid prototyping environment, it the strength and quality of 3rd Pty tools, not least of which is FMS inc.'s venerable Developer’s Suite for VB, Access VBA, C# and .NET.
It has plugins for the VS IDE that include Detective, which compares differences between any two versions of something including screens, menus and reports. Their masterpiece, a full-blown diagnostic system called Access Analyzer, is so thorough that there is really no reason at all for an Access app to have ANY bugs or sloppy code.
Their FMS Sourcebook contains hundreds of “ready-to-use code snippets, classes, how-to’s, and articles. It also allows you to manage your own code and share knowledge within a team by using the fully searchable code repository. Total .NET SourceBook provides both a full-featured standalone Code Explorer, and an integrated Visual Studio Add-In.”
I have found the quality of their products and code to be impeccable and indispensable.
My question for you folks is, what develop tools, diagnostics and source code libraries are there for the XoJo environment?
Over on Stack Overflow, Paul Lefebvre turned me on to Xojo and I really like what I’m seeing. I’m curious about what symbiotic benefits might tie back to Xojo’s VB roots. For instance, I’d bet the FMS Sourcebook’s code repository could be used for Xojo code. Maybe some of the FMS Classes m iiiiiight run in Xojo? Which begs the next question:
Are there any conversion or migration tools to help with moving twenty years of VB into Xojo? Maybe even a truckload of macros to do source code Search And Replace in Notepad+ or something? If not, has anyone kept track or documented the differences between the two languages? If so, perhaps a basic VB-Xojo Converter could be done with not all that much effort, at least on the code.
It’s been said that MS Access is the most popular database product in the world (and the most denigrated by ‘real’ IT people, I know). There are probably thousands of those apps that have become legacy. And, many of those really could us a good ■■■■ kicking out into the cross-platform world. I looked at File Maker, another impressive piece of work, but it couldn’t make the connection for me. I think maybe Xojo can, especially if I can get ahold of a good set of tools.
I think it could be a real opportunity for the right developer to make such a Converter. I might be able to do it, given enough time to get a=familiar with Xojo, bit for someone already up to speed on both languages, it could be done much quicker and better. I’m NOT wanting to get into the Utilities business.
I will say, though, that in one of my previous lives as a software dev SME for the DOD I did build an entire diagnostic system to snake check PowerBuilder (remember that?) source code for a critical military system and I modeled it after FMS’ Access Analyzer. It was groundbreaking, they’d had nothing remotely like it. One the first day it exposed years worth of dead code, silly memory allocations and bugs-in-waiting. I ran it against every subsequent release of the software for five years and their bug reports dropped like a stone.
So, my new friends, what do you think? Monkey Bread, are you listening?