Database

Both VB and C# contain a way of testing mutually exclusive possibilities, the Select Case and Switch clauses respectively. Only one of them works properly.

A Visual Basic Select Case clause, returning a description of how old someone is. The age range for a young person is a tad generous, reflecting the age of the author of this article.

Quote:

Have you contacted the manufacturer of said scanner and asked them how to interact with it programmatically? Probably through an API that they would have to provide.

CREATE TABLE ControlNumbers (
LastNumber Varchar(50)
)

Hotaxion wrote:

CREATE TABLE ControlNumbers (
LastNumber Varchar(50)
)

CREATE TABLE ControlNumbers (
LastNumber Int IDENTITY(1,1)
)

CREATE TABLE IdsList(id INT IDENTITY(1,1), datum CHAR(1));
-- datum is an arbitrary column 

INSERT #IdsList(datum) VALUES('x');
declare @lastnum int  = (SELECT SCOPE_IDENTITY())

ALTER PROCEDURE [dbo].[sp_HeaderSave] (@Lastnumber int OUTPUT) AS

BEGIN

  BEGIN TRANSACTION [MyTrans]

  BEGIN TRY

    INSERT #IdsList(datum) VALUES('x');
    SET @lastnumber int  = (SELECT SCOPE_IDENTITY())

    INSERT INTO Header (DOCNo, VersionNo, NoteDate)
    VALUES (@Lastnumber,'VersionNo',GETDATE())

    COMMIT TRANSACTION [MyTran]

  END TRY

  BEGIN CATCH

    ROLLBACK TRANSACTION [MyTran]

  END CATCH  
END