calling module (Function) in database toolkit

[aputman]

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.  

http://forums.ni.com/t5/LabVIEW/2013-Database-Toolkit-Create-Parameterized-Query-Postgres-Bug/m-p/24...

[hasse]

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.

[aputman]

Have you tried updating VB runtime?

[hasse]

Yes, I have VB 6.0 Runtime

[aputman · Accepted solution]

http://stackoverflow.com/questions/12538094/sql-statement-against-access-2010-db-not-working-with-od...

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.  

[hasse]

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

[aputman]

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.