Erarslan

I would like to make using SQLite database to my project. for this, I used "SQLite.dll".  Many function defined in SQLite.dll is running. But when I call "SELECT" command is not reply. Maybe I'm making some wrong. I'm adding SQLite.dll and code for this topic. Could you please give us your suggestion?

My DAQ factory code;

global dbOpen
global dbCommand
global dbError
global dbClose

global string dbase = "DataLogger.db"
global dbe
global string sql
global callback
global string error
global data

//sql = "CREATE TABLE logTable(ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL UNIQUE, ChannelName CHAR(25) NOT NULL, Value INTEGER NOT NULL)" (This OK)
//sql = "INSERT INTO logTable (ID,ChannelName,Value) VALUES(1,'Channel1',25)" (This Ok)
sql = "SELECT * FROM dataLog"  (This no reply)

extern("C:\DAQFactory\sqlite3.dll","long sqlite3_open(string,long[1])","SQLiteOpen","stdcall")
dbOpen = SQLiteOpen(dbase,@dbe)

extern("C:\DAQFactory\sqlite3.dll","long sqlite3_exec(long,string,long,string,string[20])","SQLiteCmd","stdcall") 
dbCommand = SQLiteCmd(dbe,sql,callback,NULL,@error)

extern("C:\DAQFactory\sqlite3.dll","long sqlite3_errmsg()","SQLiteErr","stdcall")
dbError = SQLiteErr(dbe)

extern("C:\DAQFactory\sqlite3.dll","long sqlite3_close(long)","SQLiteClose","stdcall")
dbClose = SQLiteClose(dbe)
 

---------------------------------------------------

C project code related to the topic

https://stackoverflow.com/questions/31146713/sqlite3-exec-callback-function-clarification

I think I can't run the Calback function like in this example

Thanks in advance for your help,

SQLite3.dll

Yes, I this know function system.hideSystemMenu(). I used before this. I will try this method.

thank you so much

I am created only data collection program, not monitoring, but this running in Windows Desktop and I want mistakenly not closed. Acquire Mode icon not in an easy place and users will not be able easy close.

thanks for your answer

Hello,

my in Project want use "Acquire Mode" but, how can not  find to do in DaqFactory Main Menu. 

MQTT Protocol is so popular on last days. Customers are wanting to reach "Historical Data" in dataloggers. The best solution is seen as MQTT protocol. So customers are asking to us SCADA that have MQTT protocol. To answer to demand, MQTT is need to be.

Hy,

Do you have any plans for adding MQTT communication protocol to DAQFactory?