Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    Hong kong
    Posts
    14

    Unanswered: Invalid identifier

    Could you help me to check the following syntax or data type is valid or not as nobody in my office know this?
    It prompt invalid identifier.


    Thanks for your big help

    sSql = "CREATE TABLE TZPMS0004 ([QuoteNo] [varchar] (10) NOT NULL , [QuoteVer] [float] NOT NULL , " & _
    "[QuoteType] [varchar] (5) NOT NULL ,[QuoteDate] [datetime] NOT NULL , " & _
    "[SALESMAN_CODE] [varchar] (5) NOT NULL , [SalesOffice] [varchar] (6) NOT NULL , " & _
    "[WorkSheet] [varchar] (30) NULL ,[CUST_CODE] [varchar] (5) NULL ," & _
    "[CustName] [varchar] (45) NOT NULL , [PartNo] [varchar] (40) NULL , " & _
    "[Layer] [smallint] NULL , [ArrayDel] [smallint] NULL ," & _
    "[MatGrade] [varchar] (30) NULL , [MatGradeDesc] [varchar] (30) NULL , " & _
    "[CopperThick] [float] NULL ,[BoardThick] [float] NULL ," & _
    "[SizeMMH] [float] NULL ,[SizeMMW] [float] NULL ,[SizeInH] [float] NULL , " & _
    "[SizeInW] [float] NULL ,[AreaIn] [float] NULL ,[MatInH] [float] NULL , " & _
    "[MatInW] [float] NULL ,[PanelInH] [float] NULL , [PanelInW] [float] NULL , " & _
    "[PanelSht] [smallint] NULL ,[UnitPanel] [smallint] NULL ,[UnitSht] [smallint] NULL ," & _
    "[Wastage] [float] NULL , [NoHole] [smallint] NULL , [MinHole] [float] NULL , " & _
    "[StackDrill] [float] NULL ,[Impedance] [float] NULL ,[ExtraMat] [float] NULL , " & _
    "[SMOBCHASL] [bit] NULL ,[SMOBCEntek106A] [bit] NULL ,[ImmSilver] [bit] NULL , " & _
    "[DipGold] [bit] NULL ,[ImmTin] [bit] NULL ,[SMOBCEntek56] [bit] NULL , " & _
    "[ImmGold] [bit] NULL ,[GoldFinger] [bit] NULL ,[FlashGold] [bit] NULL , " & _
    "[GoldAdder] [varchar] (30) NULL ,[DF2nd] [float] NULL ,[PlugVia] [float] NULL , " & _
    "[PacoviaSht] [float] NULL ,[Vcut] [float] NULL , [PeelabeSM] [float] NULL , " & _
    "[BlBurVia] [float] NULL , [CarbonInk] [float] NULL ,[Wspacing] [varchar] (30) NULL , " & _
    "[Xout] [varchar] (30) NULL ,[XOutDesc] [varchar] (30) NULL ,[Repair] [bit] NULL ," & _
    "[ExpYield] [float] NULL ,[EngSetup] [float] NULL ,[Etest] [float] NULL ," & _
    "[HardTool] [float] NULL , [Outline] [varchar] (5) NULL , [OutRoute] [smallint] NULL ," & _
    "[ShipTerm] [varchar] (6) NULL ,[ShipTermDesc] [varchar] (30) NULL ,[Curr] [varchar] (5) NULL , " & _
    "[Status] [tinyint] NULL ,[CrtDate] [datetime] NULL ,[CrtBy] [varchar] (50) NULL ,[ModDate] [datetime] NULL ,[ModBy] [varchar] (50) NULL ,[Location] [varchar] (30) NULL ,[DatePrint] [datetime] NULL) ON [PRIMARY] "

  2. #2
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    From the data types you listed (smallint, bit, tinyint, datetime) it appears you are trying to execute a Microsoft SQL-Server statement, not an Oracle SQL statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •