Re: Delete columns... How?

Hi Mke, Don't recall if this is an SQLite database in question but if so, there are various PRAGMA statements that control caching, page size etc. Check out www.sqlite.org for more info. Pete lcSQL Software Home of lcStackBrowser a

Re: Delete columns... How?

On Tue, Sep 30, 2014 at 11:12 AM, Michael Doub wrote: > I think that puts the whole database (multiple tables) in memory. Bob > mentioned only the table so I thought he might know of some other magic > incantation. :-) > Open another database :) So you open database gizmo on the disk, and ga

Re: Delete columns... How?

I think that puts the whole database (multiple tables) in memory. Bob mentioned only the table so I thought he might know of some other magic incantation. :-) -= Mike On Sep 30, 2014, at 12:05 PM, Dr. Hawkins wrote: > On Mon, Sep 29, 2014 at 3:58 PM, Michael Doub wrote: > >> Bob, how do

Re: Delete columns... How?

On Mon, Sep 29, 2014 at 3:58 PM, Michael Doub wrote: > Bob, how do you control whether SQLite pages the table in from disk or > maintains it entirely in memory? > use :memory: as the file name. Blindingly fast. -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 _

Re: Delete columns... How?

Bob, how do you control whether SQLite pages the table in from disk or maintains it entirely in memory? -= Mike On Sep 29, 2014, at 12:14 PM, Bob Sneidar wrote: > Might just be simpler to put the data into a memory based sqLite table, then > delete the column and put the data back into a str

Re: Delete columns... How?

Might just be simpler to put the data into a memory based sqLite table, then delete the column and put the data back into a string list. But of course that begs the question, why are you not using arrays and sql tables in the first place? I’ve pointed out before that the array retuned in Trevor

Re: Delete columns... How?

Not had a chance to confirm your findings below, Alex, but if so then your assessment is most likely correct. Well found, that man! When (if) I get some time, I'm thinking a generic method would be useful to delete arbitrary columns from a data set. Meanwhile, I have submitted an enhancement req

Re: Delete columns... How?

Because (I imagine) "combine ... column" requires that the keys be consecutive numbers. This does work (deleting column 2, just for testing, and omitting the safety check that there are at least 3 columns :-) on mouseUp set the columndelimiter to comma get fld 1 put it into tVar

Re: Delete columns... How?

On this the column to delete would need to be joined at the end. John Balgenorth On Aug 29, 2014, at 9:02 AM, JB wrote: > I am sure someone else > can do it better but this works. > > on mouseUp > put fld id 1056 into pData > set the itemdel to tab > split pData by column > put pData

Re: Delete columns... How?

I knew someone had a better way. thank you. John Balgenorth On Aug 29, 2014, at 9:06 AM, Peter Haworth wrote: > Sometimes I dream of: > > delete column 3 of line 1 to -1 of tVar > > Pete > lcSQL Software > Home of lcStackBrowser

Re: Delete columns... How?

Sometimes I dream of: delete column 3 of line 1 to -1 of tVar Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin On Fri, Aug 29, 2014 at 2:33 AM, FlexibleLearning.com < ad...@flexib

Re: Delete columns... How?

I am sure someone else can do it better but this works. on mouseUp put fld id 1056 into pData set the itemdel to tab split pData by column put pData[4] into tType put pData[3] into tSize put "size = empty" into tSize put pData[2] into tModDate put empty into tModD

Re: Delete columns... How?

My eyes are not working. I now see you said it fails. John Balgenorth On Aug 29, 2014, at 2:33 AM, FlexibleLearning.com wrote: > Related problem to 'join columns': How to delete a column of data? > > This fails... > > on mouseUp > get fld 1 > split it by column > delete local it[2] > c

Re: Delete columns... How?

Thank you! That is something I needed very much today. John Balgenorth On Aug 29, 2014, at 2:33 AM, FlexibleLearning.com wrote: > Related problem to 'join columns': How to delete a column of data? > > This fails... > > on mouseUp > get fld 1 > split it by column > delete local it[2] >

Delete columns... How?

Related problem to 'join columns': How to delete a column of data? This fails... on mouseUp get fld 1 split it by column delete local it[2] combine it by column put it into fld 2 end mouseUp It seems that 'combine by column' requires the same number of array keys as the original data s