Dave Graybeal

I haven't actually tried the odbc for postgres yet. It's my understanding that the ADO (OleDB) method is a newer (and better?) method. Also, at least to this point everything that we have is written using an ADO (connections to Sybase and Access). If I can't seem to find anything that helps solve this issue I'm having with postgres and seemingly only available ado provider for it, then I'll probably have to venture into another connection method (probably odbc). I would obviously like to not have to go down the road of re-writing code thats already written using ADO however. I'm hoping to discover a miracle cure i think. lol. Thanks, Dave

Alright, Update: It would appear that the issue behind this is the ADO providers support for Parameterized Queries does not seem to include date and time stamps I believe. The ado provider for postgresql that I was using was PostgreSQL OLE DB Provider which I found on at PgFoundry . Does anyone know of another option that has worked for you? Thanks again, Dave Graybeal

Alright, Attached is a VI that I've created to demonstrate this problem. It uses an Enum to determine which Insert to Test. The order they can be run in is Access Non Parameterized --- This Returns No Error and Inserts Properly PostgreSQL Non Parameterized --- This Returns No Error and Inserts Properly Access Parameterized --- This Returns No Error and Inserts Properly PostgreSQL Parameterized No Date --- This Returns No Error and Inserts Properly PostgreSQL Parameterized Date --- This Returns An Error and Does Not Insert Data http://forums.lavag.org/index.php?act=attach&type=post&id=5728 In order to run this VI, you'll need to Create a UDL file that points to an access DB (to test the access cases) and a UDL that points to a postgresql DB (to test the postgresql cases). Also, there needs to be a table in each database named "example" with 2 columns ("id", "stdat"). "id" is of datatype integer (also used as the Primary Key). "stdat" is of datatype date. I would appreciate any information that anyone has regarding this issue. I'm having a hard time finding new places to look for potential solutions to this. Thanks, Dave Graybeal http://forums.lavag.org/index.php?act=attach&type=post&id=5727

tcplomp, Thanks for the link to the KB on NI's Forums. It looked like it only applied to MS access however. In our case we can connect to MS access and write all the data types fine. It just appears to be an issue when we try to write to PostgreSQL with a Date Column. I'll put together a VI that demonstrates the code that works as well as the code that does not work. If anyone's successfully done this before any help / advice would be appreciated Thanks, Dave Graybeal

QUOTE Yep, I tried it this morning actually to make sure. A VI that you save in 8.2.1 can be opened and edited in 8.2 just fine. Every file that you open in 8.2 though does think it needs to be resaved, so this could be an inconvience if loading lots of file. Dave

Hey all, Has anyone used a Parameterized Query to Insert data into a PostgreSQL date Field? I'm getting an error returned when it tries to execute the query. The same code works when I try to talk to an Access database. Thanks, Dave I'm currently using LabVIEW Database Connectivity Toolset for LabVIEW 8.2.1, PGADO client and PostgreSQL 8.2.

QUOTE I think Doon might be onto something here. This would make it an anonymous vote sorta thing on every post that could likely be automated. This would eliminate the need for a large moderators group and still inform the poster that they need to do some more work before they resubmit the question. Thanks, Dave

I agree Crefl, this shouldn't fall solely on Mike. I would also be willing to help out as a Moderator if we would like for this purpose. I'm sure there are plenty of members willing to help with this issue. I know that my recomendation would take more work than just moving the forum, but I think in the end it would help fuel more constructive posts and act as more of an encouragment towards new members to get involved properly. Dave

