Ignacio,
I have reported this problem before, but the url to the file wasn't correct.
Could you please test with the following file
http://www.synbiosys.alterra.nl/download/Floranld.zip This file contains a
memo field.
I have imported other dbf files succesfully.
Regards,
Stephan
In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.
Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.
Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.
SQLite Explorer and import problem with dbf-file
-
Stephan Hennekens
- Mensajes: 305
- Registrado: Jue Nov 30, 2006 12:17 am
SQLite Explorer and import problem with dbf-file
Stephan,
> I have reported this problem before, but the url to the file wasn't
> correct. Could you please test with the following file
> http://www.synbiosys.alterra.nl/download/Floranld.zip This file contains a
> memo field.
> I have imported other dbf files succesfully.
Fixed! It will be available in the next release (probably in 2 or 3 days).
Thanks for your feedback.
However, the problem was caused by the fieldname "group", which is a
reserved word in SQL. I suggest to rename it in order to avoid other
problems in the future working with that table. If not, you'll need to use
that fieldname into brackets ([]) everywhere; i.e.: SELECT Layer,[group]
FROM species
--
Regards,
Jose F. Gimenez
http://www.xailer.com
http://www.xailer.info
> I have reported this problem before, but the url to the file wasn't
> correct. Could you please test with the following file
> http://www.synbiosys.alterra.nl/download/Floranld.zip This file contains a
> memo field.
> I have imported other dbf files succesfully.
Fixed! It will be available in the next release (probably in 2 or 3 days).
Thanks for your feedback.
However, the problem was caused by the fieldname "group", which is a
reserved word in SQL. I suggest to rename it in order to avoid other
problems in the future working with that table. If not, you'll need to use
that fieldname into brackets ([]) everywhere; i.e.: SELECT Layer,[group]
FROM species
--
Regards,
Jose F. Gimenez
http://www.xailer.com
http://www.xailer.info
SQLite Explorer and import problem with dbf-file
Stephan,
> I have reported this problem before, but the url to the file wasn't
> correct. Could you please test with the following file
> http://www.synbiosys.alterra.nl/download/Floranld.zip This file contains a
> memo field.
> I have imported other dbf files succesfully.
Fixed! It will be available in the next release (probably in 2 or 3 days).
Thanks for your feedback.
However, the problem was caused by the fieldname "group", which is a
reserved word in SQL. I suggest to rename it in order to avoid other
problems in the future working with that table. If not, you'll need to use
that fieldname into brackets ([]) everywhere; i.e.: SELECT Layer,[group]
FROM species
--
Regards,
Jose F. Gimenez
http://www.xailer.com
http://www.xailer.info
> I have reported this problem before, but the url to the file wasn't
> correct. Could you please test with the following file
> http://www.synbiosys.alterra.nl/download/Floranld.zip This file contains a
> memo field.
> I have imported other dbf files succesfully.
Fixed! It will be available in the next release (probably in 2 or 3 days).
Thanks for your feedback.
However, the problem was caused by the fieldname "group", which is a
reserved word in SQL. I suggest to rename it in order to avoid other
problems in the future working with that table. If not, you'll need to use
that fieldname into brackets ([]) everywhere; i.e.: SELECT Layer,[group]
FROM species
--
Regards,
Jose F. Gimenez
http://www.xailer.com
http://www.xailer.info
-
Stephan Hennekens
- Mensajes: 305
- Registrado: Jue Nov 30, 2006 12:17 am
SQLite Explorer and import problem with dbf-file
You are fast Jose!
You are right. The usage of the name 'group' is not good practice.
Good night.
Stephan
"Jose F. Gimenez" <jfgimenez@wanadoo.es> wrote in message
news:46b8d1b2$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
> Stephan,
>
>> I have reported this problem before, but the url to the file wasn't
>> correct. Could you please test with the following file
>> http://www.synbiosys.alterra.nl/download/Floranld.zip This file contains
>> a memo field.
>> I have imported other dbf files succesfully.
>
> Fixed! It will be available in the next release (probably in 2 or 3 days).
> Thanks for your feedback.
>
> However, the problem was caused by the fieldname "group", which is a
> reserved word in SQL. I suggest to rename it in order to avoid other
> problems in the future working with that table. If not, you'll need to use
> that fieldname into brackets ([]) everywhere; i.e.: SELECT Layer,[group]
> FROM species
>
> --
> Regards,
>
> Jose F. Gimenez
> http://www.xailer.com
> http://www.xailer.info
>
You are right. The usage of the name 'group' is not good practice.
Good night.
Stephan
"Jose F. Gimenez" <jfgimenez@wanadoo.es> wrote in message
news:46b8d1b2$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
> Stephan,
>
>> I have reported this problem before, but the url to the file wasn't
>> correct. Could you please test with the following file
>> http://www.synbiosys.alterra.nl/download/Floranld.zip This file contains
>> a memo field.
>> I have imported other dbf files succesfully.
>
> Fixed! It will be available in the next release (probably in 2 or 3 days).
> Thanks for your feedback.
>
> However, the problem was caused by the fieldname "group", which is a
> reserved word in SQL. I suggest to rename it in order to avoid other
> problems in the future working with that table. If not, you'll need to use
> that fieldname into brackets ([]) everywhere; i.e.: SELECT Layer,[group]
> FROM species
>
> --
> Regards,
>
> Jose F. Gimenez
> http://www.xailer.com
> http://www.xailer.info
>
-
Stephan Hennekens
- Mensajes: 305
- Registrado: Jue Nov 30, 2006 12:17 am
SQLite Explorer and import problem with dbf-file
You are fast Jose!
You are right. The usage of the name 'group' is not good practice.
Good night.
Stephan
"Jose F. Gimenez" <jfgimenez@wanadoo.es> wrote in message
news:46b8d1b2$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
> Stephan,
>
>> I have reported this problem before, but the url to the file wasn't
>> correct. Could you please test with the following file
>> http://www.synbiosys.alterra.nl/download/Floranld.zip This file contains
>> a memo field.
>> I have imported other dbf files succesfully.
>
> Fixed! It will be available in the next release (probably in 2 or 3 days).
> Thanks for your feedback.
>
> However, the problem was caused by the fieldname "group", which is a
> reserved word in SQL. I suggest to rename it in order to avoid other
> problems in the future working with that table. If not, you'll need to use
> that fieldname into brackets ([]) everywhere; i.e.: SELECT Layer,[group]
> FROM species
>
> --
> Regards,
>
> Jose F. Gimenez
> http://www.xailer.com
> http://www.xailer.info
>
You are right. The usage of the name 'group' is not good practice.
Good night.
Stephan
"Jose F. Gimenez" <jfgimenez@wanadoo.es> wrote in message
news:46b8d1b2$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
> Stephan,
>
>> I have reported this problem before, but the url to the file wasn't
>> correct. Could you please test with the following file
>> http://www.synbiosys.alterra.nl/download/Floranld.zip This file contains
>> a memo field.
>> I have imported other dbf files succesfully.
>
> Fixed! It will be available in the next release (probably in 2 or 3 days).
> Thanks for your feedback.
>
> However, the problem was caused by the fieldname "group", which is a
> reserved word in SQL. I suggest to rename it in order to avoid other
> problems in the future working with that table. If not, you'll need to use
> that fieldname into brackets ([]) everywhere; i.e.: SELECT Layer,[group]
> FROM species
>
> --
> Regards,
>
> Jose F. Gimenez
> http://www.xailer.com
> http://www.xailer.info
>