Re: [sqlite] Index creation in a memory database

2010-01-21 Thread David Alcelay 
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 final parentesis and the column are there. The error text 
the library was returning was:near ".": syntax error
The final solution was to erase the last 'memoria.' but it's extrange because 
the table is in that attached database (really it's a memory attached 
database), so it was confusing for me
Hope now it's clear.
Regards,
   David
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Index creation in a memory database

2010-01-21 Thread David Alcelay 
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
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Index creation in a memory database

2010-01-21 Thread 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
Any idea?
Thanks in advance,
   David
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Index creation in a memory database

2010-01-18 Thread David Alcelay 
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 extrange error, I think that a bug.
Steps:
1) attatch to a 'memory' database: attach database ':memory:' as memoria(OK)
2) create the tables: (I write only the one I have problems)
   create table memoria.Dispositivos (Indice PRIMARY KEY, Tipo_Dispositivo 
INTEGER, Numero_Dispositivo INTEGER, Habilitado INTEGER, Activado INTEGER, 
Estado INTEGER, Codigo_Error INTEGER, Parametro_01_PLC INTEGER, 
Parametro_01_WCS INTEGER, Parametro_02_PLC INTEGER, Parametro_02_WCS INTEGER, 
Parametro_03_PLC INTEGER, Parametro_03_WCS INTEGER, Parametro_04_PLC INTEGER, 
Parametro_04_WCS INTEGER, Parametro_05_PLC INTEGER, Parametro_05_WCS INTEGER, 
Parametro_06_PLC INTEGER, Parametro_06_WCS INTEGER, Parametro_07_PLC INTEGER, 
Parametro_07_WCS INTEGER, Parametro_08_PLC INTEGER, Parametro_08_WCS INTEGER, 
Parametro_09_PLC INTEGER, Parametro_09_WCS INTEGER, Parametro_10_PLC INTEGER, 
Parametro_10_WCS INTEGER, Parametro_01_STRING_WCS TEXT, Parametro_02_STRING_WCS 
TEXT, Parametro_03_STRING_WCS TEXT, Parametro_04_STRING_WCS TEXT, 
Parametro_05_STRING_WCS TEXT, Parametro_06_STRING_WCS TEXT, 
Parametro_07_STRING_WCS TEXT, Parametro_08_STRING_WCS TEXT, 
Parametro_09_STRING_WCS TEXT, Parametro_10_STRING_WCS TEXT)
 
(the creation is OK)
 
3) create an index over this table:
 create index memoria.Dispositivos_TipoDispositivo on memoria.Dispositivos 
(Tipo_Dispositivo)
 
I get this error: near ".": syntax error
 
 
But, if I remove the step 1 (prepare the memory database, and erase the 
'memoria.' in the next creation sentences, the creation of the index is OK, so 
I think is some kind of error in the sintax parsing or something like that.
 
Hope this is helpfull.
Regards,
   David Alcelay
 
 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users