pre query

[moad_krishan]

السلام عليكم



ارجوا منكم اعطائي شرح مفصل عن
pre_query trigger
ومتى يعمل

[مستر حسن]

سلام

Pre-Query
executes on the block level immediatly before a block receives execute query command.
It executes only once before the entire query processing
if you press the execute query button (f8(
the pre-query fires.

why to use it?

to prevent a query to take place, or modify query condition
Once the pre-query is executes, then Oracle forms issues the query to the database. Then when the records are being fetched, the post query executes once per record.

example
if the user name is SCOTT, you want to cancel the query
write the following on the PRE-QUERY trigger

IF USER='SCOTT' THEN
MESSAGE ('sORRY QUERY CANCELEED');
RAISE FORM_TRIGGER_FAILURE);

Ammar Sajdi
www.e-ammar.com

[بنت الجبل]

thank you a lot for care to answer the question
forward in your life

[moad_krishan]

thank uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu