Sql

Search

ring execute query then print the query result.

See "ODBC test 4" + nl
pODBC = odbc_init()
See "Connect to database" + nl
see odbc_connect(pODBC,"DBQ=test.mdb;Driver={Microsoft Access Driver (*.mdb)}") + nl
See "Select data" + nl
see odbc_execute(pODBC,"select * from person") + nl
nMax = odbc_colcount(pODBC)
See "Columns Count : " + nMax + nl
while odbc_fetch(pODBC)
        See "Row data:" + nl
        for x = 1 to nMax
                see odbc_getdata(pODBC,x) + " - "
        next
end
See "Close database..." + nl
odbc_disconnect(pODBC)
odbc_close(pODBC)

Comment

PREVIOUS	NEXT

Code Example
Sql :: sql delete where x or y or z
Sql :: SQL Using Comments to Debug Code
Sql :: t-sql cheat sheet
Sql :: mysql coonect sample code
Sql :: mysql select all and rename one
Sql :: sqlite referential integrity
Sql :: show blank in column if condition not matches in join mysql
Sql :: sql countif
Sql :: SQL BETWEEN OPERATOR With Texts
Sql :: cursors in db2
Sql :: homebrew nysql launch
Sql :: SQL Primary Key single column
Sql :: sql server udf performance
Sql :: how to get recent added primary key in sql
Sql :: get who is hired in specific month in sql
Sql :: sql agent jb is enabled query
Sql :: horizontal join sqlite
Sql :: ring PostgreSQL
Sql :: create user oracle hash by value
Sql :: IS THEre any difference between using default and := in plsql
Sql :: setval postgres example table id
Sql :: synapse sql table set pk
Sql :: database create table date of birth data type
Sql :: date query
Sql :: ALV GRID events
Sql :: sql implicit cursor
Sql :: min varias colunas spark sql
Sql :: mysql c commands
Sql :: distinct data types in a table sql query
Sql :: To Create directory

Search

SQL

ring execute query then print the query result.

ADD CONTENT