Article View: borland.public.cppbuilder.database.ado
Article #4084Record Size
From: Sam S. Firouz
Date: Wed, 10 Apr 2002 19:09
Date: Wed, 10 Apr 2002 19:09
230 lines
8266 bytes
8266 bytes
Hi: I have an INTERBASE database an I created a table using this SQL statment: CREATE TABLE SignData ( IndexSignNumber SMALLINT NOT NULL, SysDescr VARCHAR(255), SysObjectId VARCHAR(19), SysUpTime INTEGER, SysContact VARCHAR(255), SysName VARCHAR(255), SysLocation VARCHAR(255), SysServices SMALLINT, ReservedAtLapbRs232Tables BLOB SUB_TYPE 2, SnmpInPkts INTEGER, SnmpOutPkts INTEGER, SnmpInBadVersions INTEGER, SnmpInBadCommunityNames INTEGER, SnmpInBadCommunityUses INTEGER, SnmpInASN1ParseErrors INTEGER, SnmpInTooBigs INTEGER, SnmpInNoSuchNames INTEGER, SnmpInBadValues INTEGER, SnmpInReadOnlys INTEGER, SnmpInGenErrs INTEGER, SnmpInGetRequests INTEGER, SnmpInGetNexts INTEGER, SnmpInSetRequests INTEGER, SnmpInGetResponses INTEGER, SnmpInTraps INTEGER, SnmpOutTooBigs INTEGER, SnmpOutNoSuchNames INTEGER, SnmpOutBadValues INTEGER, SnmpOutGenErrs INTEGER, SnmpOutGetRequests INTEGER, SnmpOutGetNexts INTEGER, SnmpOutSetRequests INTEGER, SnmpOutGetResponses INTEGER, SnmpOutTraps INTEGER, SnmpEnableAuthenTraps INTEGER, StatBeacons SMALLINT, StatHVAC SMALLINT, StatUPS SMALLINT, TempMinSignFace SMALLINT, TempMaxSignFace SMALLINT, PhotoCellLevelNorth INTEGER, PhotoCellLevelFront INTEGER, PhotoCellLevelRear INTEGER, DmsSpeedLimitMessage BLOB SUB_TYPE 2, NumGraphics SMALLINT, MaxGraphics SMALLINT, ReservedMIB1 BLOB SUB_TYPE 2, DmsSignAccess SMALLINT, DmsSignType SMALLINT, DmsSignHeight INTEGER, DmsSignWidth INTEGER, DmsHorizontalBorder INTEGER, DmsVerticalBorder INTEGER, DmsLegend SMALLINT, DmsBeaconType SMALLINT, DmsSignTechnology SMALLINT, VmsCharacterWidthPixels SMALLINT, VmsCharacterHeightPixels SMALLINT, VmsSignWidthPixels INTEGER, VmsSignHeightPixels INTEGER, VmsHorizontalPitch SMALLINT, VmsVerticalPitch SMALLINT, DefaultBackgroundColor SMALLINT, DefaultForegroundColor SMALLINT, DefaultFlashOn SMALLINT, DefaultFlashOff SMALLINT, DefaultFont SMALLINT, DefaultJustificationLine SMALLINT, DefaultJustificationPage SMALLINT, DefaultPageOnTime SMALLINT, DefaultPageOffTime SMALLINT, DefaultCharacterSet SMALLINT, DmsNumPermanentMsg SMALLINT, DmsNumChangeableMsg SMALLINT, DmsMaxChangeableMsg SMALLINT, DmsFreeChangeableMemory INTEGER, DmsNumVolatileMsg SMALLINT, DmsMaxVolatileMsg SMALLINT, DmsFreeVolatileMemory INTEGER, DmsMessageMemoryTypeVol SMALLINT, DmsMessageNumberVol SMALLINT, DmsMessageMultiStringVol1 VARCHAR(171), DmsMessageMultiStringVol2 VARCHAR(171), DmsMessageMultiStringVol3 VARCHAR(170), DmsMessageOwnerVol VARCHAR(128), DmsMessageCRCVol SMALLINT, DmsMessageBeaconVol SMALLINT, DmsMessagePixelServiceVol SMALLINT, DmsMessageRunTimePriVol SMALLINT, DmsMessageStatusVol SMALLINT, DmsMessageMemoryTypeCB SMALLINT, DmsMessageNumberCB SMALLINT, DmsMessageMultiStringCB1 VARCHAR(171), DmsMessageMultiStringCB2 VARCHAR(171), DmsMessageMultiStringCB3 VARCHAR(170), DmsMessageOwnerCB VARCHAR(128), DmsMessageCRCCB INTEGER, DmsMessageBeaconCB SMALLINT, DmsMessagePixelServiceCB SMALLINT, DmsMessageRunTimePriCB SMALLINT, DmsMessageStatusCB SMALLINT, DmsValidateMsgError SMALLINT, DmsControlMode SMALLINT, DmsSWReset SMALLINT, DmsActivateMessage BLOB SUB_TYPE 2, DmsMessageTimeRemaining INTEGER, DmsMsgTableSource BLOB SUB_TYPE 2, DmsMsgRequesterID INTEGER, DmsMsgSourceMode SMALLINT, DmsShortPowerRecoveryMess BLOB SUB_TYPE 2, DmsLongPowerRecoveryMess BLOB SUB_TYPE 2, DmsShortPowerLossTime INTEGER, DmsResetMessage BLOB SUB_TYPE 2, DmsCommunicationsLossMess BLOB SUB_TYPE 2, DmsTimeCommLoss INTEGER, DmsPowerLossMessage BLOB SUB_TYPE 2, DmsEndDurationMessage BLOB SUB_TYPE 2, DmsMemoryMgmt SMALLINT, DmsActivateMsgError SMALLINT, DmsMultiSyntaxError SMALLINT, DmsMultiSyntaxErrorPos INTEGER, VmsPixelServiceDuration INTEGER, VmsPixelServiceFrequency INTEGER, VmsPixelServiceTime INTEGER, DmsIllumControl SMALLINT, DmsIllumMaxPhotocellLevel INTEGER, DmsIllumPhotocellLevelSta INTEGER, DmsIllumNumBrightLevels SMALLINT, DmsIllumBrightLevelStatus SMALLINT, DmsIllumManLevel SMALLINT, DmsIllumBrightnessValues BLOB SUB_TYPE 2, DmsIllumBrightnessValErr SMALLINT, DmsIllumLightOutputStatus INTEGER, MaxAuxIODigital SMALLINT, MaxAuxIOAnalog SMALLINT, AuxIOPortType BLOB SUB_TYPE 2, AuxIOPortNumber BLOB SUB_TYPE 2, AuxIODescription0 VARCHAR(50), AuxIODescription1 VARCHAR(50), AuxIODescription2 VARCHAR(50), AuxIODescription3 VARCHAR(50), AuxIODescription4 VARCHAR(50), AuxIODescription5 VARCHAR(50), AuxIODescription6 VARCHAR(50), AuxIODescription7 VARCHAR(50), AuxIOResolution BLOB SUB_TYPE 2, AuxIOValue0 INTEGER, AuxIOValue1 INTEGER, AuxIOValue2 INTEGER, AuxIOValue3 INTEGER, AuxIOValue4 INTEGER, AuxIOValue5 INTEGER, AuxIOValue6 INTEGER, AuxIOValue7 INTEGER, AuxIOPortDirection BLOB SUB_TYPE 2, StatMultiFieldRows SMALLINT, Reserved3 BLOB SUB_TYPE 2, StatMultiFieldIndex BLOB SUB_TYPE 2, StatMultiFieldCode BLOB SUB_TYPE 2, StatMultiCurrentFieldVal BLOB SUB_TYPE 2, DmsCurrentSpeed SMALLINT, DmsCurrentSpeedLimit SMALLINT, DmsStatDoorOpen SMALLINT, ShortErrorStatus INTEGER, PixelTestActivation SMALLINT, LampFailureStuckOff BLOB SUB_TYPE 2, LampTestActivation SMALLINT, FanTestActivation SMALLINT, ControllerErrorStatus SMALLINT, SignVolts INTEGER, PowerSource SMALLINT, TempMinCtrlCabinet SMALLINT, TempMaxCtrlCabinet SMALLINT, TempMinAmbient SMALLINT, TempMaxAmbient SMALLINT, TempMinSignHousing SMALLINT, TempMaxSignHousing SMALLINT, PixelFailureTableNumRows INTEGER, PixelFailureDetectionType BLOB SUB_TYPE 2, PixelFailureXLocation BLOB SUB_TYPE 2, PixelFailureYLocation BLOB SUB_TYPE 2, PixelFailureStatus BLOB SUB_TYPE 2, ReservedMIB2 BLOB SUB_TYPE 2, GlobalMaxModules INTEGER, ModuleNumber0 INTEGER, ModuleNumber1 INTEGER, ModuleNumber2 INTEGER, ModuleDeviceNode1 BLOB SUB_TYPE 2, ModuleMake0 VARCHAR(128), ModuleMake1 VARCHAR(128), ModuleMake2 VARCHAR(128), ModuleModel0 VARCHAR(128), ModuleModel1 VARCHAR(128), ModuleModel2 VARCHAR(128), ModuleVersion0 VARCHAR(128), ModuleVersion1 VARCHAR(128), ModuleVersion2 VARCHAR(128), ModuleType BLOB SUB_TYPE 2, GlobalTime INTEGER, GlobalLocalTimeDifference SMALLINT, GlobalDaylightSaving SMALLINT, PhoneNumber VARCHAR(32), ClassBAddress SMALLINT, IPAddress VARCHAR(16), PriChan SMALLINT, SecChan SMALLINT, PriBaud SMALLINT, SecBaud SMALLINT, AutoPoll INTEGER, MIBVersion SMALLINT, MessageTableIndex SMALLINT, NonMibModuleType SMALLINT, DmsVersion SMALLINT, GlobalVersion SMALLINT, FontTable SMALLINT, MibFlags INTEGER, ReservedNON_MIB1 BLOB SUB_TYPE 2, PRIMARY KEY (IndexSignNumber) ) The database wase created fine but when I try to look at the table usinf "Database Desktop" or "SQL Explorer" it says "The Record size is too big". I have the same table in Paradox database and it works just fine. what am I doing wrong? Thanks
Technical Details
Message-ID:
<3cb48f61_2@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!newsfeed.gamma.ru!Gamma.RU!news.maxwell.syr.edu!news-xfer.newsread.com!bad-news.newsread.com!netaxs.com!newsread.com!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnewsShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,7dffe87ed2e998c1,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-04-10 12:31:12 PST Reply-To: "Sam S. Firouz" <sfirouz@mmm.com> From: "Sam S. Firouz" <sfirouz@mmm.com> Newsgroups: borland.public.cppbuilder.database.ado Subject: Record Size Date: Wed, 10 Apr 2002 12:09:27 -0700 Lines: 232 Organization: 3M X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 NNTP-Posting-Host: 165.152.92.161 Message-ID: <3cb48f61_2@dnews> X-Trace: dnews 1018466145 165.152.92.161 (10 Apr 2002 12:15:45 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!newsfeed.gamma.ru!Gamma.RU!news.maxwell.syr.edu!news-xfer.newsread.com!bad-news.newsread.com!netaxs.com!newsread.com!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews