Main Menu
 Login  |  Register! 
plugins is developed by The SmartFactory (http://www.smartfactory.ca), a division of InBox Solutions (http://www.inboxsolutions.net)
Plug-Ins » Database » NeoSQLite 3 Client / Server Plugin
Plug-Ins

NeoSQLite 3 Client / Server Plugin  v011    
Download Now (1.57 MB) Be the first to review NeoSQLite 3 Client / Server Plugin
Hi All,

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 :

http://specialapps.rcmediaservices.net/files/SQLite3_C_S_Version_11.zip

Instalation:

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:

Código:
[config]
port        = default
ipaddress   = localhost
'ipaddress   = 192.168.0.100
'ipaddress   = www.yoururl.com
busytimeout =
idletimeout =
 
[database]
databasename = sample.db3
security     = PSS234|sqlrocks
security     = paulsq|mypassword
security     = mark123|secret
 
[database]
databasename = \pharmacy\drugs.db3
security     = todd34|nfldpass
 
[database]
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:

Usage:
AE_SQLite_Client "[sql]|[server]|[database]|[user]|[pass]|12069|[fd]|[rd]|[headers]|rset"

where:
[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 [ ].

Returns:
[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.

Remarks:

* 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

Version:  011
Updated On:  5 Feb 2015
Downloads:  1756
File Size:  1.57 MB
Publisher:  Aplicaciones Especiales
Home Page:  Special Apps
Price:  Free
Platform:  NeoBook 4/5
License:  Freeware
Limitations:  None
User Rating: 
Submitted By:  David_de_Argentina

Review this Plug-In | Rate this Plug-In | Report Broken Link | Recommend

Other Plug-Ins submitted by David_de_Argentina:




New Plug-Ins
New Pubs
Search