Showing results for 
Search instead for 
Did you mean: 

error when writing to "long sting" field in database

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
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).


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."
0 Kudos
Message 2 of 2