Getting field names from the database.

[vasilek]

I am trying to put database name, layout name and some of the field names into the variables in Lasso. I am accessing a certain layout in a certain database:

[inline: -database='Customers', -layout='Form', -show]

[Variable_Set:'database'=(Database_Name)]

[Variable_Set:'layout'=(Layout_Name)]

[Variable_Set:'FirstName'=(Field_Name:'1')]

[Variable_Set:'LastName'=(Field_Name:'2')]

[/inline]

When I specify Layout name inside Inline, the number parameter represents the order of the fields on a layout. This is very inconvinient, because I will have to organaze the layout design around the field's numbering.

Without specifying the Layout inside Inline, the number parameter starts to represent the creation order of the fields, but in this case I can't dynamically set layout name in variable.

Is there a way out? Or maybe there a better way of doing it. Thanks.

[omiossec]

You can use a script like this

Loop: (Field_Name: -Count)

if: (Field_Name: (Loop_Count)) == 'firs tname';

var: 'firstname' = (Field_Name: (Loop_Count));

else: (Field_Name: (Loop_Count)) == 'last tname';

var: 'lasttname' = (Field_Name: (Loop_Count));

/if;

/loop;

[/Loop]