We should consider a model on the most capable strategy to interface a QR code scanner to a database. How about we expect you’ve produced the “QR Code Scanner” application. The rule thought of this database is that customers can check QR codes through a wireless and a while later output database tables for records containing QR codes.
Acknowledge that your database keeps depictions and photos of different PC parts. Each part has a phenomenal QR code. There are bits of two sorts: Type An and Type B, so you keep these sorts in two separate tables:
“Type A Parts” table:
QR Code Scanner
“Type B Parts” table:
QR Code Scanner B
Thusly, every customer should have the choice to analyze a particular part’s QR code to look the database for this section and get all the supplemental information related to this part.
QR Code Scanned
What may you have to game plan in your database to amass this convenience?
In this model each table contains a made chronicle that keeps all the data related to the part. For instance, “Report A” can be delivered in the “Type A Parts” table.
“Record B” can be delivered in the “Type B Parts” table.
2.Auxiliary Formula-Text area
Likewise, you need to incorporate a “RecordId” collaborator formula text area to each table with the going with condition: RecordId().
Along these lines, we should make the “RecordId” condition text segment in the “Type A Part” table:
Moreover, you should make a comparable portion in the “Type B Part” table:
These areas will be used later on adjustment.
3.New “Search Requests” table
Directly you need to make another associate table. We should name it “Search Requests”. This table should join the going with areas: QR Code, Document, RecordIdA , RecordIdB, DocumentA, DocumentB.
In any case, we should make a “Scanner label type”- area called “QR Code”. Select “QR Code” elective in the “Type” dropdown:
By then incorporate a “Record Attachment” – type segment called “Document”. It will be used in the work procedure action plan.
On the accompanying stage it is basic to add two Many-to-Many relations:
– between “Type A Parts” and “Search Requests” tables
– between “Type B Parts” and “Search Requests” tables.
with the going with coordinate condition: [QR Code]=[QR Code]
In this way, you would now have the option to incorporate “RecordIdA” and “RecordIdB” plot areas to each association exclusively. These fragments pull a maximal record ID from the related “Type A Parts” or “Type B Parts” table if a separated QR code regard kept in the “Search Request” record organizes the QR code regard kept in the “Type A Parts” (or “Type B Parts”).
Here is an instance of the “RecordIdA” overview fragment:
RecordIdA overview fragment
The “recorded” overview fragment should be added to the ensuing association.
RecordIdB summation area
The most irksome development is to manufacture formula URL segments. For instance, the “Documenta” formula URL portion should contain a URL that includes the segments portrayed underneath:
Right when all the fragments are incorporated, you need to change the structure lead in the “Search Requests” table. In any case, set the “Report” segment as ‘Readonly’ on the Default Form. After that incorporate the recorded()<>”0? measures and set the ‘Readonly’ decision for then “QR Code” area in this premise.
5.Mobile Device Record Create movement
Directly you need to incorporate a convenient action allowing code separating and looking. We should set it up in the “Search Requests” table and name this movement “Journey for a record”.
The “Journey for a record” wireless ‘record makes’ movement grants QR code separating and embeddings this code into the “QR Code” segment. Thusly, another record is added to the “Search Requests” table.
6.Triggers with Mobile Device Record Update exercises
The ensuing stage is to make triggers with PDA record update exercises. In our model, you need to make two practically identical Record Change Triggers. We should name these triggers “If QRCodeA” and “If QRCodeB” independently.
If its all the same to you note that this wireless update record movement is used in the two triggers.
By and by you can incorporate the “If QRCodeB” trigger to the “Search Request” table. The plan resembles the “If QRCodeA” trigger course of action, any way you need to use the “RecordIdB” segment in the channel:
After that, you can incorporate the current “Inquiry yield” wireless update record action to the “If QRCodeB” trigger.
How to interface the QR scanner to the database?
1.Connection of PDA to a database account
To relate your PDA, for instance, mobile phone, to your record, open the “Singular information” page and snap on the “New” button in the “Contraptions” territory. Find out more details about Qr scanner.