Agentry Essentials-Collision Handling to AddOrder Transmit Error

[Former Member]

Hello all,

Agentry Essential - Self Study Traning book in Lesson 18;

We are creating SQL Step for AddOrder Transaction.

After I create the 'IsCustomerInactive' SQL Step, I realized there is no field as 'AccountStatus' in the Customer table, Nortwind DB.

But I follow the book till end of the lesson and I counter the problem which I expect while testing the app ?

Is there anyone know what I am missing ?, I could not find anything about ALTERing Customer table in the book or there is something else I am wrong about.

Thanks in advance.

Murat

[Former Member · Accepted solution]

was the script CreateNorthwindExtansionsAE.sql ran on the Northwind Database?  This script will modify the Customers Table to add the AccountStatus column.

Stephen Streeter