Re: ODBCKit problems with MySQL DB
Re: ODBCKit problems with MySQL DB
- Subject: Re: ODBCKit problems with MySQL DB
- From: Jonathan Monroe <email@hidden>
- Date: Thu, 28 Aug 2008 12:59:44 -0500
On Aug 28, 2008, at 12:19 PM, email@hidden wrote:
I am having a problem with the ODBCKit, and a MySQL database.
I really like the design and usage of the ODBCKit, and it is quite
easy to use.
There is however quite a serious problem that I cannot get around.
When a recordset is returned, I can only see one record. Attempting
to move to another record (moveNext) sets the isEOF property, and
there is no data available.
ODBCRecordset *rs = [odbcConnection open:@"select * from Stuff"];
rs.moveFirst;
while(!rs.isEOF)
{
[popup addItemWithTitle:[[rs fieldByName:@"Name"] asString]];
[rs moveNext];
}
I ran across a bug report of the same issue from last year, and a
response that this has only been tested with the ActualTechnologies
ODBC driver. I have used both the MySQL connect driver, as well as
the Actualtechnologies drivers with the same exact result.
Not all drivers support scrollable cursors, which means that
rs.moveFirst (and moveLast and movePrevious) would not be supported.
Your best best is to assume forward-only cursors, and only use
rs.moveNext.
You do not need to call rs.moveFirst after executing a query - the
cursor is placed at the first row by default.
Jonathan Monroe
Actual Technologies - ODBC for Mac OS X
http://www.actualtechnologies.com
_______________________________________________
Cocoa-dev mailing list (email@hidden)
Please do not post admin requests or moderator comments to the list.
Contact the moderators at cocoa-dev-admins(at)lists.apple.com
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden