RE: [sqlite] correct use of sqlite3_get_table

2005-03-03 Thread Richard Boyd
: [sqlite] correct use of sqlite3_get_table Richard Boyd wrote: > Hi all, > > I’m trying to use sqlite3_get_table() to execute SQL commands on a > database. I’ve included a code snippet below. > > The problem I’m having is that when I execute the "SELECT > MAX(time_stamp) FR

Re: [sqlite] correct use of sqlite3_get_table

2005-03-03 Thread Dennis Cote
Richard Boyd wrote: Hi all, I’m trying to use sqlite3_get_table() to execute SQL commands on a database. I’ve included a code snippet below. The problem I’m having is that when I execute the "SELECT MAX(time_stamp) FROM table32;” command using sqlite3_get_table() I only get one column and 1

[sqlite] correct use of sqlite3_get_table

2005-03-02 Thread Richard Boyd
Hi all,   I’m trying to use sqlite3_get_table() to execute SQL commands on a database. I’ve included a code snippet below.   The problem I’m having is that when I execute the "SELECT MAX(time_stamp) FROM table32;” command using sqlite3_get_table() I only get one column and 1 row