You could write your own user defined function similar to show index if you wanted to achieve this natively.
-----Original Message----- From: Daniel Cummings To: 'Victor Pendleton' Cc: [EMAIL PROTECTED] Sent: 7/16/04 2:25 PM Subject: RE: Show Index Into Cursor? Victor, Natively you can't do this? With SqlPassthrough into FoxPro it returns a cursor but I was hoping to store it into a temporary table on the Backend (MySql) because the access code is so much cleaner. Dan -----Original Message----- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Friday, July 16, 2004 11:35 AM To: 'Daniel Cummings '; '[EMAIL PROTECTED] ' Subject: RE: Show Index Into Cursor? You will have to put the value in a resultset and scroll through the resultset. Natively you can do this with MySQL 4.0.x but you could use a programming language. -----Original Message----- From: Daniel Cummings To: [EMAIL PROTECTED] Sent: 7/16/04 1:19 PM Subject: Show Index Into Cursor? Is there a way to force the results of "Show Index From <table>" Into a table? TIA Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]