can't say for sure, but it's likely that the GPF is caused by trying to evaluate an array of "virtual" values (the rowid) against "tangible" values (the field from the second table).
i know RowID is useful for a lot of stuff, but i don't recall ever using it for evaluating more than one thing at a time, eg select * where something = CurrentRowID, or whatever. why are you trying to update a column based on volitile values? -----Original Message----- From: Simmonds, Ashley (PTB) Sent: Tuesday, 11 November 2003 2:34 PM To: [EMAIL PROTECTED] Subject: RE: MI-L MBX - Add Column statement - MI crashes in a heap! mine crashed too, didn't even get a GPF. will play a little more... -----Original Message----- From: Peter Zyczynski [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 November 2003 2:22 PM To: [EMAIL PROTECTED] Subject: MI-L MBX - Add Column statement - MI crashes in a heap! Help! Trying to update "DestinationField" in "Table_A" with values from "SourceField" in "Table_B", Mapinfo spits out the following error and shuts down: "The instruction at "0x00515248" referenced memory at "0x00080101". The memory could not be "read". Click OK to terminate, CANCEL to debug." To keep things simple I whipped up this little sample: '----------------------------------- sub main Add Column Table_A (DestinationField) From Table_B Set To (SourceField) Where RowID = MyID end sub '----------------------------------- I tried doing the above statement from within Mapinfo in the Mapbasic window but the effect is the same - CRASHOLA! I have a suspicion that its because I'm joining on RowID, ie: Table_A.RowID = Table_B.MyID So, is it me, is it Mapinfo, or is it both of us? Cheers, Peter Zyczynski Analyst Programmer Insight GIS Australia Ph: (03) 6234-5833 Fax: (03) 6234-5899 [EMAIL PROTECTED] www.insightgis.com.au --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9099 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9101
