[sqlite] SQL result to struct

[Mark Flipphi]

Hello,

I need some help with storing the result from a query into a struct.

I have a query like :

SELECT Echo.Position, Echo.Depth, Echo.dBLevel, Echo.Time, 
Echo.CommonIdx, Common.ChanNr
FROM Echo JOIN Common ON Echo.CommonIdx = Common.CommonIdx
ORDER BY Echo.Position ASC

and i need to store the information in a struct like :

typedef struct
{
    UINT64     nPosition;
    UINT16     nDepth;
    UINT8       ndBLevel;
    UINT64     nTime;
    UINT64     nIdx;
    UINT8       nChannel;
}

now i use the function :
rc = sqlite3_exec(m_SqLiteDB, sQuery, callback, 0, &zErrMsg);

static int callback(void *NotUsed, int argc, char **argv, char **azColName)
{
    //print to screen....
}

The query runs, and the results are shown in the callback function, but 
i'm sure there is a better way
to strore the data in the struct then converting the strings back to 
values.....

Are there any examples ?

With kind regards,

Mark Flipphi
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users