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

Reply via email to