Sql

Search

ring get a list of tables inside the database using the odbc_tables()

odbc_tables(ODBC Handle)

Comment

ring get a list of tables inside the database using the odbc_tables()

See "ODBC test - Get Database Tables" + nl
pODBC = odbc_init()
See "Connect to database" + nl
odbc_connect(pODBC,"DBQ=test.mdb;Driver={Microsoft Access Driver (*.mdb)}") + nl
See "Select data" + nl
odbc_tables(pODBC) + nl
nMax = odbc_colcount(pODBC)
See "Columns Count : " + nMax + nl
while odbc_fetch(pODBC)
        for x = 1 to nMax
                see odbc_getdata(pODBC,x)
                if x != nMax see " - " ok
        next
        See nl
end
See "Close database..."
odbc_disconnect(pODBC)
odbc_close(pODBC)

Comment

PREVIOUS	NEXT

Code Example
Sql :: Alter precision
Sql :: id INT NOT NULL AUTO_INCREMENT
Sql :: oracle test if 0
Sql :: how do you execute the fragment or sqlBatch using scriptdom
Sql :: cast as double sql
Sql :: get all databases and their tables without primary key mysql
Sql :: mysql query to add hours to column in table
Sql :: compute age mysql
Sql :: mysql equivalent decode oracle
Sql :: mariadb select limit offset
Sql :: change authentication plugin from auth_sock to mysql_native_password for a specific user
Sql :: opensuse status MySQL
Sql :: sql how to get courses that i have made prerequisites
Sql :: watch mysql command line
Sql :: online t-sql editor
Sql :: import sheets doc into databricks
Sql :: how to set all the min and sec data to zero in sql server
Sql :: FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
Sql :: what is database username and password in mysqliconnect
Sql :: How To Execute SQL Select Statements
Sql :: how to tell if i have lactose intolerance
Sql :: add mysql database to power bi web
Sql :: What is performance wise better join or a subquery ?
Sql :: dasebase_url-postgres for windows
Sql :: mysql sum per week
Sql :: store case result sql
Sql :: sqlite date to char
Sql :: mysql faster delete
Sql :: sql developer format sql
Sql :: id desde sql

Search

SQL

ring get a list of tables inside the database using the odbc_tables()

ring get a list of tables inside the database using the odbc_tables()

ADD CONTENT