Method Community

I have a custom table called Events. When I delete an event, I want to delete all the records related to the event in the EventComments table.

I have a grid with events on my custom screen, and the following actions:

1. Show message with a confirmation buttion.

2. Loop through checked items on the grid

3. Delete record from table Event Comment where eventname_recordid = value from row:record id.

When I publish this and run click the button, I get the following error:

Error running the query

Additional Information

Action Sequence Order:3

nsmith_piano,

I seem to be getting the same error with a similar process. I'll dig a little deeper to try and figure out why the error is occurring and I'll post back here as soon as I have an update!

Jason

Hi Nathan, 

I'm going to create a ticket with our team to get this looked at. I will update you here if I receive any updates. 

Jason

Thanks for checking Jason. Did you hear anything back from the developers?

Hi Nathan, 

Yes I have! Looks like the issue is resolved, however we will have to wait for the site to be republished before we can see the changes. I'll post back here as soon as this happens. 

Jason

That's great news. Thanks for your help.

Hi Nathan,

Good news! This is fixed in the October version of Method. Let me know if you are still having issues. 

Jason