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