ANV Database by ANV - Toolkit for LabVIEW Download

Version	1.6.26.2
Released	Mar 25, 2021
Publisher	ANV
License	EULA
LabVIEW Version	LabVIEW x86>=15.0
Operating System	Windows
Project links	Homepage Documentation

Description

ANV Database Toolkit (ANV DBT) is a toolkit, which helps developers design LabVIEW API for querying various databases. It allows to create VIs which can be used as API with the help of graphical user interface. When using these VIs, toolkit handles connection with the database, thus relieving developers of this burden in their applications.

You need to run VIPM as administrator in order to properly install the toolkit.

Release Notes

1.6.26.2 (Mar 25, 2021)

Updates/improvements:
- added new VI to functions palette "Query Result to Table". It could be used to easily convert SELECT DATA query results to Table (2D strings array);
- added selector of active database alias from API Manager VI. On selector's change, respective database is loaded;
- changed style of all created controls/indicators to Silver style;
- added "Filter Input Name" field. It allows to set name of filter's input, when filter comparison type is set to "value";
- documentation is added to the description of generated API VIs;
- added custom icons for API VIs list which indicate whether API VI is invalid, is valid or does not correspond to currently active database;
- added button "Error Details" to Query Test UI;
- improved error handling for database structure in API Manager;
- added validation of API VI name to check whether name is valid for OS platform;
- added check whether inserted/updated field is primary key during drag and drop;
- renamed tabs in API Manager to "Configure", "View", "Test;
- INSERT SELECT DATA query type name is changed to INSERT THEN SELECT, in order to better describe its purpose.

Fixed issues:
- fxed bug #229 - when error occured on Discard action, when no API VI was selected.

1.5.0.3 (Feb 22, 2021)

Added new query type - INSERT SELECT DATA.
It allows to generate single query which will do INSERT first, and then SELECT of the data. Could be useful when there is needed selection of auto-incremented primary key after insertion of the entity to database.

Fixed compatibility with SQLite Library v1.13.0.93.
Users who use ANV DBT <= 1.4.0.2 with SQLite Library v1.13.0.93 will have error while executing Select queries, due to changes in SQLite Library (Select does not allow binding array of data, but just scalars). Current build implements compatibility and processes both arrays and scalars.

1.4.0.2 (Feb 02, 2021)

Updates/improvements:
- added new palette VI "Get Connection String", which returns connection string to database, based on DB Alias (issue #246);
- added custom icons for database structure tree;
- added warning message for user in case when primary key is selected for Insert/Update query.

Fixed issues:
- #264, when API Manager was closed after Filter window was closed using Panel Close button;
- #259, #263 - dialog window was shown to select the project, when API VIs were used without project, or in executables.

1.3.0.2 (Dec 29, 2020)

- Tools menu: when project is not saved and "Configure Storage" or "API Manager" items are selected, warning message appears;
- Toolkit's home page link is updated for the package;
- Added name of the license to the toolki's information;
- Removed Ez Message functions from API Core Template;
- Fixed issue #244 "Renaming API to capital version throws an error". Now comparison of API VI name is not case-sensitive;
- added "Sample Project" menu item, which opens Windows explorer folder with Sample Project path;
- updated icons for palette VIs;
- included default SQLite database with the Sample Project;
- Configuration Storage updated in a way that when opened, the first active database is displayed (in case of Sample Project it should point to default SQLite database immediately on the first launch);
- Fixed issues #239, #240. Now, when target library is missing in the project but is present on the disk, then it is added to project first;
- Fixed issue #238. When new name for API VI is entered, it is checked also against all VIs in the target folder, even if the VI is not part of the API library.

1.2.0.30 (Dec 14, 2020)
no release notes for this version

1.2.0.28 (Dec 10, 2020)

Updated User Manual.pdf with description for MySQL configuration.

Show all release notes (+5 more releases)

Install with VIPM Download Package

Note, you must have the VIPM Desktop app to install this package into LabVIEW.

Versions

1.6.26.2 (Mar 25, 2021)

1.5.0.3 (Feb 22, 2021)

1.4.0.2 (Feb 02, 2021)

1.3.0.2 (Dec 29, 2020)

1.2.0.30 (Dec 14, 2020)

+ 1 more

Published by

Add to Package List

Post an Idea Post a Resource

ANV Database Toolkit: Insert Queries In previous post I’ve briefly described ANV Database Toolkit and the way of how to create Select qu… by Ivan Yakushchenko, 10 months, 1 week ago, 0 , 1
ANV Database Toolkit: Intro Check the brief intro to our new ANV Database Toolkit - toolkit, which is going to change the way o… by Ivan Yakushchenko, 11 months, 2 weeks ago, 0 , 2

Description

Release Notes

Recent Posts