On 7/22/05, LURKIN Denis <[EMAIL PROTECTED]> wrote:
> I have do many tests. It appears that the results of requests
> each time are received in the same order. This order is that of
> creation of the table. If I have make a CREATE TABLE X (int, char,
> int, char), I receive the results of my reques
Thank you to all, I thus will pay attention in my code and to put the
columns in the order and thus not to use the "select *". It will
be more careful.
Denis Lurkin.
> I have do many tests. It appears that the results of requests
> each time are received in the same order. This order is that of
> creation of the table. If I have make a CREATE TABLE X (int, char,
> int, char), I receive the results of my request SQL in the good order:
> int, char, int, char. How
I have created a small 4 column d-base and if I do a "select * from table"
sqlite always returns to me the order of the data in the order that it was
listed in the create statement. (Actually, I based a lot of functionality in a
small C++ program I wrote on this, and it has never failed. I've
On Jul 22, 2005, at 2:11 AM, LURKIN Denis wrote:
Hello,
I have do many tests. It appears that the results of requests
each time are received in the same order. This order is that of
creation of the table. If I have make a CREATE TABLE X (int, char,
int, char), I receive the results of my reque
Hello,
I have do many tests. It appears that the results of requests
each time are received in the same order. This order is that of
creation of the table. If I have make a CREATE TABLE X (int, char,
int, char), I receive the results of my request SQL in the good order:
int, char, int, char. Howe
> In my application, I call upon the method sqlite3_exec(). This
> method returns the results of request SQL in a function:
> callback(int argc, char **argv, char **azColName).
> This function "callback" displays then the results:
>
> int i;
> for(i=0; i {
> printf("%s = %s\n", azColName[i
Hello,
In my application, I call upon the method sqlite3_exec(). This
method returns the results of request SQL in a function:
callback(int argc, char **argv, char **azColName).
This function "callback" displays then the results:
int i;
for(i=0; iand that the table USER is created with: CREATE T
8 matches
Mail list logo
