Sergey Kolbunov

I've tried hard, but I could not find how to register for sessions this year. I had no problems with that last year. Could you point me where to click?

Because I seriously started to use LabVIEW just from version 8.2 and just barely touched 7.1 as self education, I don't feel 8.x are worst. But I'm having unrecognized problem with building applications in 2009. Old projects converted from 8.6, no matter big or small, just can not be built in 2009 that main vi would not be broken. Workaround is to turn on debug option in build, that helps but make executables 3 times bigger. I didn't try 2010 yet to see if this issue is fixed there.

I like your sentence about QWERTY vs Dvorak layout. Good example of "standards pressure" and misoneism.

I'm not sure if it is a dupe or not. I found this topic yesterday. I've never seen so sincere stream of hate. How dreadful to live in this world. Quite interesting reading though.

I put together a little example of how to use my modification of MC ListBox XControl (see post #7) to create a UI element of two lists, left with available items and right with selected items, using Select, Unselect buttons to move elements between lists. (I don't know an official name for this UI structure). The vi should be put into the MC_ListBox_XControl folder. The vi is in LV 2009. MC_ListBox_XCtrl_example.vi

It's not too hard to learn and follow. Personally, I treat 12/9/2010 (slashes) as US notation (Dec 9), but 12.9.2010 (dots) as European notation (12 Sep).

One drawback I found in the code: TSPopup.Update Cell String.vi uses Replace Array Subset primitive to update Listboxes, MCListboxes and Tables. That makes impossible to insert new rows into control. Says, if the control doesn't have any data initially, then popups appears and allows to select/type a value, but the control is not updated.

I'm only dealing with different databases on the same server. In this case you actually don't need to care about "linking" of these databases, they may have foreign keys across databases for integrity and that's it. SQL query can join tables from different databases, you just need to specify the database name before the table and field name. The queries can be sent from you LabVIEW application or be in stored procedures in database, no matter. I preffer to move as much logic as possible from LabVIEW application to SQL queries/Stored Procedures. LabVIEW is much slower in case of complex queries. My initial version which using just SELECT and manipulating with data in LabVIEW required 40 sec to get data out of DB, compare to fraction of second for the replacement SQL query. Learn SQL, there is no way to avoid this in the Relational Databases world. As a 'link' solution for your remote database you may try to create views in your 'local' database for all required tables from 'remote' database, there is no duplication of the data tables in this case and data in views is always actual. Then, from LabVIEW you establish connection to the 'local' database only and works with it. But this solution is Read Only.

I got it, thank you.

I'm using NI toolkit to interact with DB. Most of time I just execute my own SQL queries and don't use NI toolkit's select or insert or other built in utilities. Sorry, I can not find any built-in code for inserting clusters into DB tables in the NI DB toolkit. OpenG variant configuration looks like what I need to manipulate with cluster's data. To clarify my question, I'm looking for known and proven DB schemas to store LabVIEW clusters in Database, may be some examples to learn from. Store as key=value list in a string field?

Need to store clusters is MySQL database. I don't want to store a whole cluster, but just some of cluster's elements what need to be checked in test. So far I'm thinking about XML and .ini file formats.

Got my CLA exam results yesterday. I PASSED!!!

Hi All, I just want to announce what a LabVIEW Object-Oriented Programming System Design class is scheduled in Downers Grove, IL on May 17-18. If you or somebody from your company are interesting in taking this course, you may join and save on traveling. This is not too often when advanced LabVIEW classes take place in Illinois. The course is open for enrollment and posted at ni.com. http://sine.ni.com/a...&p_continue.y=5 Thank you, Sergey

Here we go. I'm sorry for lack of documenting. I'm not sure is it right to post this code here in certified repository, but this is just enhancement of the original Multi-Column Listbox XControl. Pay attention to Value Filters. Enhancin of this feature was the main reason I did the modification. MC_ListBox_XControl.zip

Yair, Your comments sounds very reasonable. I did modification of Karissa's code for my needs, but my changes doesn't include anything what you mentioned. I do deffer FP updates outside the xcontrol code. What about autowidth feature, I simply don't need it and made it disableable. Still using listbox as a storage area. Your last suggestion is the best. What changes I did, besides the enabling of some native listbox properties like Visible Items group, I made columns width ajustable programmatically in addition to autowidth. A column can be made hidden. Also, I modified the Value Filter greatly. The original one could do AND opearation only, but I was needed OR. So now my filter can process AND/OR logic but does it sequentially (doesn't undestand brackets). Also, UI for value filters displays column names now instead of number and doesn't display hidden columns (while you still can filter by hidden columns programmatically). One more addition, selected row kept selected through sorting or filtering process. All these changes might be not made the optimal way, but works great for my purposes (if don't forget to deffer FP updates). If somebody interested, I may post the code.