Home » Developer & Programmer » Forms » Problem -- OracleForms
Problem -- OracleForms [message #83278] Tue, 02 September 2003 17:41 Go to next message
AnotherOne
Messages: 3
Registered: September 2003
Junior Member
When i type a item into a Oracle form ie CLAIM0005
i always get CLAIM0001 returned.. win XP, Oracle9ids
R2

the code for the when-press-button is
Go_Block('CONTRACTOR');
execute_query;

what is actually going wrong as this seems to be what is used all over the internet ???

tks in advance ...

//M
Re: Problem -- OracleForms [message #83279 is a reply to message #83278] Wed, 03 September 2003 00:01 Go to previous messageGo to next message
sujit
Messages: 94
Registered: April 2002
Member
hi,
please check that your where clase in data block 'CONTRACTOR' contains item_code = :<control_block>.item_code,
I think 'CLAIM0001' is your first item, and your query is returning all the records, You can see only first record as it is of Form structure(NOT TABULAR).
Best Of Luck!
Sujit
Re: Problem -- OracleForms [message #83280 is a reply to message #83278] Wed, 03 September 2003 00:36 Go to previous messageGo to next message
Sun
Messages: 92
Registered: August 2002
Member
It is fetching all the records. You can avoid it by using set_block_property - default where clause in pre query.
Re: Problem -- OracleForms [message #83281 is a reply to message #83280] Wed, 03 September 2003 04:14 Go to previous message
AnotherOne
Messages: 3
Registered: September 2003
Junior Member
Hello, sun, I am aa bit of a newbie on this
could you be a bit more specific, on the pre -query bit as i find the concept hard to grasp ...

Tks in adv ...

//Ma
Previous Topic: Passing parameter from Forms 4.5 to vms command file
Next Topic: Printing Oracle Forms
Goto Forum:
  


Current Time: Fri Apr 26 04:14:27 CDT 2024