Database Access Object

back to main page

Click here to download Database Access Objects. This object allows access to ODBC sources, retrieve ODBC source properties, table lists, execute SQL queries and retrieve individual column properties.

To include Database access object - open your project.inc file with VP Studio Setup utility and checkout necessary options:

The following class properties are available for programming:

procedure new(database_connection,STRING TABLE, SLIST FIELDS,STRING CRITERIA)

procedure executeSQL(STRING STMT)

procedure get_column_value(INTEGER,SLIST VALUE) - (i,o)

procedure get_max_row(LONG MAXROW) - (o)

procedure get_record(SLIST) - (o)

determ move_next

procedure db_error(SLIST) - (o)

procedure display_errors

procedure get_field_value(STRING FIELDNAME,STRING VALUE) - (i,o)

determ get_column_properties_by_name(STRING NAME,SLIST PROPNAMES,SLIST PROPs) - (i,o,o)

determ get_column_properties(INTEGER Column,SLIST PROPNAMES,SLIST PROPs) - (i,o,o)

determ db_properties(STRING SOURCE, STRING DRIVER,STRING DBFILE,STRING TABLE, SLIST FieldList,ILIST FieldTypes,BLIST UPDATABLE) - (o,o,o,o,o,o,o)

procedure add_field_value(STRING FIELDNAME,STRING VALUE) - (i,i)

procedure add_record

procedure get_insert_stmt(STRING)-(o)

procedure add_data_record(slist SQL_FIELDLIST,slist SQL_VALUELIST) - (i,i)

 

Final application will provide you with following dialog:

 

There is another example of Database Access Objects inside VIP Universal Explorer.

See VIP Universal Explorer, it has this object implemented.

 

Copyright 1998-2002 EDMGROUP (Australia)

Last Updated: April 17, 2002