QUOTE QUOTE locking that topic makes sense to me, because then nobody can choose the *wrong tone* in an answer. A standard answer is a more or less friendly but clear signal, that we don't like homework hustling around here. I'm not sure i think the topic should be locked. I would be more in favor of it being locked to people other than the creator and moderators. Locking the thread altogether would fail to allow the poster to rephrase the question. Maybe a procedure should be more like this. 1) Unclear, Nondefinded posts get moved to another topic (maybe something other than HH to prevent new members from being offended.. maybe something like Rework Needed?) 2) A default post from the moderator that moved the thread to inform them that the post needs some work in order to be acceptable on LAVA. 3) Lock the thread from everyone but the original creator and mods 4) Send the creator a PM informing them of the move (maybe with a link to the new post) 4) Let the post sit for some period allowing the creator to fix the issues with the way they posted it. 5) After the creator has the post fixed they send a PM to the moderator(or whoever originally moved it) requesting it be moved back Something like this might help promote the following of guidelines in a non-offensive way for someone that just didn't take the time to read the post guidelines before posting. Obviously after the same account makes numerous of these poor posts it could be set upon the moderators to take futher action. Hope these ideas are useful. Dave Graybeal

QUOTE I can't wait to see how this pans out. Should be Interesting lol. Dave

Well, there are more than one way to put in a header. The first way that comes to my mind is just use a concatenate string. Since the data is arranged in a spreadsheet string its format is pretty much: data1[tab]data2[tab]data3[cr]data4[tab] ... etc. Tabs denote column changes and CR denotes a row change (Tab is actually a Tab and CR is a Character Return). So you can simple build your header as follows: Send Value[tab]Received Value[cr] then concatenate that on the front of the spreadsheet string before you write it to the file. I hope this helps. Dave

Suleyman, It was nice to see a VI showing what you were trying to accomplish. Between that, the screenshot and the description you formed what I feel was a good question. You were on the right track to get the data sorted into columns and rows. Attached is a VI that I built off your example to give you a pretty good idea as to how to go about getting the data formatted properly. One difference in the way I handled it was that I get everything into a 2D array (virtual table) before I write data to a spreadsheet file. This allows me to get it to look how I need it without having to think. I also notice that the way you have the VI set up it basically opens the file writes all the data and then closes the file each time you loop around. I'm not sure if this was intended, but I would recommend either doing all the writing outside of the loop at the end, or using the following procedure: 1) opening the file before going into the loop. 2) writing a single row of data to the file (for this you would use a tab delimiter for the array). 3) close the file after exiting the loop. I hope that this information helps you along your way. Dave Graybeal

My guess is that the Declining Interest in LabVIEW from Googles perspective is that after doing 1 search you find LAVA. After finding LAVA you realize that there isn't much need in going back to Google to try to find more relevent information about LabVIEW. LAVA, Your 1 Stop Shop for LabVIEW! or LAVA... Once you Start, you Can't Stop! Dave

I went to Edit the Link to the Support thread today for my recently approved code. It seems that every time I edit the description it lists another file in the download list. I think this may be confusing to people downloading the files because they might think that some changes were made when really there was no update. Is this something that I as a member can edit to remove duplicate files from the history? Thanks, Dave Graybeal

Well, I've been told that LabVIEW 8.2.1 has been officially released. At the same time though, it does not appear to be located anywhere on ni's website. Anyone on here have the patch floating around or know when ni plans to make it available thru their website? Thanks, Dave Graybeal

Sweet, I'm glad it sounds like there might be a best of both worlds solution Thanks, Dave

Michael, I hope you didn't think my post was meant to be rude or demeaning to the efforts you put forth towards these forums. I am extremely greatful for the work that you put into this meeting place. It was just something that I noticed recently and wasn't sure what drove the change. I certainly understand that the higher that number the more resources required to make them available. I also understand that if I were to be away for a period of a week that I should not expect the RSS feed to save me from having to travel to the site to catch up. I actually enjoy browsing the site as it was created because I think you did a great job in laying everything out. I'm curious, how many posts on average does LAVA see in a day? Maybe this is how 50 was determined to be used, I don't know. I would think that if I were to check for RSS feed updates once every morning as part of my daily routine, that I would be able to retrieve all the posts from the previous day(With the execption of some peek traffic on a random day). Thanks, Dave

