Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to know how to store a field value i.e string in a variable.
Ex:
table:
id,name
1,aaa
2,bbb
3,ccc
how to load the filed values into a variable??
I tried peek function let vname = peek('name',0,'table')
but I didn't get any answer
If I keep id field instead of name I got result for id.
Please give the solution for this.
If I understand , you want to load the filed values into variable ...try this in front end
vname
=concat( distinct name, ';' )
Hi mallika,
Try:
Let vname = peek(name,0,'table');
(without enclosing name in single quotes)
That should do the trick.
I try this .but not getting answer
You should use single quotes in the field name.
Let vname = peek('name',0,'table');
should work as long as table exists and has a field called name.
Can you post your script log?
-Rob
Try This
=GetCurrentSelections(name )
Hi Mallika,
Try to use FirstSorted Value Function....
Let vName = Firstsortedvalue(Name,0)
Regards,
Jayshri
what you want to achieve? If you can tell us your exact requirement, we can suggest some other ways
its work fine
set vname=SubField(name,',');
regards
sahadev
yes I got it.
Thank you