Monday, January 19, 2009

Adding reports to the web without affecting data

Q: If you have an existing Alpha Five web application and create or edit an existing report, how do you get the new report up to the web without disturbing the existing data?

A: After you create or edit a report, three files will have been updated in your Alpha Five project for each table affected: ddd, ddm and ddx. Publish these three files up to the server using a 3rd party FTP software. Alpha's publishing option will not publish just these files. You DO NOT want to re-publish the dbf file since that will overwrite all of your data online.

At this time the report definitions should immediately be available to your web application.

1 comment:

Steve said...

The far better alternative is to base all reports on Sets. Then you can upload the entire Set and all related files without affecting any data.