[sqlite] sqlite connection?

2010-05-11 Thread john cummings
hi all, i'm new to this forum and sqlite. is it possible to have an executable (i.e. .exe) with connections to 2 sqlite databases? i've read doc and it doesn't speak to this one way or the other. thanks, john ___ sqlite-users mailing list

Re: [sqlite] sqlite connection?

2010-05-11 Thread P Kishor
On Tue, May 11, 2010 at 12:45 PM, john cummings jndbusin...@gmail.com wrote: hi all, i'm new to this forum and sqlite. is it possible to have an executable (i.e. .exe) with connections to 2 sqlite databases? I've never made an executable, but given that I can do so with Perl, I don't see

Re: [sqlite] sqlite connection?

2010-05-11 Thread Adam DeVita
Yes. One can also attach 'somedatabase path' as anothername ; and you can run a query accessing both at the same time. regards, Adam On Tue, May 11, 2010 at 1:45 PM, john cummings jndbusin...@gmail.comwrote: hi all, i'm new to this forum and sqlite. is it possible to have an executable

Re: [sqlite] sqlite connection?

2010-05-11 Thread Simon Slavin
On 11 May 2010, at 6:45pm, john cummings wrote: is it possible to have an executable (i.e. .exe) with connections to 2 sqlite databases? i've read doc and it doesn't speak to this one way or the other. Sure. Use sqlite_open() two times, and keep the returned values in two separate

Re: [sqlite] sqlite connection?

2010-05-11 Thread Jay A. Kreibich
On Tue, May 11, 2010 at 01:45:03PM -0400, john cummings scratched on the wall: hi all, i'm new to this forum and sqlite. is it possible to have an executable (i.e. .exe) with connections to 2 sqlite databases? i've read doc and it doesn't speak to this one way or the other. Yes.