Re: sqlite and gtk

["Xharbour suporte" <luiz xharbour com br>]

Hi

try

 gint linhas, colunas;
 gchar *erro;
 gchar **resultTable;
 gchar *res;
  int i; 
 if(sqlite3_get_table(db, "SELECT user FROM pnt_user;", &resultTable,
 &linhas, &colunas, &erro) != SQLITE_OK)
 {
     exit(0);
 }
 i =0;
 res=resultTable[i];
while (res != NULL)
{
 g_print("\nValue: %s",res);
  res=resultTable[i];
}
 



Atenciosamente
Luiz Rafael Culik Guimaraes
Suporte Xharbour
www.xharbour.com.br





Wed, 13 May 2009 15:03:17 -0300, frederico schardong <frede sch gmail com> escreveu:

> Hi,
> 
> I'm writing a simple application, and it use sqlite. Sometime I use:
> 
> gint linhas, colunas;
> gchar *erro;
> gchar **resultTable;
> 
> if(sqlite3_get_table(db, "SELECT user FROM pnt_user;", &resultTable,
> &linhas, &colunas, &erro) != SQLITE_OK)
> {
>     exit(0);
> }
> 
> g_print("\nValue: %s",resultTable);
> 
> ---------
> 
> This is showed on terminal:
> 
> Value: `??	???	U[`{U[`{I^C
> 
> But every time this routine is called, a different thing is showed..
> but never what is in the table.
> 
> Can anyone help me?
> 
> -- 
> Abraço,
> Frederico Schardong,
> SOLIS - O lado livre da tecnologia
> www.solis.coop.br
> _______________________________________________
> gtk-list mailing list
> gtk-list gnome org
> http://mail.gnome.org/mailman/listinfo/gtk-list
> 
>