On 06/19/2012 06:35 AM, Coop, Michael wrote:
> We are trying to determine out how many records are in a FoxPro table,
> preferably, without first performing an execute statement.
>
>
>
> In FoxPro, it would be something similar to using recount() or alen().
> We are using Dabo, Python 2.7 and pyodbc.
>
>
>
> I've tried cursor.rowcount after an execute method and it just returns a
> -1. Any suggestions?
>
>
>
> Current code:
>
> dialog = wx.FileDialog(None, message='Select Table...', \
>
> wildcard='Table/DBF|*.dbf', \
>
> style=wx.OPEN)
>
> dialog.ShowModal()
>
> currdir = dialog.GetDirectory()
>
> cnxn = pyodbc.connect(DRIVER='{Microsoft FoxPro VFP Driver
> (*.dbf)}', \
>
> SourceType='DBF', \
>
> SourceDB=currdir)
>
> dbf = cnxn.cursor()
>
> currdbf =
> dialog.GetFilename().replace('.dbf','').replace('.DBF','')
>
> columninfo = dbf.columns(table='%s' % (currdbf,)).fetchall()
>
> for row in columninfo:
>
> # print column names in a selected table
>
> print row.column_name
>
>
>
>
>
> Mike Coop
> Data Analyst III
>
> Kemper Preferred
> 12926 Gran Bay Parkway West, Jacksonville, FL 32258
> 904.245.5949
> [email protected]
> kemper.com
I don't see a line of Dabo code here? I'd use "dbfpy" - it's worked for me.
Could you need dbf.rowcount?
Normally, if you are using Dabo, the rowcount will be set after a
requery() occurs.
We currently don't have direct support for ODBC nor dbf access. But
it's not to hard to create. Review the code for the other database
engines (i.e. Postgres, MySQL, FireBird, SQLite In dabo\dabo\db for
windows). It's very easy to hard code the connection (see getConnection
method). After getting the connection you can follow the code for the
other methods. Maybe you could convert dbfpy.py to the work with Dabo.
Johnf
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[email protected]
