Old Methods and Syntaxes which we continue to support in PixieEngine 2.0

Cataloging of Programs compared to Direct Run
Preferred method now is "PixieEngine.ini", but you can also use tables/files named "md"
To call catalogued programs, scripts or ActiveX, simply enter the verb, which is the itemid of the catalog entry in file/table "md".  Using Microsoft Access to look at file/table "md" within account/database "testpxe1", 1st 4 attributes only shown:

A0 A1 A2 A3 A4
test1 ACTIVEX     px1.bp test1
test2 ACTIVEX     px1.bp test2
disptest ACTIVEX     px1.bp disptest
pxu1000 ACTIVEX     px1.bp pxu1000
umenu ACTIVEX     px1.bp umenu
stest1 VBSCRIPT     script1\stest1.txt stest1

 

 

 

 

 


Results of Queries, eg Select
Preferred method now is "SelectResult" but you can also use "SelectArray".

PixieEngine can represent query results internally as 2D arrays.  This gives a common presentation to results from differing datastores.  "SelectArray", the "old way", provides you with a local copy of this array rather than the faster "pointer reference" which was our original intention.  This array can be rather large and hungry on time and resources to copy, and we have also found it fails with scripting.  We would comment that we found the Microsoft documentation on this subject all too easy to misunderstand, and Microsoft technologies in general seem to have some problems with passing arrays as function arguments.

So, SelectResult takes the simpler, safer approach of reading individual elements out of PixieEngine as function calls while the true array remains as an internal entity.
Note that SelectResult may look like SelectArry with its identical syntax of "SelectResult(column, row), but it is an indirect "property of an array" rather than a full array in its own right.  That means that the UBound function can not be used with it, so we have provided an indirect equivalent to UBound to partner SelectResult:
nMaxColumnNumber = SelectUbound(1)
nMaxRowNumber = SelectUbound(2)