Currently, I am in the process of incorporating a new function into an existing Classic ASP system. This feature involves allowing users to scan a barcode that will automatically populate a text field within a form inside a bootstrap modal. The scanner has been set up to transmit a TAB input following the scanned data.
My main requirement is to execute a database query when the field is exited and fill other fields in the modal with information retrieved from the query based on the scanned value. It is crucial for this process to occur without refreshing the page or closing the modal so the user can review the details and make any necessary changes before submitting the form.
What would be the most effective approach to achieve this? While I am comfortable creating the stored procedure (SP) needed for the task, I am unsure about how to initiate the call to the SP and receive its output. Would it be feasible to utilize JavaScript/PHP for these purposes?