I did not get any reply so adding bit more explanation for what I need.
In a C program, I am trying to read data from database. I use
sqlite3_prepare_v2 to execute "Select * from abc", sqlite3_step to get a row,
and sqlite3_col_name,sqlite3_col_val to get column values. I read columns one
by one for each row. Instead I would like to read (x,y,z) { example sake,
assume that x,y,z columns exist} from a row at a time into variables as a
tuple. Can I do that?
Is there a way, I can attach tuple to the database query and get the data as an
array of tuple? Is it possible.
Experts, please throw some light on this.
Thanks
Raji
5/20/09, rajyalakshmi bommaraju <rbommar...@yahoo.com> wrote:
From: rajyalakshmi bommaraju <rbommar...@yahoo.com>
Subject: [sqlite] Question about reading all database data into memory
To: sqlite-users@sqlite.org
Date: Wednesday, May 20, 2009, 9:16 PM
HI,
. If I have to read all the database data into memory, I needed to execute
sqlite3_prepare_v2 statement,and then sqlite3_step to access the rows, and
processing each row to get the rows content. This does not look efficient. Is
there any other way to do this?
Thanks
Raji
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
