Results 1 to 2 of 2

Thread: Help me

  1. #1
    Join Date
    Aug 2004
    Posts
    2

    Exclamation Unanswered: Help me

    Hi all,
    Can anybody mail me full procedure to write a form to scan barcode using hand scanner in forms 6i.
    Kindly reply me

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    You, basically, don't need a procedure. Just create a field (input must be allowed) that is long enough to hold value read by a hand scanner.

    Of course, when you have that field populated, you can write a simple query to extract parts of it if necessary.

    For example, you read something like 0387779-23-08045.
    When you read this value from a document, it is stored into a field named PNB. Next, you'll do something like:
    :ID := SUBSTR(:pnb, 1, 7);
    :vk := SUBSTR(:pnb, 9, 2);
    :mmyy := SUBSTR(:pnb, 12, 4);
    :k := SUBSTR(:pnb, 16, 1);

    And that's it.
    Last edited by Littlefoot; 08-17-04 at 18:10.

Posting Permissions

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