News:

Welcome on our forum!

Main Menu
Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - amikhailov

#1
Data loggers and plug-ins / Re: SQL Database Pro
February 23, 2017, 09:47:47 AM
It is not the case -- the data packet is a barcode scaner output, no blanks, no losses.

Each time I scan -- each time I get the error message [Field 'P4' is of an unknown type]. At the moment P4 is automatically created in parameters section and is manually assigned to the parser variable.
#2
Data loggers and plug-ins / Re: SQL Database Pro
February 22, 2017, 07:02:03 PM
Unfortunately the fix does not work. The server drops the connection, the error message is the same  [Field 'P4' is of an unknown type]
#3
Data loggers and plug-ins / Re: SQL Database Pro
February 21, 2017, 06:41:33 AM
Fixed. Thanks a lot.
#4
Data loggers and plug-ins / SQL Database Pro
February 20, 2017, 07:32:28 PM
Recently we have upgraded from the Advanced Serial Data Logger to the Data Logger Suite.
Unfortunately some of the SQL queries do not work anymore. The typical example is like this

  IF :P4 = 1 
         BEGIN
         UPDATE serialSKU
         SET SKU = (SELECT modelNum FROM instanceNum WHERE instanceNum = :P3)+:P2
         WHERE serialNum = :P1
         END

SQL editor gives an error message [Field 'P4' is of an unknown type]. How could I declare the parameter :P4 if no parameter is created after the editor error?

The query

         UPDATE serialSKU
         SET SKU = (SELECT modelNum FROM instanceNum WHERE instanceNum = :P3)+:P2
         WHERE serialNum = :P1

works just fine and creates parameters P1, P2, P3.