How do I handle duplicate rows in SQL for grouped transaction data?

General Discussion
1

Hi Everyone I'm Emmanuel Katto from Dubai, I have a transaction group (stored procedure) running, and every time I trigger it, I notice the #executions count increases by 1 in the Ignition Designer. However, I end up with two new rows of SQL data, which have almost identical timestamps. Does anyone know what could be causing this?

Regards
Emmanuel Katto

2

Without providing code or at least the stored procedure, we won't be able to help much I'm afraid.

Also, perhaps I'm the only one bothered by it, but why do you always add your name and location in each of your topic's title ?...

1 Like
3

Emmanuel, please read the Keep it Tidy section of the FAQ. It particularly requests that you don't sign your posts as your username, etc., is automatically added to the top of each post. If you want to tell people you are from Dubai then add that information to your user profile.

The FAQ doesn't mention adding your name to the title of every post - most likely - because nobody dreamed that someone would do it.

There is an edit link below your post so you can fix it.

2 Likes