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@xxxxxxxxx> 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@xxxxxxxxx
> http://mail.gnome.org/mailman/listinfo/gtk-list
>
>
_______________________________________________
gtk-list mailing list
gtk-list@xxxxxxxxx
http://mail.gnome.org/mailman/listinfo/gtk-list
