Copyright (1999-2008) EDMGROUP Pty Ltd - EZY Prolog Reference

List of predicates for group ODBC

[This is preliminary specification and subject to change.]

List of all groups


Type

Predicate

Parameters

Flow pattern

Description

determ

ezy_odbc_close

Close ODBC engine

determ

ezy_odbc_connect

STRING DSN,
STRING USER,
STRING PASSWORD,
ODBC_CONNECTION

(i,i,i,o)

Connect to ODBC source

determ

ezy_odbc_disconnect

ODBC_CONNECTION ,
SLIST DB_ERRORS

(i,o)

Disconnect from opened ODBC source

determ

ezy_odbc_init

Intialize ODBC interface

determ

ezy_odbc_recordset

ODBC_CONNECTION DB_CONNECTION,
STRING TABLE,
SLIST FIELDS,
STRING CRITERIA,
RECORDSET R

(i,i,i,i,o)

Create recordset by executing SQL statement

determ

ezy_odbc_recordset_column

RECORDSET R,
STRING NAME,
SLIST PROPNAMES,
SLIST PROPVALUES

(i,i,o,o)

Get properties of the ODBC column

determ

ezy_odbc_recordset_execute

RECORDSET R,
STRING SQLSTMT,
SLIST DB_ERROR_LIST

(i,i,o)

Execute SQL statement and get list of errors

determ

ezy_odbc_recordset_movenext

RECORDSET R

(i)

move to the next record in ODBC recordset

determ

ezy_odbc_recordset_properties

RECORDSET R,
STRING SOURCE,
STRING DRIVER,
STRING DBFILE,
STRING TABLE,
SLIST FIELDS

(i,o,o,o,o,o)

Get properties of ODBC recordset

determ

ezy_odbc_recordset_record

RECORDSET R,
SLIST DB_RECORD

(i,o)

Get current record from ODBC recordset

determ

ezy_odbc_recordset_release

RECORDSET R

(i)

Release(close) opened ODBC recordset

determ

ezy_odbc_sources

SLIST SOURCE_LIST

(o)

Get list of ODBC sources

determ

ezy_odbc_table_properties

ODBC_CONNECTION ,
STRING TABLE,
SLIST FIELDS

(i,i,o)

Get list of fields for selected table

determ

ezy_odbc_tables

ODBC_CONNECTION DB_OBJECT,
SLIST TABLES

(i,o)

Get list of Tables for selected ODBC source

determ

ezy_odbc_version

STRING VER,
STRING MINOR,
STRING BUILD

(o,o,o)

Version of ODBC engine


Copyright 1997-2013 EDMGROUP (Australia)