Hi All,
I'm new to LabView and am hoping for a few guidelines to point me in the right direction for an application that I have to develop.
I have to build an API to read/write to a database (SQL Server). Another application will essentially have the ability to call my API to read in data from one table (ie supply it with a product code, version details etc – and return filename and programming file), and it will also write to another table in the database.
The following public function VIs are required (ie. API functions to be called)
Open Database
Read From Table 1
Write from Table 2
Read from Table 2
Close Database
Create one Top-Level VI that can be used as an “example application” – something you can use to test your function Vis.
On the front panel, show the two tables
Ability to read/write to tables
Middle-layer Vis should allow easy adaptation of table structure changes if required in future.
All other Vis that support the top-level functions, should have access scope set to private.
I imagine that all SQL query generation would be handled by the function VIs. They will also handle all data procedures. The only thing that the interfacing application should be concerned about is providing and receiving data to/from the database.
I understand most of what's required, but I'm still not sure on where to begin.
Can someone point me in the right direction and give me a starting point.
Regards.
