主题：ORACLE 表的读取

执行sql语句也不行，比如

 

select * from "HZZSK"."RS_SUB_XL"

 

select * from HZZSK.RS_SUB_XL

 

http://www.foxtable.com/webhelp/scr/1484.htm

 

 你说直接调用怎么调用的？如果你没有加入表，怎么可以直接调用？

报什么错？请截图说明

 

Dim lst As List(Of String)
lst = Connections("orcl").GetTableNames
For Each nm As String In lst
    nm = nm.Replace("""","")
    Dim q As new QueryBuilder
    q.TableName = "临时表"
    q.SelectString = "select * From " & nm & " where 1=2"
    q.ConnectionName = "orcl"
    q.Build
    For Each dc As DataCol In DataTables("临时表").DataCols
        Dim dr As DataRow = DataTables("ORCLTABLE").AddNew
        dr("TABLE") = nm
        dr("COLName") = dc.name
    Next
Next

 where 1=2 的意思是，不加载数据。

 

http://www.foxtable.com/webhelp/scr/1823.htm