[RBG7-L] - Re: Pocket Rbase question

[ttc . inc]

Tony,

  Thank you for responding.  What I am trying to accomplish is to display on the handheld,  a message screen "Invalid Item Number" when an item number is entered that does not exist in the database.  Currently the form allows a user to either manually type in a part number, or scan a UPC code and retrieve information from an Item Master database.  However if the user enters a part number or scans a UPC code that does not exist, the form displays a part number that has the same starting characters.  I.E. the user enters a non-existing part number 7456, the form will display part number 7420 which does exist.  If the starting characters of the entered number does not match anything in the database,  the form displays the first record.  This is extremely "dangerous" when scanning UPC codes.  A user may scan a code and it will pull up a part number, even if the code they scanned was not for an existing part number.  The human readable characters do not contain the part number, so they may assume the data is correct.

 

So I want a screen to display "Error - Invalid Item Number" when an invalid number or UPC code is keyed/scanned.  If the number entered is found in the database, then I want the form to display the item information.  (It displays the information fine if the item number is valid, I just cannot figure out how to display an error message if the item is not found)

 

Thank you for the assistance!

 

-Bob

 

-------------- Original message --------------

> Bob,
>
> Sorry for the delay,
>
> Now let me get this right, if the row does NOT exist you want to have the
> system create a new entry ? So basically a macro which will allow a new
> record to be created ? if one does not exist already after the scan ?? If
> this is so would you like it to create this record automatically and the
> user fills out the details or give the user a message that the row was not
> found then create a new record ??
>
> ----- Original Message -----
> From: "Thompson Technology Consultants" <[EMAIL PROTECTED]>
> To: "RBG7-L Mailing List"
> Sent: Sunday, March 20, 2005 2:30 PM
> Subject: [RBG7-L] - Re: Pocket Rbase question
>
>
> > Tony,
> > I was hoping you might volunteer. I really do appreciate it and look
> > forward
> > to your suggestions.
> >
> > Thank you again!
> > -Bob
>