Neil Pate

Update: looks like my LAMP VM appliance is actually shipping with MySQL 5.5 which does not supprt fractional timestamps.. Updating at the moment... 

Hi guys,

I need to be able to insert and retrieve a timestamp into an SQL database with miliisecond precision (ideally three digits of precision).

Complicating the issue is that my final system is going to be hosted in a MS-SQL (so T-SQL) DB, but I am testing locally using a LAMP stack.

I have done quite a bit of digging, it seems T-SQL would like me to use datetime2 type, but this is not available in MySQL. Apparently I can should use DATETIME(3) as the type. I am struggling to create a table with this as a valid column. I am using a LAMP VM appliance which I believe is running the a version of MySQL that supports fractional timestamps, but the SQL statement to create the table is failing.

CREATE TABLE t1 (t dt DATETIME(6));

Any ideas what I am doing wrong?

Secondly, it looks like the NI DB Toolkit has very primitive support for timestamps, and people prefer to use strings? Can anybody share their current "best practice after having done it wrong a few times" with me? Beer on me for solutions 

Thanks 

Filipe, I do not see NI getting into the business of suing the end users of LV FPGA.

Not that I disagree with your points, I just think it is unlikely NI would go after anybody other than the obvious primary culprit.

Now, even having said that, I am still not going to expose my company (or my clients) to this risk and will choose NI officially sanctioned products over questionably legitimate offerings.

Yeah but haven't EULAs been proven to be pretty much worthless? 

Could it be something to do with the fact that those two funny looking icons are expandable XNodes at edit time and expect to be redrawn on the diagram?

2 minutes ago, drjdpowell said:

I always find images annoying because the are by-ref.  You send a copy of the reference to the image, not a copy of the image.  

But they are kinda ByVal as you wire into an indicator to actually display the image. You cannot just make that association once and then assume it will automatically get updated.

2 minutes ago, drjdpowell said:

Cast it to a U64 instead of an I32; then the numbers are different.

Bingo! Thanks James.

So Image refs are just plain old normal U64 size refs? I sometimes wish there was a way to see refs as native "pointers" in a probe rather than the special type (i.e. the image). I suppose I could create a custom probe and just display the U64...

More strangeness (probably just me not getting something).

Why are all four Image references the same? 

Hi gang,

Simple question, can I treat a Vision Images ref just like any other U32 ref with all the rules applicable like forking wires etc? It seems to me that there is some kind of special stuff going on with Vision Image refs.

Another related question, in my particular use case I have a piece of code generating a user event with an image as the data at some arbitrary fast rate. The act of Generating the user event creates the a copy, right? Some other code wants to process some of these frames (at a slower rate) and then I use IMAQ Copy to make a local copy, is this IMAQ Copy necessary or could I just hold onto the "Image" reference coming in from the user event? In the code below Images is just a local buffer I plan on using.

The reason I ask is I am getting some weird behaviour whereby destroying my Images refs as shown in Capture3.jpg kills my acquisition code as well. (I presume because I am forcing all images to be destroyed, but I am surprised this is happening)

15 hours ago, ToyLab said:

Don't forget I am new to Labview

 

I think you are trying to bite off more than you can chew here. DVRs, LVOOP and especially Dynamic dispatch is not really the first thing you want to learn on your LabVIEW journey.

I recently ran a simple vision application with a single camera that ran perfectly smoothly on a desktop CPU but absolutely choked on an Atom tablet. Nothing fancy going on either...

7 hours ago, madmax said:

means pirated version.......

Perhaps not the greatest way to ask for help.

Peter, have you tried accessing the Excel worksheet by index instead of name? 

Thanks. I think I am mostly on the same page as everybody here.

1 hour ago, peter_flores said:

@Neil Pate thanks! So, you are describing a one-time break and fix? When you say manually relink the ActiveX component, is that similar to my screenshots Version 1.3 and Version 1.9 above? Also, interested in your thoughts on the RGT as noted above... Thanks!

I did not need to do as you documented, it was sufficient for me to just re-select the broken method call inside the offending RGT VI . If memory serves me correctly it was the "SaveAs" method of the _Workbook object. All I had to do was reselect the method and it then was no longer broken. I think I noticed that the new method had an additional input.

But as I mentioned, although this worked fine on my PC it was broken on the target PC which had a much older version of Excel, so in a panic I uninstalled Office 365 and installed Office 2010 and everything then worked fine.

I have flip-flopped with this issue for like forever.

Say I have a simple dialogue that can be cancelled by the user, is it more sensible to return the cancelled status or the ok status?

I have always done it by returning a Cancelled status, I am just curious as to what others think is sensible.

I do not have an answer to your problem but can only share something that happened recently which is probably not related to your issue but I will say anyway. I have an Office 365 subscription and one of the more recent updates broke the report generation toolkit as the ActiveX interface to Excel changed. I was able to manually relink the ActiveX component in the code and everything worked fine on my PC after that, but the executable would then not run on my target machine which had an older version of Excel on it.

As far as I can tell a Matrix is just a typedef to a 2D double, there is nothing at all special about it. 

I would second what smithd wrote.

What is your experience with OO in LabVIEW? Certainly trying to refactor an application to OOP is not a good place to start your journey I think.

Ok good. Don't worry about the cluster for now. How did you generate that array, did you do it from code or manually?

21 minutes ago, shoneill said:

 I have had a long discussion with NI over this over HERE.

Champions access only  (things like this make me sad...)

Ok so lets try and make this as simple as possible. Imagine all you have is a single constant value of your International thankyou enum on your block diagram. I get the feeling you would like to display this as a 2D string array with the first column listing all the possibilities of the enum and the second column has  "1" in the column of the row that matches the constant value otherwise it has a 0, is this correct?

Can you describe in words how you would create this array?

Ignoring the fact that your array is not doing anything at all (you could just wire the Array indicator straight to the Strings[] output) you said you wanted to show the value as well, with 0 or 1.

I have given you my advice. Try implementing it as a 2D string array first. Leave the tree out of it.. Once you have mastered that you can think about getting it working in the tree.

As I said way earlier on in this thread I really think you are "mixing methaphors" here. The cluster viewer displays the "values" of items in the tree, not the set of all possible items. If you want that you are going to have to add it yourself and the tree API is not pleasant to work with.