MI-L selecting with variables as column names?

[frank hebbert]

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]