plugins is developed by The SmartFactory (http://www.smartfactory.ca), a division of InBox Solutions (http://www.inboxsolutions.net)
NeoSQLite 3 Client / Server Plugin
If you need a Local / LAN / Internet Database, no install, no M$ royalties, no special hosting, no ODBC Drivers, this plugin is exactly for you.
All credits is for Paul Squires.
It can be downloaded at :
UnZip the package in any folder.
you will obtain 2 folders: Client & Server Folders
Server Folder: has this files:
SQL3Server.exe: The Server program. You must run this program.
SQL3Server.ini: The configuration File. you can edit this:
Sample.db3: Sample SQLite3 Database
SQLite3.dll, SLQ3Client.dll,zLib1.dll: DLL's used by SQL3Server.exe program. Please, keep this files within the same folder.
SQL3Server.ini: configuration: it has this aspect:
port = default
ipaddress = localhost
'ipaddress = 192.168.0.100
'ipaddress = www.yoururl.com
databasename = sample.db3
security = PSS234|sqlrocks
security = paulsq|mypassword
security = mark123|secret
databasename = \pharmacy\drugs.db3
security = todd34|nfldpass
databasename = \accounting\gltrans.db3
security = jennifer99|mypassword
You can edit and set some users and pass for each database.
Client Folder: has this files
NeoSQLiteClient.exe: The compiled program. This sample uses the HPWGrid Plugin.
SQLite_Client_plugin2.pub: The sample PUB
NeoSQLiteClient.nbp: The Client-side Plugin. It does not need be included when you create your own client package.
SQLite3.dll, SLQ3Client.dll,zLib1.dll: DLL's used by the plugin. Please, keep this files within the same folder.
Plugin has one function:
[sql]: is any SQL Statement.
[server]: like xxx.xxx.xxx.xxx or www.mylocalmachine.com
[database]: the SQLite Database name. It must be placed on the Server component folder.
[User]: is the UserName. It must be declared at sql3server.ini file at server component.
[Pass]: is the Password. It must be declared at sql3server.ini file at server component.
[Port]: by default is 12069. It must be declared at sql3server.ini file at server component.
[fd]: is the Field Delimiter. Could be any character.
[rd]: is the Record Delimiter. Could be any character. *** Not in use yet ***
[headers]: Could be "Y" or "N". If "Y", program retrieves the column names.
rset: is the return variable. Don't put it between brackets [ ].
[rset]: the variable you set.
Field Delimiter: the character you set at [fd] variable
Record Delimiter: the character [#13] in order to be compatible with the hpwGrid.
[AE_SQL3_Status]: Returns "Ok" or "Error (and the error explanation)"
[AE_SQL3_Rset_RowCount]: Return the number of records in the recordset.
[AE_SQL3_Rset_ColCount]: Return the number of Columns in the recordset.
* I had replaced any [#13][#10] with [#182] within field data, in order to prevent some irregular behaviour if your text data have some paragraphs. you could undo this action using StrReplace Action
* Updated Sqlite3.dll to version 3.5.7
* If your IP is like "192.168.x.xxx" you can use this services as Local or LAN services. You must use your "Real " IP in order to be useable as Internet service.
* I had restinged Server capabilities in order to generate up 500 rows recordset. I don't know what happend if you ask for a very big recordset. I think there are a good idea work with small recordset using the LIMIT clause in your SQL Statement. Your SQL Statement must look something like this:
SELECT * FROM Parts WHERE product LIKE '%paper%' LIMIT 20,30
Where 20, is the offset of the first record to retrieve, and 30, is the number of records to retrieve.
Using this technique, you can create "pages" of recordsets.
Plugin is free for private use.
Enjoy it !
David de Argentina