11-14-2016 10:49 AM
Hi, I use Labview db toolkit, but don't show the query answer in front panel.
I use this query with "Execute Query VI" :
UPDATE dbo.trc_PCBA_Linky
SET WorkOrderName='Workorder',BoxID=123,Packing_Timestamp=GETDATE(),Packing_Result=1
where [Serial_PCBA]= 'ABCDEFG1234' AND [ICT_Result]=1 AND Packing_Result is null
if(@@ROWCOUNT=1)
PRINT 'Packed!'
I want to get back the query answer "Packed!" How can I get back the SQL PRINT answer?
11-14-2016 11:55 AM
Do you need to get back the SQL print command?
Why not have LabVIEW display the string "Packed" in an indicator if the function that is executing the SQL command returns without an error?
11-14-2016 02:21 PM
if(@@ROWCOUNT=1)
PRINT 'Packed!'
- If it is not '1' SQL not drop an error.
- When I want to use more IF state in sql command, it is returns more option/answer.