Problem -- OracleForms [message #83278] |
Tue, 02 September 2003 17:41 |
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 |
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 #83281 is a reply to message #83280] |
Wed, 03 September 2003 04:14 |
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
|
|
|