thanks to marcel, yann, ben and jason for answering this. the answer was that i had declared all vars as strings, when of course column vars should be dim-d as alias.
original question follows, with corrected code at the end cheers frank > i'm stumped. why does this work : > > select * from world, water where water.obj intersects earth.obj > > and this : > > dim tableOne, tableTwo as String > tableOne = "water" > tableTwo = "earth" > select * from tableOne, tableTwo where water.obj intersects earth.obj > > but not this : > > dim tableOne, tableTwo, objOne, objTwo as String > tableOne = "water" > tableTwo = "earth" > objOne = tableOne + ".obj" > objTwo = tableTwo + ".obj" > select * from tableOne, tableTwo where objOne intersects objTwo > > ??? this works : dim tableOne, tableTwo as String dim objOne, objTwo as Alias tableOne = "water" tableTwo = "earth" objOne = tableOne + ".obj" objTwo = tableTwo + ".obj" select * from tableOne, tableTwo where objOne intersects objTwo --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
