Re: what are the places to set default query in the block

Values can be defaulted by direct assignment (without using a set_block_property) in the Pre-Query or key-exequery triggers. When-New-xx-Instance triggers also fire in enter-query mode, as do 'key' triggers.

The where clause may be set by a Relation, which would be defined on the master block. Even if the Relation has been removed, the 'Copy Value from Item' property may still be assigning a value during query processing. Look for this property on detail block items.

As you have recognized, the other way is to set a where clause is with set_block_property. In Forms 4.5 the only way to be sure is to do a "Forms Doc" and then search the text file. Even then, if there is a Forms library attached then a program unit in the library may be causing the problem (seems unlikely, but it's possible).

dbahelp wrote in message <4f6b3ef2.0107241632.4ed14ae_at_posting.google.com>...
>Hello all !
>
>In forms4.5, developer 2000 what are the places where you can setup
>default query ? so when user presses key-exequery it should get data
>as per master block data
>
>I am debuging a form which do not have post query trigger, do not have
>set_block property, its where clause property is null and still if I
>look at :system.last_query result it have a where clause . There is no
>relationship of master and details set up in the form. Order by
>property is present in the form which is also in query.
>
> I also checked in fmt file for where condition its not there. This
>form is converted from forms3.0 to forms 4.5
>
>Is there any other way where I can set up the default where clause in
>the forms ?
>
>here is result of :system.lst query
>
>SELECT
 ACTIVE,CLI,CNAME,CUSTSEQNO,IND,WORLD_PARTNER,SUSP_ENTRY,SUSP_CLEAR,ACC,AC
>CTIME,NUM,PROMPT_OV,TRANS,NUMSEQNO,DIR,NUMTYPE,TZ,DOW,DOY,PSTART,PEND,IDD,S
 ITE,E
>NTRY,CLEAR,FACILITIES,ORIGIN_REGION_ID,ORIGIN_DOMAIN_ID,ORIGIN_REJECT_REGIO
 N_ID,
>ORIGIN_REJECT_DOMAIN_ID,ORIGIN_ACCEPT_REGION_ID,ORIGIN_ACCEPT_DOMAIN_ID,DES
 T_REJ
>ECT_REGION_ID,DEST_REJECT_DOMAIN_ID,DEST_ACCEPT_REGION_ID,DEST_ACCEPT_DOMAI
 N_ID,
>XSTART,XEND,XSTART2,XEND2,XSTART3,XEND3,ROWID FROM ABC WHERE (CLI=
>'1000') and (CNAME='XXX') and (CUSTSEQNO=8) and (WORLD_PARTNER='N')
>order by cust
>seqno , cname , cli , num , dir , numtype , dow , pstart , pend ,
>xstart , xend
>, xstart2 , xend2 , xstart3 , xend3
>
>Thanks in advance
>
>Dbahelp
Received on Wed Jul 25 2001 - 06:18:53 CEST