But this would work: 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
!!! -----Oorspronkelijk bericht----- Van: frank hebbert [mailto:[EMAIL PROTECTED]] Verzonden: vrijdag 14 juni 2002 16:16 Aan: mapinfo-l Onderwerp: MI-L selecting with variables as column names? 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 ??? --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
