Focal Point
[SOLVED] Creating an auto-index field in a master file

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3657068216

November 14, 2011, 12:50 PM
diogopc
[SOLVED] Creating an auto-index field in a master file
Hello,

I'm currently working with a master file that was created from an old database. It would help me allot if it had a primary key but it doesn't so I need to create one.

Is it possible to create a field that is an auto-index like in MS Access or do I need to do this outside the dev studio?

Thanks in advance.

This message has been edited. Last edited by: Kerry,


WebFOCUS App Studio 8103
Windows7
All outputs
November 14, 2011, 03:46 PM
Waz
The only way I know of is to use the REBUILD command.

You should check it out in the documentation.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

November 15, 2011, 06:33 AM
diogopc
quote:
Originally posted by Waz:
The only way I know of is to use the REBUILD command.

You should check it out in the documentation.


Thank you for the reply Waz.

I ended up PRINTING the table into a HOLD with FORMAT FOCUS so it would automatically add the FOCLIST index and now I'm working with that HOLD.

Just thought I'd leave this here just in case anyone has the same question.


WebFOCUS App Studio 8103
Windows7
All outputs
November 15, 2011, 03:47 PM
Waz
Its good to know that you only wanted it for a report.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!