Hi,

One approach is to loop through all fields and do a number of:
$PROCESS$ Application-Copy-Field-Value <tmp-field-id> <from-field-id>

The field ids can be found in the the database. You can create a view-form
against the  and then display the field ids in a table-field. The schemaid
must be retrieved from the database table and then used in the
qualification in your table.

SQL tables in the database:
- arschema (important columns are schemaid and name)
- field (important columns are schemaid, fieldid, fieldtype=1)

Create a table-loop-guid that checks each field in turn.

I do not know how important speed is to you. There may be some things that
can be done depending on your requirements.

        Best Regards - Misi, RRR AB, http://rrr.se

> hi, can anyone help me?
>
> i need to check all the fields in a form whether the field has a value
> or not, and if it's not empty, grab the name of that field and its
> value and concatenate them all together and push the string value to a
> field in another form.
>
> i know i can do this by creating a series of active links to test the
> field and push the data but i was hoping there is a more optimized way
> of doing it (like a foreach statement)
>
> any other ideas how i can do this?
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Reply via email to