From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
05-03-2016 11:50 AM
No i didn't change anything in the column string array. The code is writing values to the dB everytime I run the VI. I was indeed suggesting to remove the Insert Data VI to see if it caused any issues.
One thing you might try that I have done is modify the Create Parameterized Query VI to look like the pic below (I know....not recommended) but there seems to be a bug in 2012. Not sure about newer versions. Reference the following post.
05-03-2016 12:32 PM
OK, that actually helped to fix my error. Now I am at the same point as you. It works if I remove the column with the function from the database otherwise I get the error about "it's an undefined function".
So now the start question remains - how to get the WorkingDays out from the LabView VI? I have not achieved anything here from that standpoint.
05-03-2016 01:10 PM
Have you tried updating VB runtime?
05-03-2016 01:12 PM
Yes, I have VB 6.0 Runtime
05-03-2016 02:53 PM
According to this link (not everything on the internet is true), custom functions are blocked from being called from an ODBC or OLE driver. Looks like you are out of luck there. You can do the date calculations in labview after the query has returned the data. Or you can switch to SQL server, for which there is an express version that is free.
05-04-2016 09:43 AM - edited 05-04-2016 09:44 AM
Thank you for that link, it means that I don't need to dig into this any further. I will just pull the two dates from the database and then replace the Access function with a LabView VI instead that will calculate the working days.
Thanks "Aputman" for your help
05-05-2016 09:55 AM
Why do you mark your "thank you" comments as the solution? The purpose of marking a solution is so that people can immediately go straight to the post that solved the OP's question. Going to a "thank you" doesn't help anyone.