Jump to content

snooper

Members
  • Content Count

    17
  • Joined

  • Last visited

Community Reputation

0

About snooper

  • Rank
    Active

Profile Information

  • Gender
    Male
  • Location
    Netherlands

Contact Methods

LabVIEW Information

  • Version
    LabVIEW 8.6
  • Since
    2001
  1. has not set their status

  2. Hi, Try using the Execute with Result VI from the intermediate pallete. This will return a reference to a recordset based upon a query. See the image below for an incomplete example. Also you can open (Open Front Panel) of the Insert Express VI. If you search within this VI you will find examples of how to use the intermediate layer. With kind regards, Arnoud de Kuijper T&M Solutions BV
  3. Hi, Let me start by apologizing for the missing help file in the English language, we have not yet distributed this. But if there are any questions please do not hesitate to ask! Since you have posted this question on Lava I will try to answer it in this forum. The UPDATE command is responsbile for updating EACH ROW that meets the SPECIFICIED CRITERIA. So with UPDATE you can change one or multiple ROWS. Your criteria specified can be based upon a COLUMN's value and (like an ID, temperature, etc.) and allows you to change anothers COLUMS value in the SAME ROW. For example: I would like to update the first 1000 measurements (Identity column) and change the value of the temperature measurement (temperture column). Note: The criteria column and the column to be updated can be te same. Regarding your problem of the toolkit updating all values instead of the filtered one's: I have not been able to reproduce this. So if would be helpfull if you can show me a screenshot of your Express VI configuration. Or maybe post the example code on this forum. If you have any questions or remarks please ask (you can also find me at NIWEEK 2008). Aartjan: Thank you for notifying me about this post! Arnoud de Kuijper T&M Solutions BV Netherlands
  4. Hey, Is there any LabVIEW database user that is willing to share their experiences with this product? or maybe with using databases in general? With kind regards, Arnoud de Kuijper QUOTE(snooper @ Dec 7 2007, 01:57 AM)
  5. Hi, I just wanted you to know that we have recently changed our T&M Database Product from a paid license to a free product. The only limitation is that it can only work with MS Access Databases and has no support. There is no limit in the amount of development licenses, functionality, distribution or usage period. You can request the T&M Database Wizard Student Edition 2.4 at the following page. Our motivation is: -Get more developers the explore the power of database with Test & Measurement applications -Have more developers using our products -Maybe you are interested in the T&M Database Wizard Professional 3.0 (Support all platforms like Oracle, MySQL, MS SQL Server, DB2, etc.) For the dutch people: Bezoek ook onze Nederlandstalige LabVIEW Usergroup: www.lvug.nl Greets, Arnoud de Kuijper T&M Solutions BV www.tm-solutions.nl
  6. I am experiencing the similair since LabVIEW 6i. In my opinion this is not VI or project related, it looks more like a memoryheap-problem.The problems occurs in the following situations: 1. If you create a strict. def from a enum and then put this into an array which is also an enum, then dray the constant out of the array and in 10% of the situations LabVIEW crashes (LV 8.0 or lower). 2. If you have a lot of VI's (indeed above 1000, thus large projects) and then start changing a strict def whithin another strict def. LabVIEW crashes somewhere during the update of the VI's. The solutions indeed is to change the stricttype def with no other VI's open. This mostly occurs when the typedef is a big cluster with other clusters inside. 3. Can someone at NI speed up the update process. Try placing a few hundred copies of a simple strict type def enum on a front panel and then change the enum values. A good moment for a lunch break It is annoying, but I learned to life with it. (It helps if your computer restart LabVIEW fast) Arnoud de Kuijper T&M Solutions BV
  7. In my opinion the following design is more flexible and faster [TableData] UniqueID Primary Key+Identity PlotNumber U32 (bigint) TimeIndex U32 or DBL Value DBL now you can create an indexing on plotnumber and timeindex. This should make your query fast and simple. SELECT Value FROM TableData WHERE PlotNumber=0 and Timeindex>10 and Timeondex<1000 Greetz Arnoud de Kuijper T&M solutions
  8. Have a look at www.tm-solutions.eu and the database Toolkit. Makes database communication and datatypes a lot easier. Supports SQL server and MsAccess. With kind regards, Arnoud
  9. If you are interreset in an easy to use Database toolkit for LabVIEW with simple and advanced features supported. Try the T&M Database Wizard. T&M Dabase Wizard. This product allows you to connect to a database very easily and also helps you in constructing the correct SQL queries. The most advanced feature is the automatically generation of the datatypes in LabVIEW (Clusters, Arrays) according to the database design. Pricing is only 195 Euro's, so this should be no problem if you compare it to the time you save. With kind regards, Arnoud de Kuijper
  10. Hi, As far as I know it is not possbile to write a 2D array to a database Table directly. You are fixed to the 1 record insert. But there are a few possibilities and tricks -Switch to the ADO.COMMAND object to insert you data binary! This will decrease the size of your SQL command. -Dont use new SQL commands for every record, try to use a "prepared ado.command execution" -You might redesign your database to insert a 2D Array as an IMAGE datatype, but this will only be read/writable by LabVIEW. Arnoud de Kuijper T&M Solutions BV - Database Wizard
  11. Hi, We have just updated our website with new information about the T&M Database Wizard. This includes technical details and pricing information. To be honest our product demonstration is not ready, we will try to finish this as soon as possible! I hope this new information will help! If you have any questions please do ask! T&M Solutions BV Database Wizard for LabVIEW With Kinds regards, Arnoud de Kuijper T&M Solutions BV
  12. Hi, Since working with databases is not an everyday practice of most LabVIEW programmers and the National Instruments Database Connectivity Toolkits doesn't make life easier we have created a Toolkit that makes LabVIEW and database programming much easier! With use of the newest technologies available in LabVIEW, such as GOOP, Express VI technology and Automatic LabVIEW code creation, this toolkit enables you to work with database without having to know how they work. Some important features are listed below: Use LabVIEW Express VI technology to browse your Database Structure interactively. Automatic datatype conversion to familiar LabVIEW datatypes (Newest Technology!) Automatic generation of Structured Query Language (SQL) Easy maintenance of databasestructure To see the complete product specification see: T&M solutions Database Toolkit for LabVIEW If you are interested or have any other questions please do contact us. Arnoud de Kuijper T&M solutions http://www.tm-solutions.nl/eng Just see how simple your LV code can be: Configure the database actions with the use of Express VI's
  13. The attached VI show a correct connection code, but their are 2 options that could cause problems: 1) The Recordcount property is only usable when you can fully lock the recordset (set the correct locktype and cursurtype options). Otherwise the result always will be -1, but you do can read the records in the recordset! 2) This is the most likely problem: MySQL does not use an Cursor Location, you have the options: adUseNone, adUserClient, adUseServer. If you sets the Cursor Location before you open the recordset you do can retrieve the RecordCount Value. I have attached the new LV_mysql.vi with the new appropriate code, I do not have a MySQL server installed so I cannot test the code. If you are still experiencing problems, please do ask! Arnoud de Kuijper T&M Solutions BV T&M Database Wizard for LabVIEW! Download File:post-459-1103106591.vi
  14. Hi, You should try creating a connection to the MySQL server using a DSN connection, this means you create a Data Source Name to your MySQL server that contains all the necessary connection information. You can create a DSN in every Windows based pc by opening the "ODBC Administrator" in your "control panel". If you name your DSN "LVMYSQL" than you can open a connection in LabVIEW by using. "DSN=LVMYSQL". If you are interested in a more easy way, consider upgrading to LabVIEW 7.0 or higher. We have created a Database Toolkit that allows you to easily connect to a database using Express VI technology, you can also create queries without having to know SQL. On of the most import features is the automatic creation of the appropriate clusters and arrays, this according to the retrieved information from the database. Conversion like varchar to string, and float to double are already created for you! Have a look at: http://www.tm-solutions.nl/eng/produkten/produkten.html T&M Database Wizard for LabVIEW If you have any other questions, please do ask! With kinds regards, Arnoud de Kuijper T&M Solutions BV
  15. HI, converting labview timestamps to a database format is not easy. The first thing to do is to convert the labview timestamp to a DBL so you have the number of seconds sinds a certain startdata. Now you have to find some documentation about the startdate of the database you are using. substract/add the difference between labview and your database to have a correct value. Please note that the timestamp field is not always a real date/time it also could be a syncronisation bit as used in the SQL SERVER timestamp implementation. You might consider using a float;real for timestamp control. You can also have a look at the New LabVIEW Database Toolkit at www.tm-solutions.nl/eng Greetz
×
×
  • Create New...

Important Information

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