Re: MI Automatic Column Update

2000-07-05 Thread laurent Frilleux 

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

2000-07-05 Thread Jo Acton 

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]