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

Question

Question

Lookup error forms 10.4.4

asked on October 6, 2020

Hello
We are working with a client a process that consults a table of checks, the operation is as follows, the user places the tax IF of the provider and makes a lookup of the checks that are in the table (this part works), then he must do a lookup with the tax id and the check number and bring the other data of the check, amount, date etc. (this part is not working).
When I do a query in the sql table for the check number if I look for it the same it does not bring me the check, but if I use the sql function Like '% Check number%' it works.
We are using Forms 10.4.4

 

Thanks

 

Ricardo Cairo

0 0

Replies

replied on October 6, 2020

Since your looking for data that contains the check number, instead of equals the check number, you will want to write your own stored procedure that takes the lookup parameters as input and searches using the Like method. Then returns the results to forms.

When looking up from a table or view directly the values must be equal.

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

Sign in to reply to this post.