[DataVision-users] JDBC ResultSetMetaData help

[Jim M. <ji...@io...>]

I'm working on allowing arbitrary SQL. In order to do that, I have to 
be able to find out the name of each column in the result set. The 
problem is, (at least for my driver) the ResultSetMetaData is returning 
empty schema and table names. (The column name is correct.) Therefore I 
have no way of knowing what DataVision Column object the returned data 
belongs to.

For example, if I use the example report and drag the "visible" column 
from both the jobs and office tables into the report, the two returned 
columns look exactly the same to the ResultSetMetaData (aside from 
their order in the SQL statement, which I will not know when the 
arbitrary SQL is run).

Any suggestions?

Jim
--
Jim Menard, ji...@io..., http://www.io.com/~jimm/
"You guys have made me the happiest giant talking worm in the world."
     -- Earthworm Jim