• SQL Table list

    From Henry Fidler@21:1/5 to All on Mon Jun 28 08:50:50 2021
    I try (CaVo 2.8 SP2)
    oTables := SQLListTables{ , , , , oConn }
    lOK := oTables:Execute() /// return True
    cTables := oTables:TableName

    cTable return empty string.

    What is wrong?
    Henry

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Henry Fidler@21:1/5 to All on Wed Jun 30 08:52:11 2021
    I found a workaround

    oTables := SQLListTables{ ,, , 'Table', oConn }
    lBack := oTables:Execute()

    IF lBack
    oTables:GoTop()
    DO WHILE !oTables:EOF
    cTable := oTables:FIELDGET(3) // 1-"Database name", 2-Null, 3-Table Name, 4-"Table", 5-Null
    AAdd(a_Table, cTable)
    oTables:Skip()
    ENDDO
    ENDIF

    Henry

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)