Hello Terry, Your variable lcCommand is a string and this is a type mismatch with the obj from your table. I suspect your thought lcCommand would be a symbol which, even then, would be incompatible. The symbol is just one part of an obj which you can modify with "alter object...".
One more tip... Whenever you do a select, it's a good idea to specify the table name you want it to go into rather than just use "selection". It's easy then to close the table you use when your finished, otherwise you have to keep on top of the accumulation of "QueryX" tables. E.g. select * from MyTable where MyID = 123 into TO_UPD update TO_UPD set OtherField = 456 close table TO_UPD Regards, Warren Vick Europa Technologies Ltd. http://www.europa-tech.com -----Original Message----- From: Terry McDonnell [mailto:[EMAIL PROTECTED] Sent: 27 June 2005 17:39 To: [email protected] Subject: MI-L Can't eveluate ... column Obj Dear List Pease consider the code below and can anyone tell me why I get the error message: "Can't evaluate expression for column Obj. Operation cancelled"... on the Update Selection line. In the dialogue I'm using the Symbol Picker to select a font symbol, and selcting one of my Facility types from an array. Then I'm trying to change the symbol to that selected, for all Facilities on the map who are of that type. e.g. all churches could be displayed as a spire, factories as a factory pic, museums with the "M" building, et al. Note thefre are 2 arrays side-by-side: one holding the desc and the other the code. 'ppfreciate it Terry McDonnell Sub FAC_SYMBOLS_DIALOG '_____________________ Dim lsSymbol as Symbol, lcSymbolStyle, lcCommand as String, lnSelID as SmallInt, loObj as Object DIALOG Title "Select Symbols for Facility Type" Control StaticText Position 10,10 Title "Select:" Control SymbolPicker Position 60,10 Into lsSymbol Control StaticText Position 10,40 Title "Facilty Types:" Control PopUpMenu Position 60,40 Title from Variable gaFacTypes Into lnSelID Control OKButton Control CancelButton If CommandInfo( CMD_INFO_DLG_OK) Then lcSymbolStyle = STR$( lsSymbol) lcCommand = "MakeFontSymbol( " + lcSymbolStyle + ")" Select * from FacMast where FacMast.Fac_Code = gaFacCodes( lnSelID) Update Selection set Obj = lcCommand End If End Sub --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 16961
