I'm having a problem adding a new column from the data source to an existing table in the model
I had a patient table which I already added to the model. The table is in SQL Server.
I decided to add an age band column. Added this to the base SQL Server table. Now, in FM, if I go to Model Accelerator and choose import new metadata, the column shows up. I check it, say continue, and nothing happens--doesn't show in the metadata.
Likewise, I go to the query for the table that says 'select all from patient' and sure enough, in the table shown there the Age_Band column is there, but when i try to run the query it doesn't show up. If I try to explicitly list all columns to the query, including the new one, and run test, it gives an error saying it can't find the column it itself listed!
Any help would be appreciated.
Click on the Query subject, from the Tools menu select Update Object. It will add the new column.
Thanks! I figured it was something simple.