Breadcrumbs

mnsqlite3_GetColoumnName

Syntax

  Func_mnsqlite3_GetColoumnName.bmp

C++
FUNCTION mnsqlite3_GetColoumnName : STRING
VAR_INPUT
    iColoumn : INT;
    paszData : POINTER TO ARRAY[0..0] OF STRING;
    dwDataArraySize : DWORD;
    dwColoumnCount : DWORD;
    dwRowCount : DWORD;
END_VAR

Parameters

Parameter

Description

iColoumn 

Columns Index

paszData 

Buffer into which the read data was written. 

dwDataArraySize 

Size of the transferred buffer. 

dwColoumnCount 

Number of columns read. 

dwRowCount 

Number of rows read. 

Return value

Name of the column. 

Example

C++
pDB : DWORD;
sDatabase : STRING := '\mystorage.sqlite';
iResult: INT;
sQuery: STRING := 'SELECT * FROM sqlite_master WHERE type=$'table$'';
sErrMsg: STRING;
aData: ARRAY [0..99] OF STRING;
dwColoumnCount: DWORD;
dwRowCount: DWORD;
i : INT;
ii : INT;
sColoumnName : STRING;
sTextValue : STRING;

pDB := mnsqlite3_open(szDatabase:= sDatabase, piResult:= ADR(iResult));

iResult := mnsqlite3_exec(pDB:= pDB,
                      szQuery:= sQuery,
                      pszErrMsg:= ADR(sErrMsg),
                      paszData:= ADR(aData),
                      dwDataArraySize:= SIZEOF(aData),
                      pdwColoumnCount := ADR(dwColoumnCount),
                      pdwRowCount := ADR(dwRowCount));

iResult := mnsqlite3_close(pDB:= pDB);


FOR i := 0 TO DWORD_TO_INT(dwColoumnCount) - 1 DO
	sColoumnName := mnsqlite3_GetColoumnName(iColoumn:= i,
                                         paszData:= ADR(aData),
                                         dwDataArraySize:= SIZEOF(aData),
                                         dwColoumnCount:= dwColoumnCount,
                                         dwRowCount:= dwRowCount);
END_FOR

FOR i := 0 TO DWORD_TO_INT(dwRowCount) - 1 DO
	FOR ii := 0 TO DWORD_TO_INT(dwColoumnCount) - 1 DO
     sTextValue := mnsqlite3_GetValue(iColoumn:= ii,
                                      iRow:= i,
                                      paszData:= ADR(aData),
                                      dwDataArraySize:= SIZEOF(aData),
                                      dwColoumnCount:= dwColoumnCount,
                                      dwRowCount:= dwRowCount);
	END_FOR
END_FOR

Requirements


Remarks