Repo introducution

Repo will let you open a DataEase application for use in node. Before you create a new Repo object, you must have a working Prism object that is successfully initialized.

Repo is from where you connect to your data or updates the structure of your data.

closerepo	boolean	Close the repository. This must be done before opening a new one as only one can be open at the time.
deletetable	boolean	Delete a table in the repository. Return true if successful. Paramters: - tname \| name of the table to delete
execdql	string	Exexute a dql and return the result as a string. Depending of if you use a template or not, you will get a csv or a string build on the template. The template engine used here, is the very simple DataEase 8 version and not the new server version found in DataEase 9. Paramters: -script \| the dql that is been run - template \| template to use with exec dql - field1 \| data-entry that is picked up in dql as data-entry field1 - field2 \| data-entry that is picked up in dql as data-entry field2 - field3 \| data-entry that is picked up in dql as data-entry field3 - field4 \| data-entry that is picked up in dql as data-entry field4
getdateformat	string	Based on the setting in prism you get MM/DD/YYYY, DD/MM/YYYY or YYYY/MM/DD where / is replaced by the separator used by prism.
getdateseparator	string	The date separator used by prism
getdatestandard	string	The date standard used by prism. Can be: 1 North American MM/DD/YY 2 International DD/MM/YY 3 Metric YY/MM/DD
getdesimalseparator	string	The separator used for decimal in floating point and decimal numbers
getlasterror	number	The last error code returned from a prism call
getlasterrorasstring	string	The error as formatted by prism.
getletter	string	The letter used for RDRRxAAA.INI and the like. x is then replaced by this letter.
getthousandseparator	string	The separator used for triplets in a number. Ex 1 000.23 for thousand point twenty three
gettimeformat	string	HH:MM:SS where the : is replaced by the separator used by prism
gettimeseparator	string	The separator used by time
isopen	boolean	Return True if the repo is open
listcommands	Array	Return a string array of all commands supported by DQL
listfunctions	Array	Return a string array of all functions supported by DataEase
listoperators	Array	Return a array of all operators supported by DQL
listtablenames	Array	Return a array of all tables in repository
openrepo	boolean	Open a named repositiory Paramters: - name \| name or the repository as can be seen in catalog - path \| path to the repository as can be seen in catalog - [username] \| if you have a username you want to log in with add it here if omitted blank is used - [password] \| if you have a password you want to login with add it here, if omitted blank is used
rename	boolean	Will close repo if open to clear all, then open it, renname to new name and close again. Paramters - newname \| the name to rename to - [newappkey] \| if given will tell to generate new appkey or not. If not given a new appkey is generated.
runfunction	string	Call into DPRunFunction with a function name and 0-8 args and return the result.

How to open a repo

var denode = require('./denode')
var prism = new denode.Prism();
var prismpath = __dirname + '\\denode'
console.log('Path to this denode is: ' + prismpath);
prism.setprismpath(prismpath);
var isinit = prism.prisminit();
console.log("is init done with result " + isinit);
if (isinit == true) {
    console.log("Prism init ok");
    var repo = new denode.Repo();
    repo.openrepo('The repo name', 'C:\\Path\\To\\DataEase\\Application');
    console.log(repo.listtablenames());
    ...
    repo.closerepo();
} else
    console.log("Prism init failed");
prism.prismclose()<br>

This will first load the module and create a connection to prism. Prism need to know where the module is, so we add a prismpath and init prism. Then we create and open a repository. Do what needs doing and make sure to close the repo and shut down prism.