get table name from a query

[farnaz]

hi
I have a problem,I want to get table name from sql query in java

I have used : "ResultSetMetaData md = rs.getMetaData();"

but, "md.getTableName(1)" returns an empty string

furthermore,my driver is"com.microsoft.jdbc.sqlserver.SQLServerDriver"

I have used "ResultSetMetaDataOptions=1" in connection string but this

has not worked.

can anyone help me to solve my problem?

 

[bborissov]

Better ask in JAVA forum, not here.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
Microsoft MVP VFP