Re: [sqlite] unique id for table

Yes thanks for the advice...I've already combined the "raw" data i.e. vectors straight out of the annual reports and the calculated vectors e.g.. "noplat" derived from it which I've given a type "calcd" in the type field of the same table "itms". There is some market wide data however, which might

Re: [sqlite] unique id for table

On 23 Jun 2013, at 12:26pm, e-mail mgbg25171 wrote: > The "table as a number" idea is necessary to fit my model > where word definitions are stored as streams of code pointers (NUMBERS) > that just get called. > i.e. EVERYTHING has to be a number That makes perfect

Re: [sqlite] unique id for table

I'm writing a variation of forth (It's got an IDE and 3-level stepping debugger already) that's actually a company valuation programming language (Can't get on with spreadsheets hiding everything) It accomodates words that are financial report line items (vectors) and their manipulation and I'm

Re: [sqlite] unique id for table

There is of course no straight-forward way to do this, as I've noted Simon said already. But my curiosity is very piqued - Mind sharing what kind of application requires number-only calling? You using this on a calculator of sorts? - If so (or otherwise), some details would be interesting to

Re: [sqlite] unique id for table

Thanks very much Simon Looks like plan B then. On 22 June 2013 19:40, Simon Slavin wrote: > > On 22 Jun 2013, at 7:27pm, e-mail mgbg25171 > wrote: > > > I need to access a row just using numbers. > > The row id's fine but can I specify the

Re: [sqlite] unique id for table

On 22 Jun 2013, at 7:27pm, e-mail mgbg25171 wrote: > I need to access a row just using numbers. > The row id's fine but can I specify the table using a numeric id too? This command can be used to get tables numbered: SELECT rowid,name FROM sqlite_master WHERE