Saltar al contenido principal

Búsqueda

Búsqueda

Automated database lookup

Comentarios

2 comentarios

  • Avatar
    pthane

    As it sounds like you have already configured the label with a filter/query prompt that will interrogate your SQL data and pull out the correct record it sounds like all you need to do with the Integration is tell it that the serial prompt input will be used to populate that query. 

    I believe all you need to do for this is create a Serial Prompt Integration, configuring the input settings to match your scanners com port settings and then link the Print Document setting to your label, import the settings, and then configure the to use the (Insert Variable) %Event Data% (ie what has just been scanned) as the query prompt/filter value in your label and so it should look something like this

    You do not need to execute any SQL at this point as the label is already configured to do this 

    0
  • Avatar
    Tamas Gaspar

    Thank you for your reply Peter!

    I think the problem was that I've had a database connection in the design, that brought me the data for all the possible products and I have filtered this data in another query in the integration, since I needed the barcode from the serial port to identify the product I want to print the label for. I have tried your solution, however the recordset transferred from the sql query doing the filtering to the Print action with the variable %EventData% does not get parsed. I am still getting the error "Recordset type "SQL Server Database" cannot be overridden by specifying data in <TextData>." with this method. 

    As a workaround, I did the whole thing the other way around. I have two integrations one for the serial port, which executes the filtering and writes the recordset to a text file, (I've connected my template to this text file), and another for file detection that takes the single record upon detection and prints it. This seems to work fine for the moment.

    0

Iniciar sesión para dejar un comentario.