We already tried this but no code is displayed in the MapBasic window when the 'create unique index' statement is executed in the MapInfo DBMS SQL Runner.
-----Original Message----- From: Cummings, Mike [mailto:[EMAIL PROTECTED] Sent: 01 September 2004 15:38 To: Julian Balson Subject: RE: MI-L Create unique index for Access tables in workspace? You can edit a workspace with any text editor. So, this may work. Open a mapbasic window and manually run the SQL statement. If there is code in the mapbasic window, open the workspace in the text editor, copy and paste the code from the mapbasic window on the end of the text of the workspace. -----Original Message----- From: Julian Balson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 01, 2004 6:54 AM To: [EMAIL PROTECTED] Subject: MI-L Create unique index for Access tables in workspace? Dear list, We need to create a unique index on Access tables using a statement in the workspace. We currently have to manually run the SQL statement: "create unique index "MI_ID" on tblMILINK(RecordID)" in the MapInfo DBMS SQL runner every time a table (e.g. tblMILINK) is updated in Access, to allow us to open the table live in MapInfo. Is there a way of including a similar instruction in the workspace so that MapInfo carries out this procedure automatically every time the workspace is opened? Julian Balson. This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates Environmental Planners - Landscape Architects - Ecologists 30 Brock Street, BathBA1 2LN Tel: +44 (0) 1225 445548 Fax: +44 (0) 1225 312387 www.npaconsult.co.uk This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates Environmental Planners - Landscape Architects - Ecologists 30 Brock Street, BathBA1 2LN Tel: +44 (0) 1225 445548 Fax: +44 (0) 1225 312387 www.npaconsult.co.uk
