database access problem

[yangyang-rexxar]

Hi,

    I have a problem with access operation.The error is syntax error.First I transfer some different parameters to string then I contact them.

The result expression(red point in diagram) to DB tools Execute query.vi's sql query port is

UPDATE AnalogInputVoltage SET Max=8.00,Min=7.00,Units=0,Terminal=0 where Channel='Dev1/ai5';

And ,I have checked access,There is no prob.

The syntax error always show.

[Dynamik]

---

@paulbin wrote:

Hi,

    I have a problem with access operation.The error is syntax error.First I transfer some different parameters to string then I contact them.

The result expression(red point in diagram) to DB tools Execute query.vi's sql query port is

UPDATE AnalogInputVoltage SET Max=8.00,Min=7.00,Units=0,Terminal=0 where Channel='Dev1/ai5';

And ,I have checked access,There is no prob.

The syntax error always show.

---

Parenthesis maybe?

UPDATE AnalogInputVoltage SET (Max=8.00,Min=7.00,Units=0,Terminal=0) where Channel='Dev1/ai5'

?

[Mike]

I haven't used SQL expressions in Labview, but in many other database
implementations Max and Min are reserved words...

HTH,
Mike