Hello all! I have a script that is supposed to read the selected row, grab a cell based on the column header I give, and then run a named query to update the database using that cells data as a parameter. The script will run fine, although it doesn't seem to fire until I click it twice. I have tri…

Yes, I agree this isn't the best approach. Although, I was able to figure out a solution! It seems rather than getting caught up on the named query, it may have something to do with the memory tag. I removed the tag write completely and used the component itself to grab the data I needed. This in t…

Don't run this on the mouse click because the event fires before the index is selected. Run this from the propertyChange event handler with a selectedIndex qualifier.

[image] Drop down, change of selection General Discussion If you are attempting this from the mouse clicked event handler, the problem is that the event fires before the index is selected. This is why it doesn't work on the first click but does work on the second. Of cours…

Thank you! Although, it seems to be doing the same thing. Here is the script as it stands now. if event.propertyName == 'selectedIndex': # Grab a reference to the table. table = event.source.parent.getComponent('Power Table') selectedIndices = table.getSelectedRows() # If the length of s…

Is this being fired from the table, or some other component?

It is being fired from a button! I apologize for not stating that earlier.

Then use the actionPerformed event handler with no qualifier.

Thank you, would I need to use the event object property source? I tried running it in the actionPerformed as well but same result. I did not use if event.propertyName == 'selectedIndex': as well

I don't see any reason why this wouldn't work on the first click from the actionPerformed event handler. table = event.source.parent.getComponent('Power Table') selectedIndices = table.getSelectedRows() # If the length of selectedIndices is greater than 0, then at least one row is selected.…

How do you know it isn't working on the first click? It writes to a tag and it causes a query to run. (An update query of some kind, presumable, as you are discarding the return value.) Are you monitoring the tag? Are you querying the database elsewhere to see the DB changes? Such a script comm…

I am checking within the DB and with one click it does not update the database as well. I also have the query tied to the "data" component on the power table that updates every second for testing purposes. It does write to the memory tag on first click as well as display my print statements. Seems t…

Script on mouseClicked Button requires 2 clicks to run

Ignition

justinedwards.jle January 17, 2023, 3:18pm 3