strongriley / python-dbase Goto Github PK

Hello,

Your library is awesome thank you for sharing it.

I'm trying to read some data from a table

db.query('select * where category like \"WATER\"')

and I receive this error:

Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "C:\Python27\lib\site-packages\dbf\__init__.py", line 5962, in query
return pql(self, criteria)
File "C:\Python27\lib\site-packages\dbf\__init__.py", line 8183, in pql
condition = pql_criteria(records, condition)
File "C:\Python27\lib\site-packages\dbf\__init__.py", line 8128, in pql_criteria
execute(function, g)
File "<string>", line 5, in execute
File "<string>", line 8
if categoria like "WATER":
^
`SyntaxError: invalid syntax``

Hello,

I did, what you said on the documentation but i get the error ._

dbf not in read/write mode, unable to append records

I know the problem is that the document is readonly

dbf.Table(':test:.dbf', status <DbfStatus.READ_ONLY: 1>)

¿how I can change that?