He's using Delphi according to his first post. You might wanna use a TClientDataSet if you're not doing so already. It provides a bit more flexibility and won't keep the select query open for longer than is necessary.
Have fun! Walter OlinData: Professional services for MySQL Support * Consulting * Administration http://www.olindata.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org