Matt, I have run across this with the JDBC plugin talking to an Oracle DB. I found that if only one record was returned, this logic bombed in the exact same manner, the workaround was to set the curRecord pointer to the last and read backwards if the record count ==1. Otherwise you just read records as you have coded. You should verify that the rs begins at the "0" record. Your while condition should be the return value of [rs moveNext].
Martin, The problem is that many records should be returned by this query, however I can only read the first one. The column count is correct, as is the data, however only one row is returned. The data is in the Db, and queries using other s/w work fine, just not the ODBCKit. Thanks, Matt ________________________________________________________________ Sent via the WebMail system at youney.com _______________________________________________ Cocoa-dev mailing list (Cocoa-dev@lists.apple.com) 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: http://lists.apple.com/mailman/options/cocoa-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]