LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

error when writing to "long sting" field in database

Solved!
Go to solution

 

Dear community,

I am using LabVIEW Database and Connectivity Toolkit to write a large string into an access field of the type long string. See attached vi. Once I write more than 256B I get the error "invalid precision value". Is this related to using the DCT? Will I need to find a solution using Database connections via ActiveX?

Thanks for any ideas.

0 Kudos
Message 1 of 2
(153 Views)
Solution
Accepted by topic author labviewette

I can't open the code right now, but are you using DCTs Insert or are have you built a string and use "Execute query"? In many cases i prefer the latter as i have better control over it. I know there's often problems with too long SQL commands, but that's usually around 8kb. 256B shouldn't be any problem (unless you mean 256kb).

/Y

G# - Award winning reference based OOP for LV, for free! ADDQ VIPM Now on GitHub
"Only dead fish swim downstream" - "My life for Kudos!" - "Dumb people repeat old mistakes - smart ones create new ones."
Certified-LabVIEW-Developer
0 Kudos
Message 2 of 2
(142 Views)