[sqlite] With Rollup

Is there any intention of implementing the "With Rollup". Or are there any extensions which might be helpful in implementing. Get your own "800" number Voicemail, fax, email, and a lot more http://www.ureach.com/reg/tag

[sqlite] Can I refer to a column alias in same SQL Select statement?

Is there any way to do the following without using subqueries or repeating the formulas? select city, count(id) as TotalNum, sum(Weight) as TotalWeight, TotalNum/TotalWeight as AvgWeight... Get your own "800" number Voicemail, fax, email, and a

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

fax, email, and a lot more http://www.ureach.com/reg/tag On Wed, 6 Apr 2005, Jay ([EMAIL PROTECTED]) wrote: > > -- de f <[EMAIL PROTECTED]> wrote: > > Thanks Jay. > > > > Great! This could work... > > > > I'm wondering, though if you know whether

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

ttp://www.ureach.com/reg/tag On Tue, 5 Apr 2005, Jay ([EMAIL PROTECTED]) wrote: > > 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 t

[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