Add a custom field in an existing POS database

(0) Share

Report

Posted on by TM-24070630-0

Hi everyone,

I am trying to add a custom field in an existing POS database following this description - I add a new script with incremented version number, the script is an embeded resource in CreateDatabase.dll, I modify the POSISUPGRADES.xml, place the recompiled DLL in the service folder of the Retail Database Utility and run the utility ... and nothing. The utility reports that "The retail POS configuration was updates successfully" but actually nothing has happened. The upgrade script is not run, the version in POSISINFO is not changed.

I am stuck. Any help or hint will be highly appreciated.

Tsanka

*This post is locked for comments

All responses (2)

Answers (0)

TM-24070630-0 on at

Like (0)

Report
RE: Add a custom field in an existing POS database

Sure,

I would like to add a new field to the existing local databases which current version is 6.3.0.0.

The steps that I do are:

create a new SQL file named Upgrade6.3.0.1.sql as embeded resource in the CreateDatabase project. The content of the sql file is an sql command for altering the ax.RetailTransactionTable and adding a column there.

modify the POSISUPGRADES.xml file by adding

<POSISUPGRADES>

<UPGRADEVERSION>6.3.0.1</UPGRADEVERSION>
<UPGRADESCRIPT>Upgrade6.3.0.1.sql</UPGRADESCRIPT>

</POSISUPGRADES>

build the CreateDatabase.dll and place it in the service folder of the Retail Database Utility

run the Retail Database Utility in administrator mode and select the first option ("Configure Retail POS and ...").

Following those steps I expected that the POS database would be updated to version 6.3.0.1 and my new field would be created. However this did not happen. May be I missing something very simple.

It is interesting that if I create a new Retail Store, the update script from the CreateDatabase.dll is executed and my newly created local database has the new field and the new dbversion is correctly set to 6.3.01.

Thank you

Tsanka
Neeraj Chawla 1,147 on at

Like (0)

Report

RE: Add a custom field in an existing POS database

Can you explain this a little bit more...