Re: [sqlite] Index creation in a memory database

Hi! Uppsss, sorry about it, I wrote it incomplete, because we were talking about another part of the sentence. The next one is the original sentence I asked here what was wrong:create index memoria.Dispositivos_TipoDispositivo on memoria.Dispositivos (Tipo_Dispositivo) So you see that the

Re: [sqlite] Index creation in a memory database

Regarding: Maybe the question for this issue is why it's not ok this syntax: create index memoria.Dispositivos_TipoDispositivo on memoria.Dispositivos >From my reading of the CREATE INDEX syntax at: http://www.sqlite.org/lang_createindex.html the parentheses are required, not

Re: [sqlite] Index creation in a memory database

Hi Simon! That was the solution. I thought I have tested all the combinations but I was wrong. Maybe the question for this issue is why it's not ok this syntax: create index memoria.Dispositivos_TipoDispositivo on memoria.Dispositivos Thank you, David

Re: [sqlite] Index creation in a memory database

2010/1/21 David Alcelay : > Hi Igor! > Thanks for your reply. > I tested my self that solution before sending the question, but didn't work. > I have tested again now (may be I did not ok before), but the same result:     > near ".": syntax error Did you try create

[sqlite] Index creation in a memory database

Hi Igor! Thanks for your reply. I tested my self that solution before sending the question, but didn't work. I have tested again now (may be I did not ok before), but the same result: near ".": syntax error Any idea? Thanks in advance, David ___

Re: [sqlite] Index creation in a memory database

David Alcelay wrote: > 3) create an index over this table: > create index memoria.Dispositivos_TipoDispositivo on memoria.Dispositivos > (Tipo_Dispositivo) > > I get this error: near ".": syntax error You don't specify database name in trigger name; the appropriate database is inferred

[sqlite] Index creation in a memory database

Hi! I started having problems when I started using sqlite in 'memory' mode, this is, workin only in memory. It was not a problem to configure this working mode, it's really easy, but somethings goes wrong. So, working in no memory mode works ok, but if I go to memory mode, doesn't work with a