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
Plug-Ins

NeoSqLite 3  v1.0    
Download Now (196 KB) Read User Reviews of NeoSqLite 3
Hi all,

NeoSqLite 3 wrapper plugin is available.

It can be downloaded from:

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

On my tests, it works with SQLite version 3 databases only.

Refer
www.sqlite.org for further information.

Plugin has 2 functions:

AE_SqLite_cmd "[database_name]|[sql_statement]|return_variable"
where:
[database_name]: is the fullpath name of the sqlite database
[sql_statement]: like "Insert into ...." or "Update Table..." or "Delete from..." etc.
return_variable: is the name of the return variable without brackets [].
Returns: Ok or Error.


AE_SqLite_Select "[database_name]|[sq_statement]|recordset_variable"
Where:
[database_name]: is the fullpath name of the sqlite database
[sql_statement]: like "Select * from mytable..." etc.
recordset_variable: is the name of the return recordset variable without brackets [].
Returns: Recordset.
Field Delimiter: pipe - "|" - [#124]
record Delimiter: character 13 [#13]

Plugin is free for private use.

Enjoy it!

David de Argentina

Version History:
Hi All,

NeoSQLite Plugin had been Updated.

It has 2 new functions in order to handle BLOB Fields and Binary Data.

You can import/export Images, MP3's, Word Docs, and all kind of files...

AE_SQLite_BLOB_Get: allows to export BLOB Field data to a file

AE_SQLite_BLOB_Put: allows to import a file within a BLOB Field

Syntax:


AE_SQLite_BLOB_Get "[Database]|[table_Name]|[Field_Name]|[WHERE_CLause]|[Target_Filename]|return_variable"
Where:

[database]: the SQLite 3 database name
[table_name]: The selected table of the database
[Field_name]: The name of the BLOB Field
[WHERE_clause]: like "ID=3" or "Code=2345"
[Target_Filename]: The name of the New File with extension
return_variable: returns Ok or Error

AE_SQLite_BLOB_Put "[Database]|[table_Name]|[Field_Name]|[WHERE_CLause]|[Source_Filename]|return_variable"
Where:

[database]: the SQLite 3 database name
[table_name]: The selected table of the database
[Field_name]: The name of the BLOB Field
[WHERE_clause]: like "ID=3" or "Code=2345"
[Source_Filename]: The name of the Source File with extension
return_variable: returns Ok or Error


Plugin es Freeware for private use.

Enjoy it!

David de Argentina

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

User Reviews (2) | Rate this Plug-In | Report Broken Link | Recommend

Other Plug-Ins submitted by David_de_Argentina:




New Plug-Ins
New Pubs
Search