Stored procedure not executing

asked on July 27, 2017

I have a lookup rule for a stored proc that uses the value of a single field to fill four others, but I can't get it to execute. Another stored proc on the same form works correctly, using multiple fields to fill others (one of which is the problem child that won't fire its proc).

It doesn't fire when the value changes, either manually or from the other proc. I've checked everything I can think of, but I'm clearly still missing something:

the proc does return a single row of valid data for the values I'm testing
the service account has permissions to run the proc
I don't see anything related in the event viewer
I don't see an event on the SQL Server that attempts to run the proc when changing values in the field
I haven't added any JavaScript to any of that field's events

What else can I try?

0 0

SELECTED ANSWER

replied on July 27, 2017

If the procedure should return a value, doesn't return anything when the value is manually entered, and you've verified permissions, then I would start by looking at your lookup condition. The thing to do now is determine if it truly isn't firing, or if for some reason it isn't getting the results you expect.

0 0

replied on July 27, 2017

I haven't seen a way to set any lookup conditions other than "Use <field> value for <parameter>". The parameter is automatic, so you can't even mistype it.

The column names from the result set can be mistyped, however, and apparently that's what I did. Combine that with a bad filter on my events in SQL, and things make a lot more sense now.

Thanks for the reminder to go back and check the fundamentals!

0 0

Question

Question

Answer

Replies

Sign in to reply to this post.