We are using the Cloud version of Mongoose.
I have two separate tables (IDO's) that are similar. One table is history data and one table is current data. The data changed between history and current - so I can't just have one table.
What I want to do is a Union of the tables. But it appears that I can't create a Union. It appears that IDO's only allow Joins - not Unions. Please let me know if there is a way to do a Union that I'm not aware of it.
What I'm doing is reading each table via the LoadCollectionRequestData in Form Script. Then combining the data from each table together. Then adding the combined data to the Primary Collection.
- To add the data to the Primary Collection, I have this statement: ThisForm.PrimaryIDOCollection.New();
- To add each field, I have this statement for each field: ThisForm.PrimaryIDOCollection.SetCurrentObjectProperty("RowPointer", row.RowPointer);
This works. But the grid row shows a star (*) next to the grid line number. Is there a way to not have the star appear?
Please let me know if you have any suggestions on the best way to handle this use case. Thanks for your help.