Xailer & OZ Software

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

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,
> 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 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 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
>