Table handling with lb

[Former Member]

Hi all,

We specify the logical database. And we want a field that is not present in any of the tables defaulted in logical database. How can we want to add this additional field from a different table?

Thanks in advns,

Diwakar

[Former Member]

Hi,

Presume you have a

logical database

table 1

table 2

table 3

Define the required field as additional field say fld of table 1, table 2 or table 3

and then in the code section define.

Perform get_f1d(zxxxxxxx) using f1d.

Form zxxxxxxx could be like;

Form get_f1d using f.

Select * from where 'conditions'

f = table4 - f1d.

Reward points if found helpfull...

Cheers,

Chandra Sekhar.