You are viewing limited content. For full access, please sign in.

Question

Question

Forms: Pass NULL into Stored Procedure?

asked on October 10, 2016

Hi All,

We have come across a scenario where we need to pass a NULL value into a stored procedure in Forms. However from the drop down list in the lookup rules you only seem to be able to pick fields on the Form and there is no way of passing a NULL value (i.e. like you can from SQL Management Studio shown below)

Does anyone know a way we can do this? Or would it be possible to include this functionality in a future version?

Cheers! Dan

0 0

Answer

SELECTED ANSWER
replied on January 12, 2017 Show version history

This feature has been added in Form 10.2, now you can set the Lookup rule as following to match the column with NULL value.

0 0

Replies

replied on October 10, 2016

It is currently not supported, we will consider adding support for this in future version.

0 0
SELECTED ANSWER
replied on January 12, 2017 Show version history

This feature has been added in Form 10.2, now you can set the Lookup rule as following to match the column with NULL value.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.