Hi

A big funny I think

first I declared ...
DECLARE @Lots TABLE
(
LotID varchar(20)
)

Problem 1

when I typed Insert Into I didn't get a suggestion of @Lots as I would expect in fact no Candidate List at all

Problem 2

Then I typed the Select * from dbo.Lot and "wow" it reacted as if I had selected Insert Into Lot and piled in all the columns and the appropriate values as you expect from the automated Insert Into and I got this .....
INSERT INTO @Lots
(LotID)
SELECT * FROM dbo.Lot
        ( LotID ,
          MaterialName ,
          MaterialVersion ,
          HoldStatus ,
          QuarantineStatus ,
          CreateDate ,
          ExpirationDate ,
          ZeroDate ,
          PrimaryQty ,
          PrimaryUOM ,
          SecondaryQty ,
          SecondaryUOM ,
          CustSpecName ,
          CustSpecVersion ,
          Priority ,
          DueDate ,
          LotSuffix ,
          NextSublotIndex ,
          LastSublotIndex ,
          LockCount ,
          ProcessOrder ,
          Alias ,
          Status ,
          Locked ,
          Exception ,
          RealLot ,
          ConcessionRaised ,
          ConcessionAuthorised ,
          AuthoriseLevel ,
          FTIC ,
          ReleaseStatus ,
          SlipStream ,
          FinishedOn ,
          FinishedBy ,
          LotZeroException ,
          FinishedOnTargetDate
        )
VALUES  ( '' , -- LotID - varchar(40)
          '' , -- MaterialName - varchar(30)
          '' , -- MaterialVersion - varchar(8)
          '' , -- HoldStatus - char(15)
          '' , -- QuarantineStatus - char(15)
          '2009-06-03 07:21:51' , -- CreateDate - datetime
          '2009-06-03 07:21:51' , -- ExpirationDate - datetime
          '2009-06-03 07:21:51' , -- ZeroDate - datetime
          0.0 , -- PrimaryQty - float
          '' , -- PrimaryUOM - varchar(16)
          0.0 , -- SecondaryQty - float
          '' , -- SecondaryUOM - varchar(16)
          '' , -- CustSpecName - varchar(30)
          '' , -- CustSpecVersion - varchar(8)
          0 , -- Priority - smallint
          '2009-06-03 07:21:51' , -- DueDate - datetime
          0 , -- LotSuffix - smallint
          0 , -- NextSublotIndex - int
          0 , -- LastSublotIndex - int
          0 , -- LockCount - smallint
          '' , -- ProcessOrder - varchar(80)
          '' , -- Alias - varchar(80)
          '' , -- Status - varchar(80)
          '' , -- Locked - varchar(80)
          '' , -- Exception - varchar(80)
          '' , -- RealLot - varchar(80)
          '' , -- ConcessionRaised - varchar(80)
          '' , -- ConcessionAuthorised - varchar(80)
          '' , -- AuthoriseLevel - varchar(80)
          '' , -- FTIC - varchar(80)
          '' , -- ReleaseStatus - varchar(80)
          '' , -- SlipStream - varchar(5)
          '2009-06-03 07:21:51' , -- FinishedOn - datetime
          '' , -- FinishedBy - varchar(30)
          0 , -- LotZeroException - tinyint
          '2009-06-03 07:21:51'  -- FinishedOnTargetDate - datetime
        )
MikeONeill
0

Comments

1 comment

  • tanya
    Hi,

    Oops...sorry about the bug (Problem 2)
    But it is a good catch! We will have this sorted for the RC.

    Problem 1 - Temporary tables are not yet implemented and that is the reason you don't see support for it. However, this will be done for the release.

    Thank you for taking the time to report the issue.

    Regards,
    Tanya
    Project Manager
    Red Gate Software Ltd
    tanya
    0

Add comment

Please sign in to leave a comment.