rajyalakshmi bommaraju 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.
This should not be the case. What happens if you look at the file with the CLI after creating the table with CLI, and recreating it with C? What does the command select SQL from sqlite_master; show? Issuing that command in the C program before recreating the table could be informative, too. You could be looking at different files, or the table names may be subtly different (such as one of them including a space or linefeed or unprintable character. HTH, Gerry _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
