delphi

As many other developers of e-commerce sites using Drupal, I've had to solve the problem of integrating the "front-office" store maintained in the ecommerce module with the back-office data like the actual invoicing matching legal requirements, tax documents, product ordering from suppliers, and so on, and I've had to choose a toolkit for this.

Until recently I had been using Delphi with XML-RPC to upload content and remotely monitor my sites, but I was looking for a cross-platform solution, and one that would preferably have sources available. Using Kylix for other projects and it *does* work, even with SOAP and remote data stores, but the level of support and lack of upgrades from Borland regarding it left me rather skeptical about using it for new projects. And this was not even taking into account the fact the XML-RPC for Delphi and Kylix is a poorly supported Open Source project. So what ?

Earlier today, someone asked how to display the contents of Paradox formatted memo fields in a Delphi app.

I setup a basic solution, for which the source is given hereunder.

The idea is to define a calculated String field for the Query or Database used. Say be call it FMT in a table TBL, so its object name will be TBLFMT. In the OnGetText event for the field, add this code: