I need some help odbc scrpit

Anonymous — Thu, 29 Nov 2018 16:31:39 GMT

I am trying to load this table with a new report

LIB CONNECT TO 'MS Access DB 2.0';

Nuevo:
LOAD "# of Days Late",
"# of Days to Ship",
BackOrder,
Cost,
"Customer Number",
"Date",
GrossSales,
"Invoice Date",
"Invoice Number",
"Item Desc",
"Item Number",
Margin,
"Open Qty",
OpenOrder,
"Order Number",
"Promised Delivery Date",
Sales,
"Sales Qty",
"Sales Rep Number",
SalesKey;
SQL SELECT "# of Days Late",
"# of Days to Ship",
BackOrder,
Cost,
"Customer Number",
"Date",
GrossSales,
"Invoice Date",
"Invoice Number",
"Item Desc",
"Item Number",
Margin,
"Open Qty",
OpenOrder,
"Order Number",
"Promised Delivery Date",
Sales,
"Sales Qty",
"Sales Rep Number",
SalesKey
FROM "C:\USERS\HP\DESKTOP\SCRIPT TUTORIAL\TUTORIALS SOURCE\Sales.accdb"."Sales data";

Tabla:
Load
[Item Desc],
Count([Item Desc]) as ordenclient
Resident Nuevo Group By [Item Desc];

Se ha producido el siguiente error:

Table 'Nuevo' not found

El error se ha producido aquí:

Load [Item Desc], Count([Item Desc]) as ordenitem Resident Nuevo Group By [Item Desc];

Re: I need some help odbc scrpit

Gysbert_Wassenaar — Thu, 29 Nov 2018 17:17:05 GMT

Make sure the data you load into Nuevo isn't automatically added to another table with the exact same fields. Use the NOCONATENATE keyword to prevent automatic concatenation

Nuevo:
NOCONCATENATE LOAD .... etc

topic I need some help odbc scrpit in Integration, Extension & APIs

I need some help odbc scrpit

Re: I need some help odbc scrpit