Thank you Igor. That explanation makes sense. And it fits all the information I had collected.
R, John > -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] > On Behalf Of Igor Tandetnik > Sent: Monday, December 20, 2010 12:10 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Troubleshooting... > > On 12/17/2010 6:18 PM, john darnell wrote: > > Here's that statement from my code again with the mods included that make > > the > code work: > > > > char *surbuf[100]; > > memset(surbuf, 0, 100); > > strcpy(surbuf, CurrentName -> second.GetSurName().c_str()); > > idx = -1; > > idx = sqlite3_bind_parameter_index(ResultStmt, ":sur"); > > sqlite3_bind_text(ResultStmt, idx, surbuf, strlen(surbuf), > > SQLITE_STATIC); > > This works because the string no longer disappears from under the > statement, the way it did before. > -- > Igor Tandetnik > > _______________________________________________ > 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