SQL Table list

54 views
Skip to first unread message

Henry Fidler

unread,
Jun 28, 2021, 11:50:51 AMJun 28
to
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

Henry Fidler

unread,
Jun 30, 2021, 11:52:12 AMJun 30
to
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
Reply all
Reply to author
Forward
0 new messages