Registriert seit: 3. Jun 2003
Ort: Thüringen
2.272 Beiträge
Delphi 10.4 Sydney
|
Re: Unterschiede zwischen Classic Server und Embedded Server
13. Apr 2006, 21:18
Ja hat noch mehr Felder. Unterschiedliche Typen und alle mit Default-Vorgabe. Hab die DDL mal unten angefügt.
Könnte es sein daß der Embedded Server an einem der Default-Werte scheitert? Doof nur daß er nicht sagt in welcher Spalte es kracht. So kann man nur raten.
SQL-Code:
CREATE TABLE PRODUCTS (
PRODUCTS_ID TINT11 NOT NULL,
PRODUCTS_QUANTITY TINT4 DEFAULT 1,
PRODUCTS_SHIPPINGTIME TINT4 DEFAULT 1,
PRODUCTS_MODEL TSTR64 DEFAULT '',
GROUP_IDS TSTR255 DEFAULT '',
PRODUCTS_SORT TINT4 DEFAULT 9999,
PRODUCTS_IMAGE TSTR64 DEFAULT 'notfound.png',
PRODUCTS_PRICE TPRICE DEFAULT 0,
PRODUCTS_DISCOUNT_ALLOWED TSMALLPRECISION DEFAULT 0,
PRODUCTS_DATE_ADDED TDATETIME DEFAULT '01.01.1979',
PRODUCTS_LAST_MODIFIED TDATETIME DEFAULT '01.01.1979',
PRODUCTS_DATE_AVAILABLE TDATETIME DEFAULT '01.01.1979',
PRODUCTS_WEIGHT TWEIGHT DEFAULT 0,
PRODUCTS_STATUS TINT1 DEFAULT 1,
PRODUCTS_TAX_CLASS_ID TINT11 DEFAULT 1,
PRODUCT_TEMPLATE TSTR64 DEFAULT 'default',
OPTIONS_TEMPLATE TSTR64 DEFAULT 'default',
MANUFACTURERS_ID TINT11 DEFAULT 0,
PRODUCTS_ORDERED TINT11 DEFAULT 0,
PRODUCTS_FSK18 TINT1 DEFAULT 0,
LANGUAGE_ID TINT11 DEFAULT 2,
PRODUCTS_NAME TSTR64 DEFAULT 'No product name defined',
PRODUCTS_DESCRIPTION TLONGSTRING DEFAULT 'No product description defined',
PRODUCTS_SHORT_DESCRIPTION TLONGSTRING DEFAULT 'No product description defined',
PRODUCTS_META_TITLE TLONGSTRING DEFAULT 'No product name defined',
PRODUCTS_META_DESCRIPTION TLONGSTRING DEFAULT 'No product description defined',
PRODUCTS_META_KEYWORDS TLONGSTRING DEFAULT 'No product keywords defined',
PRODUCTS_URL TSTR255 DEFAULT '',
PRODUCTS_VIEWED TINT5 DEFAULT 0);
|
|
Zitat
|