Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation


About jollybandit

  • Rank
    LAVA groupie

Profile Information

  • Gender
    Not Telling

LabVIEW Information

  • Version
    LabVIEW 2013
  • Since
  1. drjdpowell Many thanks for your time and constructive advice. There is the intension to also use this toolkit and SQLite dll with an application that has a much lower thoughput. This raises a few additional questions :- 1) practically how many reference connection are allowed (if any more than 1) allowing simulltaneous reading and writing to an SQLite file - are there any introduced deficiencies by instigating this practice? 2) in the senario of having multiple parallel loops, requiring access to the same SQLite database file (i.e simulltaneous reading and writing). is it a be
  2. Thakyou in advance for the offer to examine / improve the code. I have attached a Zip file of 1) test file generator 2) top level SQLite performance evaluation code written 3) XLS containg the timming results obtained. I will be very interested in your comment and coding improvements (with hopefully possible effeciency and file size improvements). I am aware of the SQLite.Org website - consequently, i also found a SQLite error vi that has in its block diagram view a well document summary of the possible errors and there structure / composition. Many thanks & Cheers Greg Testing_S
  3. Good day to all Lava users I am New to the envoroment of SQLite and have been experimenting with the tool kit . I have a few Questions that i hope someone will kindly answer and clarify for me and put me in good sted for the project i am about to commence. i seak answers to 1) at run time does the toolkit Vi's returned errors, if so, what are they? 2) Within the SQLite read loop,is it a good practise to wire the error cluster to the while- loop stop button? 3) i have been comparing a LabVIEW spreadsheet file write \ reads to SQLite file size, times for speeds against similar actions.
  4. Whilst that is fine i was endevouring for a more Labview refined way of doing this such that it wasn't dependant onembedded 'sql' coding in my vi(more Generic for any db). I also notce (as shown in the third labview code snipett) that if i pass in the name of the stored procedure i get all the elements as part of the stored user procedure plus an additional parameter called @return_Value - which is not in my written stored procedure . Is this something Labview inserts / generates or is it some function of the setup of the database itself???
  5. Need assistance in resolving an issue with calling MSSQL 2008 server side user stored_Procedures. I have currently been writing and executing MSSQL code to call the procedure names of the user stored procedures which i then use with the LabVIEW DB Tools Create Parameterized Query VI. Is there a native LabVIEW coding which is able to get the list of the user stored procedures from the MSSQL database? i have attached code segment that i am currnetly using. Once i have the user Stored Procedure names i have already worked out how to call the associated input /output/ parameters with ther
  6. Hi all I'm Relatively new to the LabVIEW database tool kit and have worked my way through to successfully have connectivity to a SQL 2005 and Mysql database servers in which queries returned both tables and contained data. The core system is a SQL server 2005 with a developed extension table held on a remote database. Read access is only granted to the core system. The aim is to either link these databases through some "Labview linking (composite)" or "SQL Linking" function to return query results across unions on both databases. I am able to establish individual connectivity to each DB su
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.