Re: Re: [sqlite] How do I efficiently copy tables to another db within dll (sqlite3+)

> Thanks much - one more question though... > > I'm attempting to copy data from an in memory database to > another db (file or otherwise). Is it possible to attach an > existing in-memory database to another existing db connection? > (attach database :MEMORY: would just seem to create another

Re: Re: [sqlite] How do I efficiently copy tables to another db within dll (sqlite3+)

Thanks much - one more question though... I'm attempting to copy data from an in memory database to another db (file or otherwise). Is it possible to attach an existing in-memory database to another existing db connection? (attach database :MEMORY: would just seem to create another in mem db).

Re: Re: [sqlite] How do I efficiently copy tables to another db within dll (sqlite3+)

-- de f <[EMAIL PROTECTED]> wrote: > Thanks Jay. > > Great! This could work... > > I'm wondering, though if you know whether the limitation below > (from sqlite documentation) could be safely circumvented if > attaching the source db with an alias name. It seems to work > when i try it but

Re: Re: [sqlite] How do I efficiently copy tables to another db within dll (sqlite3+)

Thanks Jay. Great! This could work... I'm wondering, though if you know whether the limitation below (from sqlite documentation) could be safely circumvented if attaching the source db with an alias name. It seems to work when i try it but I'm concerned that there might be other unknown

Re: [sqlite] How do I efficiently copy tables to another db within dll (sqlite3+)

Did you try attach and an insert? --- de f <[EMAIL PROTECTED]> wrote: > I'd like some guidance on the most efficient way to copy a large > table from one slqite db to another. I'm using from within vb > with a vc++ sqlite wrapper. > > I know that the copy command is no longer available in

[sqlite] How do I efficiently copy tables to another db within dll (sqlite3+)

I'd like some guidance on the most efficient way to copy a large table from one slqite db to another. I'm using from within vb with a vc++ sqlite wrapper. I know that the copy command is no longer available in ver3+ and am unsure of how to proceed. do i need to somehow hook into the