topic Re: Table Handling in Application Development and Automation Discussions

Table Handling

Former Member — Sun, 20 Apr 2008 13:34:08 GMT

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.

Re: Table Handling

Former Member — Sun, 20 Apr 2008 15:24:15 GMT

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.

Re: Table Handling

venkat_o — Sun, 20 Apr 2008 15:35:15 GMT

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