Breadcrumbs

AddValueDirect

Directly add a new entry to the SQL database.

Syntax

  Func_FbAddValueDirect_MnDataCollector.bmp

C++
METHOD PUBLIC AddValueDirect : BOOL
VAR_INPUT
    var_name : STRING;
    var_value: STRING;
    var_type : DATACOLLECTOR_TYPE;
    var_comment : STRING;
END_VAR


Parameters

Parameter

Beschreibung

var_name 

The name for the new entry as STRING.
e.g.: 'Test entry'. 

var_value 

A value for the new entry as STRING.
e.g.: '22'.
(can also be used as unique ID) 

var_type 

Specifies the variable type as DATACOLLECTOR_TYPE.

DATACOLLECTOR_TYPE_UNKNOWN = 0
DATACOLLECTOR_TYPE_STRING = 1
DATACOLLECTOR_TYPE_INTEGER = 2
DATACOLLECTOR_TYPE_DWORD = 3
DATACOLLECTOR_TYPE_REAL = 4

The variable type is not checked -> Serves only as info for the user. 

var_comment 

A comment for the new entry as STRING. 

Rückgabewert 

TRUE: Entry Successfully added
FALSE: The entry could not be added to the SQL database.
Possible errors: Open() not called, Buffer full, SQL error 


Example

C++
data : MnDataCollector := (m_sDatabase := '\mnplc\boot\testdata.db', m_DatabaseLimit := DATACOLLECTOR_DATALIMIT_ENTRIES, m_dwDatabaseSize := 5); 

---- 

data.open(); 

data.AddValue(var_name:= 'Testeintrag', var_value:= INT_TO_STRING(i), var_type:= 0, var_comment:= 'Testkommentar');


Requirements


Remarks