Skip to main content

Another VFP 9 Cool Feature: MAKETRANSACTABLE()

If you're like me, you may have older Visual FoxPro applications that were upgraded from earlier versions and still use free tables. And why not? Databases certainly offer some benefits but they can be "clunky" to move around.
 
One of the reasons many developers switched to using databases and the DBC files were to support transactions : - that is the ability to start a transaction, update a bunch of files and then if one thing didn't work right, roll it all back to the original source.
 
Well now,  in Visual FoxPro 9 (Europa) , FREE Tables can be made transactable as well with the new MAKETRANSACTABLE() function.
 
Consider the following:
 
USE CUSTOMERS
MAKETRANSACTABLE( "CUSTOMERS")
BEGIN TRANSACTION
 
DELETE ALL
IF MESSAGEBOX("Did you really want to delete all your customers",4) <> 6
    ROLLBACK
ENDIF
END TRANSACTION
 
Note: that each table must be called MAKETRANSACTABLE in order to work. This means a few extra calls when your table is open.
 
When you close the table, the MAKETRANSACTABLE setting is removed.
 
One of the big challenges with older applications is ensuring that everything is always updated properly. With this great new feature, you can use Transactions with your free tables, ensuring that if something goes wrong, everything can be updated properly. Awesome feature.

Comments

Randy Jean said…
This could be a lifesaver for some work I'm doing with a new client that has all free tables and wants to implement buffering and transactions. Luckily, they've already deployed under VFP9.
April 20, 2007 at 1:24 PM
Post a Comment

Popular posts from this blog

Merry Christmas

Whether you celebrate now, have already celebrated your past holiday, are planning to, or not, I hope you find yourself surrounded by family and those you love during this holiday season and are able to remember fondly those who are not with you. We often find ourselves buried in work, or too distracted by other problems, to share and remember a few moments with those closest to us. So many of us are separated by huge distances, we often find it easier to focus on those who are out of arm's reach yet so easy to connect with online, instead of those who are right beside us. So do yourself a favour, put down the keyboard (stylus, mouse, etc) and spend that time. I know I will. Merry Christmas. Powered by ScribeFire .
4 comments
Read more

Programmers vs. Developers vs. Architects

I received an email this morning from Brandon Savage 's newsletter. Brandon's a PHP guru (works at Mozilla) but his newsletter and books have some great overall perspectives for developers of all languages. However, this last one (What's the difference between developers and architects?) kind of rubs me the wrong way. Either that, or I've just missed the natural inflation of job descriptions. (maybe, it's like the change in terminology between Garbage man and Waste Engineer or Secretary and Office Administrator) So maybe it's just me - but I think there's still a big difference between Programmer, Developer and then of course, architect. The key thing here is that every role has a different perspective and every one of those perspectives has value. The original MSF create roles like Product Manager, Program Manager, Developer, Tester, etc - so every concept may pigeon hole people into different roles. But the statements Brandon makes are often distinction...
11 comments
Read more

From Writing to AI: the pattern repeats itself

When I was ten years old, my dad bought a computer and, thanks to an advertising supplement in a Superman comic I read, it was a TRS-80. A month later, he dragged the entire family (my mom and brother were not the most enthusiastic) to a class at Radio Shack teaching how to use microcomputers. At the time, I understood why my mom wasn’t that excited: the computer was yet another gadget in the house. But today I find it fascinating. My mother went to Vassar in the 50s. She learned how to type — not a common skill at the time — but it opened doors. Her ability to communicate effectively led her to a career in adult education and later communications work with the CBC (Canadian Broadcasting Corporation). This isn’t a nostalgia post. Today, the ability to use artificial intelligence, be it through Copilot or simply writing the right prompt, is becoming a critical skill. But is it really that novel? In the 1500s and 1600s, the printing press gradually made reading accessible beyond cler...
Post a Comment
Read more