Table Handling

[Former Member]

Hi,

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,

Ashish.

[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 if helpful...

Cheers,

Madhavi.

[venkat_o]

Hi Ashish, If the field is not present in LDB nodes , just define the field in the program and use SELECT query to get the field value from the table. Regards, Venkat.O