Hi Mick, The doubleclick approach might give you some trouble, but there are several other ways this can be done. You could create a new pushbutton on a new or existing buttonpad (Create/Alter ButtonPad), you could add a new menu item to an existing menu or you could add a menu item to the right click menu for the map window (Alter Menu). You could also add a keyboord short cut to the menu so that the user would have a quich access to this menu.
Whenever the user activates this menu or button, you'll have to check whether there is an active selection of 1 record (use SelectionInfo(SEL_INFO_NROWS)) or several if you would allow this. You also have to make sure that the selection is made in the appropriate table (use SelectionInfo(SEL_INFO_TABLENAME)). After this you have to read the current value from the selected record(s) (use Fetch First From Selection and szCurValue = Selection.MYCOLUMN where MYCOLUMN is the name of the column holding the numbers). Now you are ready to show the read value in a dialog (Use Dialog, Control StaticText and Control EditText and CommandInfo(CMD_INFO_DLG_OK) to check if the user "okay'ed" the dialog). When the user has "okay'ed" the dialog you'll have to update the selection with the new value (use Update Selection Set MYCOLUMN = szNewValue) Note that I use another variable to hold the new value from the dialog, in this way I can check if the value was changed, if it wasn't changed it might not be worth updating the selection. HTH, Peter Horsbøll Møller GIS Developer Geographical Information & IT COWI A/S Rugårdsvej 55 DK-5000 Odense Denmark Tel +45 6313 5013 Direct +45 6313 5008 Mob +45 5156 1045 Fax +45 6313 5090 E-mail [EMAIL PROTECTED] http://www.cowi.dk > -----Original Message----- > From: Mick [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 17, 2003 9:18 PM > To: [EMAIL PROTECTED] > Subject: MI-L Changing data in tables > > > Hi, our MapBasic application creates several tables and > creates points and data linked to the points in the form of a number. > I would like the user to be able to change the number > associated to a point. What is the best way to acheive this? > All of the standard menus are disabled and with the > replacement menus there is no way to call a browser window. > I would like the user to be able to double click the point > that needs changing and perhaps get a dialog box containing > the present number > and an editbox so the user can input the new number. Is > something like this possible? > > Thanks > Mick > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7331