Tomi, I do infact understand what your saying. It is important to maintain your copyright information, and I think anyone viewing your blogs should be willing to view the advertisements to support the cost of hosting. Is there another option though? When I view the Lava RSS in my RSS Reader (Thunderbird) it appears just like the webpage that I would have clicked on. I would imagine that this would count as a hit on the website being viewed and that It would also show any advertisements that exist there. ThinkingInG is another Example of a blog that displays the actual page. I would think this would solve the issue of advertisements not being viewed. I'm not sure however if this solves the rehosting issue you mentioned. I do enjoy your blogs and don't mind going to the site, I was just wondering if there is a way to get the best of both worlds ( you get the credit for people viewing them and we get to view them in our environment of choice). I'm curious if what Michael Aivaliotis and Jim Kring are doing solves these issues. Dave Graybeal

I'm a huge fan of all the work that everyone puts into their blogs. First I'd like to say thanks for that. There are a lot of great articles out there. My question is in reference to the way the RSS feeds for a lot of these blogs show up in my RSS Reader. For Example, If I look at the LAVA RSS Feed I see the actual website embeded into the RSS Reader for me to view. I've seen a few of the blogs lately that just post text summaries for the RSS (not as nice to look at as the original html page), and even others (Expressionflow) that only show 2 lines of text and then directs you to the webpage for more. Is this an option on the Blog creators side that they get to decide how their blog is viewed? Or is this an option thru my reader that is Blog Specific? Thanks, Dave Graybeal

I'm curious, did the number of LAVA threads available via the RSS change recently? Previously I was receiving the last 100 posts from the RSS feed. The last 2 days though I've received exactly 50 multiple times. It could just be coincidence that there were only 50 new posts to be aquired, but it led me to wonder. I like having the max posts at 100 because on any given day there could be 30 - 60 posts. Having 100 posts means If I miss a day I don't always have to worry about having missed some threads/posts. As of recently when I saw 100 new posts when I did a retrieve I would go to the website and browse them thru that interface (instead of my rss reader) to make sure I wasn't missing something. If the new limit is 50 posts, I will likely be forced to use the RSS reader less to prevent missing posts. Thanks, Dave Graybeal P.S. I do enjoy browsing thru the Website directly, but there is a certain convienence to using the RSS Readers that I enjoy.

I submitted a few VI's to the CR that I use to Get a Reference to all My Controls and a vi that allows me to search thru them to obtain the reference that I want. Hopefully they will be made available soon once I get them approved. I hope that you will all find those vi's useful when dealing with control references. Basically what I use the vi's for are to obtain all the references on a calling vi, I then pass them in a shift register in my application, and finally use another vi to obtain the reference I want by name. If you get a chance to stop by and check the CR and take a look (after they are approved of course) I would appreciate any feedback and recomendations to improve on them. Dave Graybeal

QUOTE Not only do I agree with this, but I was surprised to see a post with anything more than HH for the text. lol, Whatever kind of coffee your drinking you better start sharing with the rest of us. Dave

It sounds like he might just be trying to use a numeric control with the increment and decrement. Each click of the Increment(or Decrement) will trigger an event value change. So if your numeric Control is set to 1 and you want to get to 4 you click the increment button 3 times. This will trigger 3 value change events for the control. Although I believe I see what he's trying to do, I'm not sure I have a good answer to solve this problem. Maybe someone else will have a recomendation for this scenario. Dave Graybeal

[Napolean Dynamite Voice] LabVIEW 8.20 is like the best version ever! [/Napolean Dynamite Voice] But really, 8.20 is a ton of fun to work with and really stable compared to 8.0. The startup time alone will save you days in your first month of use. Dave Graybeal -Proud 8.20 User-

From what I remember, I believe that legally you can install a single labview liscense on up to 3 machines. I believe these 3 machines are intended to be development machine, laptop and a computer at home. I also believe that the intended function of them is that they are used exclusively of each other. Now that being said, I doubt any sales rep is going to mind anything relatively close as long as its not being used to allow other developers in your business to develop from a single liscense. Just my 2 cents, but if it's going to be installed on a home pc to increase your labview coding skills then I don't think anyone's gonna be filing a lawsuit against ya Dave