Reading the correct record 关注
Hello, I'm having trouble reading a value from another column when it has a value. In the quare, I have done a SQL database search by EAN code. Finds the product for me and downloads the data. From another table, I am supposed to get the value to the QR code, but it doesn't. After reading from SQL, my product has over 200 records and the QR value is in different places. In all these records, descriptions etc. are duplicated only until the QR data occurs only once. It is in a separate column. The tables are correctly connected. I don't know how to load a record with this content for QR code. Thank you for your help.
I enter the product code into the coffee shop and then select the type of label.
F-PL and the program is to download from the database only the record for printing Y QR code for PL.
After selecting the appropriate label layer, the program is to load the correct record from the QR code so that the operator does not choose the type of record anymore. And if there is nothing in this column with QR code, it should find and print a label from the SQL database.