X-Authentication-Warning: delorie.com: mail set sender to djgpp-bounces using -f
Newsgroups: comp.os.msdos.djgpp
Subject: SQLite problem
From: boohiss <boohiss AT cubesource DOT net>
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Message-ID: <opseci8wqr7iosox@boohiss-927a07e>
User-Agent: Opera M2/7.50 (Win32, build 3778)
Lines: 40
Date: Wed, 15 Sep 2004 02:05:20 GMT
NNTP-Posting-Host: 24.95.40.189
X-Complaints-To: abuse AT rr DOT com
X-Trace: fe2.columbus.rr.com 1095213920 24.95.40.189 (Tue, 14 Sep 2004 22:05:20 EDT)
NNTP-Posting-Date: Tue, 14 Sep 2004 22:05:20 EDT
Organization: Road Runner High Speed Online http://www.rr.com
To: djgpp AT delorie DOT com
DJ-Gateway: from newsgroup comp.os.msdos.djgpp
Reply-To: djgpp AT delorie DOT com

I have come accross a very baffling problem.

My main() function calls a function cust_information(), which in turn,
may call function add_customer():

	int add_customer()
	{
		string strSQL;
   		sqlite *db;
   		char **errmsg;
   		db=sqlite_open(DBFILENAME, 0, NULL);
   		strSQL = "INSERT INTO customer VALUES (";
		strSQL+= "\"" + C.phone + "\", ";
		strSQL+= "\"" + C.name + "\", ";
		strSQL+= "\"" + C.address + "\", ";
		strSQL+= "\"" + C.comment + "\");";
-> 		sqlite_exec(db,strSQL.c_str(),NULL,NULL,errmsg);
   		sqlite_close(db);
		return(0);
	}

Where C is a global object with a couple public functions, and DBFILENAME  
is #DEFINEd.
The problem is in the sqlite_exec line.  I call this function in many  
other places,
doing very similar things, and I get no problems.  I get a seg fault when  
this function
is called.  I've ran gdb on it, and found that it actually seg faults
right after the return(0) line of cust_information().  When commenting out  
the sqlite_exec
line, I get no seg fault, but obviously that's not what I want.  There's  
no error message
 from sqlite_exec, and it appears to actually add the information to the  
database file.

I'm completely baffled.  Does anyone have an idea what might cause this?

Thanks,

Matt