Insert SQL

Primary tabs

I am inserting rows in a table. This table is appearing in all namespace as I did global mapping. 

So once I run insert command from a method, it insert the rows. When I run the same insert command from other namespace, it replace the existing data in table. 

Insert command is same in all namespace but the data I m inserting is different. 

 

Answers

It sounds like you mapped the data global but not the id counter global so the other namespace can not see the current id counter value hence it will overwrite the data you already inserted.

I agree with Mark.  If you do not understand his response and/or if you still have questions, I invite you to open an issue at wrc.intersystems.com and the Support Team will help you get to the bottom of this.