Creating new field in a table

[alec1982]

hi,

Anybody can help me creating a new field on a table so i can match it connecet it to another table.

The first table has

ID          Currency

1          $

2          $

3          AUD

4          BRL

The second table has:

Description          Factor

$ to $                    1

AUD to $               1.051

BRL to $               0.488

I need to create a field in the first table to show Currency value & 'to $'

Thanks,

Alec,

[MayilVahanan · Accepted solution]

Hi

     Try like this,

     Load Currency & ' to $' as Currency1;

     Load * from tableName;

     Hope it helps

[alec1982]

Hi,

Thanks for the replay.

I got the following error:

Out of Physical and/or logical memory

Thanks,

Alec

[MayilVahanan]

Hi

     Can you post a sample?     

     Before include that line. did u get any error message?

     After include the following lines, you got error message?

        Load Currency & ' to $' as Currency1;

     Load * from tableName;

[alec1982]

Hi,

I just tried to do it now inside the table load as a field

Load

A,

B,

Currency & ' to $' as Currency1

from table1.

It seems to work fine. Any advice on that?

Thanks,

Alec

[MayilVahanan]

HI

     Both are same. I thought you are using inline function.. So i referred to use like that.. Its fine..You can use Currency itself as fieldname..

[alec1982]

Thanks for your help!