Hello,
I am trying to refresh my database structure in frame work manager in order to update according to the database but i cant find the option where to do it.
There is a change in the database table and i want to update my table in Framework with those changes so that i can use those objects as a Query Item.
Thanks
Raju
Assuming the query subject you imported for this table originally is still set to the default 'select * from <table>', all you should need to do is to right-click the query subject -> Edit Definition, then click OK. This should update the query subject to display an up-to-date set of query items.
Alternatively, if you edited the original SQL query, simply add in the new column(s) to the query and save.
MF.
Quote from: MFGF on 12 May 2010 11:40:06 AM
Assuming the query subject you inported for this table originally is still set to the default 'select * from <table>', all you should need to do is to right-click the query subject -> Edit Definition, then click OK. This should update the query subject to display an up-to-date set of query items.
Alternatively, if you edited the original SQL query, simply add in the new column(s) to the query and save.
MF.
Thanks...I was able to update my Query subject using your solution.