system exec.vi mysql

[astroboy]

Hi

Any idea how I can use system exec.vi to run mySQL syntax becos I wanted to get raw values as using ADO alter the values. For example, I read in mySQL that showed me null and 0.0 values. After ADO, it reads out 0.00 and 0 instead and I am feeling frustrated. Why can't the values be same through ADO as in mySQL. That's why I am thinking of using system exec.vi to do mysql syntax to get correct values.

Please advise how i can do that.

Thanks in advance.

I am using Labview 7.1, LABSQL(ADO) and ADO Toolkit

Clement

[KateB]

This is ADO problem.

I think that would be difficult to solve it with system exec.

Instead of doing so, I'd recommend you to use replace string function to replace 0.00 with null.

That's a lot easier.

[astroboy]

Hi Kate.

Thanks for your help. It turns out it's the datatype " decimal"  in mysql.

Using decimal datatype, null and 0.00 value will produce 0 which is not desired.

So I changed it to float datatype and null and 0.00 value produce null and 0 value that I am able to make differentiate.

However, what 's the difference decimal and float datatypes?

I have read and it has to do with evaluation within mysql environment but my application does not require. So it runs smoothly. and it works perfectly.

regatrds

Clement