Use of existing terms in data entry

[Renate Morgenstern]

Helpful

Up

0

Down

Not Helpful

::

Hi,

I have a database in which names of persons are added in ^a for the 1st part and ^b for the last name or second part. Sometimes there is no second part. The inverted file for searching sorts correctly. However, when I want to use the picklist for data entry the names without a 2nd part is not sorted correctly.  I tried to add conditional statements in the autoridades.pft, but then I get an error message.

Here is the autoridades.pft

select e3
case 700: v700^a,|, |v700^b’$$$’mpl,v700
case 701: v701^a,|, |v701^b’$$$’mpl,v701
case 702: v702^a,|, |v702^b’$$$’mpl,v702
case 703: v703^a,|, |v703^b’$$$’mpl,v703
case 704: v704^a,|, |v704^b’$$$’mpl,v704
case 705: v705^a,|, |v705^b’$$$’mpl,v705
case 706: v706^a,|, |v706^b’$$$’mpl,v706
case 707: v707^a,|, |v707^b’$$$’mpl,v707
case 708: v708^a,|, |v708^b’$$$’mpl,v708
case 709: v709^a,|, |v709^b’$$$’mpl,v709
case 711: v711^a,|, |v711^b’$$$’mpl,v711
case 710: v710^a,|, |v710^b’$$$’mpl,v710
case 712: v712^a,|, |v712^b’$$$’mpl,v712
case 713: v713^a,|, |v713^b’$$$’mpl,v713
case 600: v600’$$$’v600
case 601: v601’$$$’v601
case 605: v605’$$$’v605
case 606: v606’$$$’v606
case 607: v607’$$$’v607
case 610: v610’$$$’v610
case 613: v613’$$$’v613
case 615: v615’$$$’v615
case 996: v996’$$$’v996
case 201: v201^a,|, |v201^b’$$$’v201
case 202: v202^a,|, |v202^b’$$$’v202
case 203: v203^a,|, |v203^b’$$$’v203
case 201: v204^a,|, |v201^b’$$$’v204
case 205: v205^a,|, |v205^b’$$$’v205
case 206: v206^a,|, |v206^b’$$$’v206
case 207: v207^a,|, |v207^b’$$$’v207
case 208: v208^a,|, |v208^b’$$$’v208
case 209: v209^a,|, |v209^b’$$$’v209
case 302: v302^a,|, |v302^b’$$$’v302
case 210: v210^c’$$$’v210^c
case 210: V210^d’$$$’v210^d
case 916: v916’$$$’v916
case 200: v200’$$$’v200
case 209: v209’$$$’v209
case 225: v225’$$$’v225
case 226: v226’$$$’v226

Please tell me what is wrong with this file.

Thanks

Renate

See screenhots.

Topic