|
Tom,
To me it is unclear if you insert the rows in the new table into the
new table or if you update an existing record in the old table with values from
the new table.
But I would think that you are updating an existing record. And the link
between the old and the new is the telephone number.
If this is so, you don't have to manually deal with one record at a time.
You can make a small MapBasic application that will run thru the records in the
new table and update the old table with the changes simply by comparing the
telephone number.
This can be achieved by using the Add Column statement for each column
that needs to be updated. This link is the telephone number. You could actually
do a Update Column in MapInfo Pro with the MapBAsic window open. This will give
you the syntax to use.
Peter Horsbøll Møller
GIS Developer, MTM Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis "For enden af
regnbuen..." - hvordan kommer man dertil og er
det overhovedet muligt? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Halbrook Sent: Tuesday, August 29, 2006 3:01 PM To: [email protected] Subject: [MI-L] Copy - Paste in MapBasic I am still learning Map Basic and
trying to write a program to copy a record in a row in one table and paste it
into a row in another table. Heres my scenario. Each week I
update changes in a telephone customer database. I get a file from my Example: On a number change I
presently select the telephone in the new table, hit ctrl C, and then select the
telephone number field in the old table and hit ctrl
V. (A lot of repetitive key strokes)
The procedure I am striving for
would be; 1. Select the record in the first table, click on a pushbutton (to
copy the selection) Then 2. Select the record in the second table, click on
another pushbutton (to paste the copied record into the second
table) I can build the program to create
the button pads etc. But I cant seem to find any MapBasic command that is
equivalent to Copy & Paste Can anyone give me the Map Basic
Commands or Statements that would be equivalent to Copy and Paste action in
MapInfo? Thanks, |
_______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
