The error doesn't make any sense to me. There is nothing wrong with the script but if I could get some expert eyes to take a look and maybe point out what I have may missed.
"
CREATE TABLE IF NOT EXISTS temp_mailware_productupload
(
products_id INTEGER,
ChannelNo INTEGER,
ChannelAccountNo INTEGER,
ListingNo INTEGER,
ProductNo VARCHAR(51),
SKU VARCHAR(101),
Price MONEY,
IsUseCurrentRetailPrice BOOLEAN,
IsOnSale BOOLEAN,
SalePrice MONEY,
SaleStartDt DATE,
SaleEndDt DATE,
UPC VARCHAR(13),
EAN VARCHAR(14),
ISBN VARCHAR(16),
ASIN VARCHAR(11),
IsActive BOOLEAN,
IsRemove BOOLEAN,
IsDelete BOOLEAN,
LaunchDt DATE,
LeadtimeToShipDays INTEGER,
IsGiftwrapAvailable BOOLEAN,
IsGiftMessageAvailable BOOLEAN,
IsUseProductNoAsSKU BOOLEAN,
IsUseLowestPriceInChannel BOOLEAN,
LowestPriceFloor MONEY,
CurrentLowestPrice MONEY,
CurrentLowestPriceTime VARCHAR(18),
LastStockAmt FLOAT,
LastStockUpdateTime VARCHAR(18),
NewStockAmt FLOAT,
CategoryNo INTEGER,
InStock FLOAT,
IsUseCurrentInStock BOOLEAN,
ProductID VARCHAR(51),
ProductNo_1 VARCHAR(21),
Description VARCHAR(255),
InStock_1 FLOAT,
ReorderAt FLOAT,
SupplierNo FLOAT,
StockNo FLOAT,
Weight FLOAT,
Cost MONEY,
Price_1 MONEY,
Ordered FLOAT,
OrdExpectDt DATE,
BackOrdered FLOAT,
BOExpectDt DATE,
DropShip VARCHAR(6),
ReorderQty FLOAT,
ReorderPrice MONEY,
ProdType VARCHAR(3),
Message VARCHAR(51),
ShipExtraChg MONEY,
ShipCost MONEY,
Serial VARCHAR(16),
TaxExempt VARCHAR(6),
NonInventory VARCHAR(6),
LongDesc VARCHAR(255),
CustomDesc VARCHAR(255),
CustomField1 VARCHAR(51),
CustomField2 VARCHAR(51),
CustomField3 VARCHAR(51),
IsDiscontinued BOOLEAN,
AccountTypeNo FLOAT,
ShipsInOwnBox BOOLEAN,
OnMailwareWeb BOOLEAN,
WebModifiedCounter FLOAT,
LastModifiedDate FLOAT,
OptionText VARCHAR(26),
OptionDisplayOrder INTEGER,
UPC_1 VARCHAR(16),
ISBN_1 VARCHAR(16),
ManufacturerID VARCHAR(16),
Price3 MONEY,
Price4 MONEY,
MixAndMatchCode VARCHAR(21),
IsMultipleLocations BOOLEAN,
IsVinRequired BOOLEAN,
IsGenerateGC BOOLEAN,
GCPrefix VARCHAR(11),
GCSuffix VARCHAR(11),
GCLength INTEGER,
GCUseChars INTEGER,
IsCalcInsurance BOOLEAN,
DoNotAllowBackorders BOOLEAN,
HasSubstitutions BOOLEAN,
SubstProductNo VARCHAR(21),
IsPromptOnSubst BOOLEAN,
IsSubstOnDiscontinued BOOLEAN,
IsSubstOnOutOfStock BOOLEAN,
IsRoyaltyItem BOOLEAN,
SupplierProductNo VARCHAR(26),
SupplierDescription VARCHAR(26),
SupplierPrice MONEY,
TarriffCode VARCHAR(11),
DutyPct FLOAT,
PreferredCurrency VARCHAR(4),
BackorderMessage VARCHAR(51),
PreferredShipMethod VARCHAR(51),
MaxShipItems FLOAT,
IsBackorderWithoutPrompt BOOLEAN,
UnitDescription VARCHAR(21),
IsKit BOOLEAN,
Bin VARCHAR(21),
AverageCost MONEY,
SoftAllocated FLOAT,
HardAllocated FLOAT,
IsSubscription BOOLEAN,
SubscriptionFrequency VARCHAR(11),
SubscriptionStartDay INTEGER,
SubscriptionDuration INTEGER,
SubscriptionIsAutoRenewal BOOLEAN,
SubscriptionShipProductNo VARCHAR(21),
SubscriptionQuantity FLOAT,
CustomField4 VARCHAR(51),
HasNonInventoryLocation BOOLEAN,
LastUpdated VARCHAR(18),
LastInStockUpdated VARCHAR(18),
Price1VATPct FLOAT,
Price2VATPct FLOAT,
Price3VATPct FLOAT,
Price4VATPct FLOAT,
Name VARCHAR(101),
BackorderedQty FLOAT,
NewInStock FLOAT
);
"

Thanks for the help in advance

<benjiej> wrote in message
news:E01EF4C8-7C93-4A8C-98D9-4A2878D33B23@news.elevatesoft.com...
> The error doesn't make any sense to me. There is nothing wrong with the
> script but if I could get some expert eyes to take a look and maybe point
> out what I have may missed.

Weird. Extreme weird. Does not seem to like two column descriptions. Change
one letter on each, works just fine. They might have some special meaning in
SQL, but I think I've seen "description" a few times, used as a column name.

> ASIN VARCHAR(11),


> Description VARCHAR(255),

Playing around a bit with this

DROP TABLE IF EXISTS temp_mailware_productupload;
CREATE TABLE IF NOT EXISTS temp_mailware_productupload
(

asinx varchar(11),
Description BOOLEAN,
asin boolean


);

it seems that asin is never tolerated, description works only if it is the
last entry (not terminated by a comma).

Robert

"Robert K" <ngsemail2005withoutthis@yahoo.com.ar> wrote in message
news:C6BBC584-A04A-41FC-A046-30D7CDB434E7@news.elevatesoft.com...
>
>
> Weird. Extreme weird. Does not seem to like two column descriptions.
> Change one letter on each, works just fine. They might have some special
> meaning in SQL, but I think I've seen "description" a few times, used as a
> column name.
>
>> ASIN VARCHAR(11),

ASIN Returns the arcsine of a number as an angle expressed in radians - no
wonder it did not ring a bell

Anyway if you put ASIN and Description in quotes it should work fine.

Robert