Leaderboard

Hi folks, Thanks to drjdpowell for putting this library together - it is very useful. I would like to share an issue I faced when putting together a test VI to execute some SQL queries. If the function is not saved the SQLite Open function will return an 'OK' error however with a db connection id of '0'. Subsequent calls (in my case to execute SQL and then close the connection) also return with no error. Save the function and things start working correctly. The issue is in the 'Open (string)' function which uses Application Directory.vi to help locate the sqlite3 DLL. This function returns <Not a Path> if the VI is not saved, when <Not a Path> is input to the CLFN it returns with no error and what appears to be 'default' values on output (empty string, 0 int). To me this is a bug with the CLFN, although the API could check for this condition.. or I could just save my code

The hallmark of an experienced LabVIEW developer is the usage of their or others templates which prevent the ubiquitous blank block diagram symptom where time is wasted doing the same thing that they have done before. Attached and linked you will find the TLB` (prime) template which, after a little learning what the parts are, can take you from zero to 60 in no time the next time you need to create a Top-Level application or interface. This template can be used from the ultra simple UI to a fairly complex application. Many questions and comments have been made about the original design (TLB) which is located here http://lavag.org/topic/14164-discuss-tlb-top-level-baseline/ This reason for the update in this design is detailed in the presentation "Rebirth of the LabVIEW State Machine" which is accessible here http://lavag.org/topic/16091-ni-week-2012-videos/page__view__findpost__p__97844 Installing and Creating http://screencast.com/t/vtlFgLhQqT Review of Examples http://screencast.com/t/XLIN0yjS Structure of Code http://screencast.com/t/5RtMhPVujS Basic Flow of Operational Code http://screencast.com/t/1QGFRRuSf0nT Adding a control to the system http://screencast.com/t/IJTxEQ28 Adding an action to the system http://screencast.com/t/5984lGlMjM <More to come soon> QSM Evolution.zip Code used in presentation video detailing why the typical QMH is fraught with issues that we have all run into Credit to Daklu for it's creation and sharing ni_tool_tlb`-1.2.0.23.vip Most up to date version of TLB` Rebirth of the LabVIEW State Machine.pptx TLB` Application Template.vipc

To resolve this problem, I cast the DVR into a U32. So in your private data of your class you will have only a U32 so not anymore recursive loading. To access your data you will need to recast the U32 to DVR.