This content has been marked as final. Show 22 replies
2- The value appeared in the message message('REF_NO=':PARAMETER.A_REF_NO); -----is 124
So i entered
data block------properties-----------Query data source type------ From clause query------------ (WHERE ref_no=124)
while running only message coming in status bar "REF_NO=124" nothing else.
Ref_no field is Number
and I am trying everything to get value from quot form to INV form. There are 5 fields in total to receive value from Quot.fmx but i am trying for one"REF_NO" only (is this creating an error, just a thought)
Please see my first post to get actual scenario and basic procedure i applied.
only.ashish99, it appears you are ignoring CraigB's important question:
Is your Datablock based on a From Clause Query?
I answered by saying " I am trying everything to get value from quot form to INV form."
I tried all these but no success.
1) Normal Parameter passing
2) From clause query
3) Static value
and No, my form was not based on From clause query earlier but it could be, if you have solution.
What is the data source of your Forms Data Block?
Data source type is "Table"
& name is "INV" (Table name)
Thanks for ur time.
The "from clause query" is the wrong property for your WHERE-clause. There is one property named WHERE-clause, put your condition there (just the REF_NO=123).
Thanks for your suggestion but eventually i am not able to test due to one error in my form. Run form is not working.
Craig: I checked ur below thread but problem not solved for me. any other suggestion.
Forms 6i "Run Form" not working