December 04, 2024, 11:31:25 AM
|
Show Posts
|
Pages: [1]
|
1
|
Online Help Center / Data loggers and plug-ins / Re: SQL Database Pro
|
on: February 23, 2017, 12:47:47 PM
|
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.
|
|
|
4
|
Online Help Center / Data loggers and plug-ins / SQL Database Pro
|
on: February 20, 2017, 10: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.
|
|
|
|
Loading...
|