Question: 'execute_query' in Forms 4.5
From: Salaam Yitbarek <bi495_at_FreeNet.Carleton.CA>
Date: 1995/05/30
Message-ID: <D9E6t6.M9r_at_freenet.carleton.ca>#1/1
Date: 1995/05/30
Message-ID: <D9E6t6.M9r_at_freenet.carleton.ca>#1/1
Hello,
Problem is as follows: Before entering a block, I assign the primary key (of type VARCHAR2(30)) to some string (in the PRE-QUERY trigger). Then we 'execute_query', and the record corresponding to that key comes up. This works as long as the string assigned to the primary key does not contain characters such as '<', '>', etc. If the primary key contains such characters, Forms returns an error, saying something about improper comparison used in the query, or something like that. My guess is that it doesn't parse the query properly. Any suggestions?
Thanks,
Salaam Yitbarek
e-mail: above, or austral1!yitbsal_at_ott.hookup.net
Received on Tue May 30 1995 - 00:00:00 CEST