block : first and last item

i'm using TBS to generate SQL (create table...)

fields of the table are in a TBS block, it's OK.


each field instruction ends with a "," except the last !
is there any condition in TBS like "first_item" and "last_item" ?

i add 2 logicals called "tbs_first" and "tbs_last" which i can test but this sucks when i use a block condition :


when my first and last fields haven't the condition, i can't test my logicals.

any idea ?

Hi,

They a several ways to do that:

1)
Move the coma (",") to the begining of each fields. So it would be like this :
Then, you can manage the coma as a TBS field : [field.#;if [val]=1;then '';else ',']

2)
Use parameter "splittergrp"  to define a section that will be displayed only between records. Use this section to display only the coma.

Nice ideas : i'll try these.
Thanks