Record Groups - Programmatically Change the property 1

[tpbjr]

Hi All,

Is there a way to programmatically change a Record Group's record group query property?

I have a code that uses the the LIKE clause and it has always worked because we only had five character data. Now the rules have changed and we can now how four character data. Then the form loads the LOV pops up when if finds data that is something like this, '1234' and '12345'. The quick work aound that I did was to get rid of the LIKE clause, but now the user can not do a wild card search.

I am thinking that if I can dynamically change the property in code when I want then I would use the LIKE clause when the command button is pushed, otherwise use the equals in my select statement for the property.

I hope this makes sense to somebody.



Thank you for all your help

http://www.besware.com

Tom

 

[BJCooperIT]

Check here:

http://mates.ms.mff.cuni.cz/oracle/doc/forms45/dg/ch15.htm#toc134

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
Author and Sole Proprietor of: Emu Products Plus