hi all,

i have developed a session for comapring manually enetered values with the values present in a table.

How do i retain the values given in the form so that they can be used in the script for comparision.

Any ideas are welcome

thanking in advance

hi all,

i have developed a session for comapring manually enetered values with the values present in a table.

How do i retain the values given in the form so that they can be used in the script for comparision.

Any ideas are welcome

thanking in advance

Hello,
don't know what you mean ?

extern domain tcitem item.to.check

Formfield = item.to.check


field.item.check:
before.input:

YOUR CONDITION

or


if DB.field comparecondition item.to.check then ........


If you explain more specific (or give some code), the help will be better !

Regards

sample code:

field.tdpur045.suno:
after.display:

select tdpur045.*
from tdpur045
where tdpur045._index1 inrange {: orno, : pono,0000} and
{: orno, : pono,9999}
selectdo
if tdpur045.pric <> pric then
check = "p"
message("mismatch in unit price")
break
endif
endselect
'pric' & 'suno' are form fields i want to compare them with values in table tdpur045

Also can we use form fields in field.<field sections>?
where ever we are using form fields should we use ':'. What is the significance of ':'?

sample code:

field.tdpur045.suno:
after.display:

select tdpur045.*
from tdpur045
where tdpur045._index1 inrange {: orno,: pono,0000} and
{: orno, : pono,9999}
selectdo
if tdpur045.pric <> pric then
check = "p"
message("mismatch in unit price")
break
endif
endselect
'pric' & 'suno' are form fields i want to compare them with values in table tdpur045

Also can we use form fields in field.<field sections>?
where ever we are using form fields should we use ':'. What is the significance of ':'?

Kindly note

sample code:

field.tdpur045.suno:
after.display:

select tdpur045.*
from tdpur045
where tdpur045._index1 inrange {: orno, : pono,0000} and
{: orno, : pono,9999}
selectdo
if tdpur045.pric <> pric then
check = "p"
message("mismatch in unit price")
break
endif
endselect
'pric' & 'suno' are form fields i want to compare them with values in table tdpur045

Also can we use form fields in field.<field sections>?
where ever we are using form fields should we use ':'. What is the significance of ':'?

Also can we use form fields in field.<field sections>?
Yes.

where ever we are using form fields should we use ':'. What is the significance of ':'?
I don't know for sure but it's a part of the syntax.

The code looks about right. The 4 0's are not required as it is just a no. Even if you omit that final value 0 - 9999 it will be returning the same result.

Form fields can definitely be used in query . If it's multi-occ , u can use functions like do.occ , do.all.occ to get the values of form fields .

Also at times , form fields may get re-initialized by urself in the code itself in some other event which gets executed as a standard program flow however without ur understanding . U may check this issue as well.

Form fields can definitely be used in query . If it's multi-occ , u can use functions like do.occ , do.all.occ to get the values of form fields .


Can we use these functions in Single-occ forms?

It can certainly be used in single occ also provided used in right context . I remember using dl.all.occ.successfully somewhere.