complicated Method construction

[Bart Pietercil]

Hi List,


I have a table 'cells' with this structure:


CREATE TABLE "cells" (
	"tree_ptr" OBJECTPTR CONSTRAINT tree_to_cell REFERENCES "trees" ON  
DELETE CASCADE  NOT NULL INDEXED,
	"parent_ptr" OBJECTPTR CONSTRAINT cellparent_to_cellchild REFERENCES  
"cells" ON DELETE CASCADE  NOT NULL INDEXED,
	"cell_descr" VARCHAR (1022)  NOT NULL INDEXED,
	"cell_name" VARCHAR (255)  NOT NULL INDEXED,
	"cell_levelindicator" VARCHAR (2044)  NOT NULL INDEXED);

Now I would like to  be cell_levelindicator a method.

This method would need to be:

cell_levelindicator = concat(parent_prt->cell_levelindicator ,  
"_" ,recid)

Is this possible in a method ?

The reason I need this functionality is to be able to retrieve (real  
quick) a (sub)branch from a tree

TIA

Bart Pietercil