On Wed, 6 May 2009 14:13:46 -0700 (PDT), rajyalakshmi bommaraju <[email protected]> wrote:
>Hi, > I started using sqlite3 recently on Ubuntu. I came > across an issue with the database that, I was able to > create database and table from commandline > successfully, I also inserted couple of rows, no > problem. When I tried to open database from C program, > It is fine but I cant access the table. It says that > the table doesnt exist ,I get error when I try to query > from the table. I had to recreate the table from the C > Program then I can insert or read from the table. It > looks like the tables are not global and are hidden > from one program to other. > > Please throw some light on this one. What can I do to > make them accessible from every interested program on > the machine. Did you use the /path/databasefilename parameter on the sqlite command line? As in: # sqlite3 my.db See also: http://www.sqlite.org/quickstart.html If you leave out the databasefilename, sqlite uses an in-memory database, which is destroyed as soon as you leave/quit/exit the command line tool program. >Thanks >rb -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
