some problem of a "

Wed, 09 Dec 2015 19:08:56 GMT

i have this table :

Custs:

//טבלת לקוחות

LOAD

CUSTNAME AS CUST_CUSTNAME,

CUST AS CUST_CUST,

ADDRESS AS CUST_ADDRESS,

CURRENCY AS CUST_CURRENCY,

CUSTDES AS CUST_CUSTDES

FROM [lib://CLINTON_SAMPLE/customers.qvd]

(qvd);

and i am trying to run this :

Inv_Sales_temp: //טבלת מכירות כללית

LOAD

Date (IVDATE/60/24+32143,'DD/MM/YYYY') AS INV_IVDATE,

IVNUM AS INV_INVNUM,

DOC AS INV_DOC,

IV,

QPRICE AS INV_QPRICE,

TOTPRICE AS INV_TOTPRICE,

"CURRENCY" AS INV_CURRENCY,

CUST AS INV_CUST,

DEBIT,

VAT AS INV_VAT,

UDATE AS INV_UDATE,

PRINTED AS INV_PRINTED,

FINAL AS INV_FINAL,

ORD AS INV_ORD ,

DISCOUNT,

DISPRICE AS INV_DISCOUNT,

PAYDATE AS INV_PAYDATE,

FNCTRANS AS INV_FNCTRANS,

BOOKNUM AS INV_BOOKNUM,

AGENT AS INV_AGENT,

TYPE AS INV_TYPE,

CHECKING AS INV_CHECKING,

IMPFILE AS INV_IMPFILE,

STORNOFLAG AS INV_STORNOFLAG,

BRANCH AS INV_BRANCH

FROM [lib://CLINTON_SAMPLE/Invoices.qvd]

(qvd);

//פרטי ת.יומן

Left join

LOAD

FNCTRANS AS INV_FNCTRANS,

FNCNUM,FINAL as FNC_FINAL,

CURDATE AS FNC_CURDATE,

FNCDATE,

EXCHANGE3 AS FNC_EXCHANGE3,

CURRENCY3 AS FNC_CURRENCY3,

IVNUM AS FNC_IVNUM,

EXCHANGE2 AS FNC_EXCHANGE2

FROM [lib://CLINTON_SAMPLE/Fnctrans.qvd]

(qvd)

Where FINAL ='Y';

left Join (Inv_Sales_temp)

LOAD

CUST_CUST AS INV_CUST, CUST_CUSTNAME AS INV_CUSTNAME,CUST_CUSTDES AS INV_CUSTDES

Resident Custs;

but i am getting this :

Table not found: left Join (Inv_Sales_temp) LOAD CUST_CUST AS INV_CUST, CUST_CUSTNAME AS INV_CUSTNAME,CUST_CUSTDES AS INV_CUSTDES Resident Custs

i dont realiy understand why.... since i have wrote down custs...

Re: some problem of a "

reddy-s — Thu, 10 Dec 2015 09:42:21 GMT

Hi Jhonatan,

I am assuming that this is the same post as the other one. So the solutions the same. Use No Concatenate before the load statement of table Inv_Sales_temp.

topic Re: some problem of a " in App Development

some problem of a "

Re: some problem of a "