Ok I found the gstsqlite.h files and tried to use the below code post
ed in page 2 under post id : #337099

I am getting errors when testing in zorro for some reason. Could someone please help me with the below errors?

It says gstsqllite.h line 33

syntax error.


==

#include <acknex.h>
#include <default.c>
#include "GSTsqlite.h";

STRING* sDDBB = "test.db";
var handleDDBB;
void open_DDBB()
{
handleDDBB = GSTsqlite_OpenDatabase(sDDBB);
}

STRING* sQUERY = "select * from mytable";
var handleQUERY;
void execute_QUERY()
{
handleQUERY = GSTsqlite_ExecuteQuery(handleDDBB,sQUERY);
}

STRING* sRESULTS = "";
STRING* sTEMP = "";
void read_RESULTS()
{
while(!GSTsqlite_EOF(handleQUERY))
{
GSTsqlite_GetString(handleQUERY,"Name",sTEMP);
str_cat(sRESULTS,sTEMP);
GSTsqlite_GetString(handleQUERY,"Pass",sTEMP);
str_cat(sRESULTS,sTEMP);
GSTsqlite_NextRow(handleQUERY);
}
}


void close_QUERY()
{
GSTsqlite_CloseQuery(handleQUERY);
}

void close_DDBB()
{
GSTsqlite_CloseDatabase(handleDDBB);
}

void main ()
{
open_DDBB();
execute_QUERY();
read_RESULTS();
close_QUERY();
close_DDBB();
}