Jamie Balfour

Welcome to my personal website.

Find out more about me, my personal projects, reviews, courses and much more here.

Official ZPE/YASS documentationzpe.lib.accdb

The libAccdb plugin is the official ACCDB (Microsoft Access) plugin for ZPE, offering nice and straightforward usage of .accdb files using ZPE.

Functions

open_access_file (string path) ⇒ object
Opens an Microsoft Access database file and returns an MSAccess object.

Objects

ACCDB

get_tables () ⇒ list
Returns a list of table names.
get_table (string table_name) ⇒ object
Returns an MSAccessTable object representing the table, or false if the table cannot be opened.

MSAccessTable

get_rows () ⇒ list
Returns a list of MSAccessRow objects for each row in the table.
get_field_names () ⇒ list
Returns a list of field/column names.

MSAccessRow

get_column (string column_name) ⇒ string
Returns the value in the given column as a string (or an empty string if the value is null).

Notes

None of the objects in this plugin are directly exposed on to the object path of ZPE and they are only usable as object-references.

Comments

There are no comments on this page.

New comment

Comments are welcome and encouraged, including disagreement and critique. However, this is not a space for abuse. Disagreement is welcome; personal attacks, harassment, or hate will be removed instantly. This site reflects personal opinions, not universal truths. If you can’t distinguish between the two, this probably isn’t the place for you. The system temporarily stores IP addresses and browser user agents for the purposes of spam prevention, moderation, and safeguarding. This data is automatically removed after fourteen days. Your email address is stored so that replies can be sent to your email address.

Comments powered by BalfComment

Feedback 👍
Comments are sent via email to me.