Shashib Jerry's reply is correct, but (just in case) dont forget you need to issue an update command to force mapinfo to accept the changed object
so as per jerry's code>>>>>>> Fetch First from MyTable MyObj = MyTable.obj Alter Object MyObj Info OBJ_INFO_SYMBOL, symbol_style <<< now issue something like>>>>> update MyTable set obj = MyObj where rowid = 1 'this is the first record in the table and then process the next object in the table etc, if doing a big table this can be slow and tedious . I have not had chance to look at changing styles via a update command that uses a 'function', other listers may be able to help with this, but i am guessing that a slow for next loop is the only way. There are several tools on the directionsmag that cover style setting, I have uploaded an old one of mine with source code included so you can see how its works at its clunkiest.... ;-) (its called qik_colourbycolumn.zip) regards r -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 30 November 2004 12:09 To: [EMAIL PROTECTED] Subject: MI-L How to change objects style permanently Hello list, How to change the objects colour/style based on database permanently (not as thematic layer) through mapbasic commands? thanks in advance Shashibhushan ********************************************************************* This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. However, the information contained in this e-mail may subsequently be subject to public disclosure under the Freedom of Information Act 2000 and, unless the information is legally exempt from disclosure, the confidentiality of this e-mail and your reply cannot be guaranteed. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. http://www.bgs.ac.uk ********************************************************************* --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 14286