diadem BindChannel not SQL_BindChannel

[AlexandreHSCastro]

Hello,

I'm using DIAdem + Labview connectivity VI's to produce reports. The data is stored on a MySQL DB. No problems here.

I use the "Run automation command.vi" with the following command SQL_BindChannel("CHANNEL_X" , "Value" , "n") to pass the data stored in field "Value" to channel CHANNEL_X. So far so good.

Then DIAdem generates the graphic report nicely.

Now i would like to add some some data to the graphic report, think of it as Upper and Lower limits. how can I do it? I want to pass a constant value

Kind of:

BindChannel("upperlimit", "5.5","n")... My problem is that I don't know the syntax to do it.

Thanks in advance, Alex

[Brad_Turpin]

Hi Alexandre,

I'd recommend that you set two of the user variables, say R5 and R6, from LabVIEW, then interactively configure your REPORT layout to display 2 constant curves, one with a Y value = R5 and the other with a Y value = R6.  Once you save these changes to your *.TDR layout file, then all you need to do from LabVIEW is set R5 and R6 and execute PicUpdate (which you're doubtless already doing).

Brad Turpin

DIAdem Product Support Engineer
National Instruments

[AlexandreHSCastro]

Hi, Welll this is kind of what I'm already doing.

Except for the PicUpdate thing.

The curves i'm using are all from the database anda I select them by running this commad:

SQL_ExecDirect("select `Time_Stamp` ,
    `Value`
from `Table` where IFIELD1='48' and 2='DUT' and IFIELD3='38' and IFIELD4='1'  and Time_Stamp >= '2010-05-19 10:00:00' and Time_Stamp <='2010-05-19 10:54:59';")

then I bind the channel using this command: SQL_BindChannel("1Radio1C1" , "Value" , "n")

Now I want to add a constant curve with a Y value= 10

My *.TDR file is ready to receive new curves Called 1SupLimit1C1. But I don't know the syntax SQL_BindChannel generates an error.

Thx 

[Brad_Turpin · Accepted solution]

Hi Alex,

It sounds like you didn't understand my suggestion.  By all means continue using SQL_BindChannel to send your 2 queried data base columns to data channels in DIAdem, but DO NOT try to use the SQL_BindChannel command to send a constant value that you have in LabVIEW to DIAdem.  The rule here is that if you didn't query it, you don't have to bind it.  So far it has sounded like your constant value of 10 did NOT come from the data base, so you don't have to bind it.

Instead, send that value (10) to a DIAdem VARIABLE, and reference the VARIABLE as the source of the REPORT curve, not a channel. 

Brad Turpin

DIAdem Product Support Engineer
National Instruments