MI Automatic Column Update
Does anyone know of a way to automatically update a column in MapInfo? What I am doing is connecting to an Access database via the power of ODBC. I want to combine the values of three fields to make a unique ID. e.g. 1 N50 SE would become 1N50SE etc. I tried doing it in Access, and it did not like it at all. Any Ideas? Grant Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
Re: MI Automatic Column Update
Grant, Add a new column in your table (caracter type) and update this column: new column=col1+col2+col3+... Laurent Frilleux STRATEGIS SA Zolad Mini Parc, Bat 2 912 rue de la Croix Verte 34198 MONTPELLIER Cedex 5 04-67-41-68-41 - Message d'origine - De : "Grant Dickson" [EMAIL PROTECTED] À : [EMAIL PROTECTED] Envoyé : mercredi 5 juillet 2000 12:05 Objet : MI Automatic Column Update Does anyone know of a way to automatically update a column in MapInfo? What I am doing is connecting to an Access database via the power of ODBC. I want to combine the values of three fields to make a unique ID. e.g. 1 N50 SE would become 1N50SE etc. I tried doing it in Access, and it did not like it at all. Any Ideas? Grant Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI Automatic Column Update
Use Table Update Column Fill out the relevant details in the dialogue box (the column to update will obviously be the one you want the data stored in you may need to create this column through table maintenance) Then click on the Assist button. Use the following: Column1 + Column2 + Column3 Don't forget to save the table. Hope this works, Jo From: Grant Dickson [EMAIL PROTECTED] on 07/05/2000 12:05 PM CET Recipients: [EMAIL PROTECTED] Subject:MI Automatic Column Update Does anyone know of a way to automatically update a column in MapInfo? What I am doing is connecting to an Access database via the power of ODBC. I want to combine the values of three fields to make a unique ID. e.g. 1 N50 SE would become 1N50SE etc. I tried doing it in Access, and it did not like it at all. Any Ideas? Grant -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]