urdey

Hi Good morning Sir Thanks for your reply.In MySQL Arduino is the SQL database dht11_log is the sensor and column temperature, humidity, and timestamp are stored in SQL format. I want to display individual parameter temperature , humidity, and timestamp in DAQFACTORY Page as shown in the attachment. Waiting at your earliest convenience. Best Regards UDEY

Hi Thanks for the reply I can open Db but I want to read from MySQL and display Temperature and humidity in page. Temperature and humidity is an integer . Daqfactory can read charor varchar from MySQL so how to display the content in page. //how to update a record in MYSQL private dbase = db.Open("arduino") private result = db.QueryToClass(dbase,"select * from dht11_logs;") db.execute(dbase,"update dht11_logs set temperature = 50") db.execute(dbase, "update dht11_logs set humidity=32") try private dbase = db.Open("arduino") private result = db.QueryToClass(dbase,"select * from dht11_logs;") db.execute(dbase,"update dht11_logs set temperature = 90") db.execute(dbase,"update dht11_logs set humidity=0" global datain = db.QueryToClass(dbase,'select * from dht11_logs;') global string dht11_logs = datain.content ?"Getting sucessfully !" db.Close(dbase) catch () ?"Fail to connect!" endcatch Waiting at your earliest. Regards

yes, temperature name of the table. I would be grateful if you tell me the format to read the table through a query command and displaying the value or a channel or update the channel. global dbase global qr global count global thetime global batch global start global strTime global dbase = db.Open("arduino") db.queryToClass(dbase, "select * from arduino;") db.execute(dbase, "update table1 set NAME = 'xyz' where ID=60") //global qr =db.QueryToClass(dbase,"select*from temperature") error message O1004 Unable to run query: db Line 19 - Uncaught error in sequence db Regards Udipta

I changed the driver 3.5 dbase open but I want to read temperature unable to run query

Dear Sir I am trying to open MySQL databases as connection to ODBC with MySQL is ok . Communicating Daqfactory with MySQL showing unable to open database and I want to read tables and want to display the content of the table on the page. Best Regards Udipta

{"cid":-1,"data":{"value":"0121FF02"},"code":200} private index = find(in, "code", 0) How to write a sequence to a get code value

Hi Guru HTTP.Get(); private string in = HTTP.Get("192.168.1.250") AL1350.Path ="/iolinkmaster/port[4]/iolinkdevice/pdin/getdata" Find("value","getdata",0) global string hex = "value" Evaluate("value") myChannel = Evaluate("0x" + hex) while(1) myChannel.query() delay(60) endwhile Command/Alert shows C1040 channel does not have any valid values line 15 uncaught in sequence Temperature values is not updating and showing 0.0000 Regards

Hi Guru Thanks for reply HTTP.Get(); private string in = HTTP.Get("192.168.1.250") AL1350.Path ="/iolinkmaster/port[4]/iolinkdevice/pdin/getdata" Find("value","getdata",0) Evaluate("value") private string hex = "value" private dec = evaluate("0x" + hex) How to display value as channel in page since value is temperature in decimal format

Hi Guru I try to use the sequence as below and begin sequence also command alert message The HTTP error and sequence not running. Thanks

I have IO=Link device Browser can communicate with device http://192.168.1.250/iolinkmaster/port[4]/iolinkdevice/pdin/getdata and gives Json output {"cid":-1,"data":{"value":"00D1FF00"},"code":200} How I will interface with steps of DAQFACTORY converting value hexadecimal to decimal to be displayed in its page

After setting Real time Web Access as localhost .and while connecting showing error using from Daqfactory but in local browser local host works . Why I can not connect local host form daqfactory

DAQFactory can it support PUT,POST ,DELETE command like GET command?. How Data will be transferred in JSON or JavaScript format from DAQFACTORY to website

How and what command DAQFACTORY will take screenshots of pages then upload command them to a webserver.What DAQFACTORY queries commands the server at some interval through xml or json from webserver.

My main intention is to display DAQ HMI Screen in the website or webserver and few javascript code action from webserver to DAQFACTORY HMI Start and Stop process.

How to send devices data to web browser using html javascript from DAQ FACTORY