Error when using UPDATE SQL command

[iRobotTester]

Using DB Connectivity Toolkit, I am trying to execute the following SQL command:

UPDATE ItemTable SET KGU? = 'True' WHERE ProductID = 'S1'

I get this error:  "Conn Execute.vi<ERR>Incorrect function. in Conn Execute.vi"

Attached is a JPEG of the code.

Any help would be greatly appreciated.

Thanks,

Scott

[DavidJCrawford]

Try putting enclosing your column name KGU? in square brackets like

UPDATE ItemTable SET [KGU?] = 'True' WHERE ProductID = 'S1'

and see if that helps you.

David

[DavidJCrawford]

Try putting enclosing your column name KGU? in square brackets like

UPDATE ItemTable SET [KGU?] = 'True' WHERE ProductID = 'S1'

and see if that helps you.

David

[iRobotTester]

David,

Thanks for replying.  I tried the brackets around KGU?, it did not resolve the failure.  Any other ideas?

Thanks,

Scott

[DavidJCrawford]

Just had another look and you are missing a semi-colon to terminate the command

UPDATE ItemTable SET KGU? = 'True' WHERE ProductID = 'S1';

I would keep [KGU?] in just in case the SQL interpreter thinks the ? is an operator instead of being part of a field name.

[iRobotTester]

I tried the semicolon too ... same error message.

Scott

[DavidJCrawford]

Scott

Have you tried to run your UPDATE query in MS Access like this?

Open your database and create a new query in MS Access then change to SQL view and paste your query there. Then execute it and look at the errors, if any.

I always build design my queries in MS Access query builder then transfer the SQL to Labview where I then use format into string or the build text express vi to create variable queries.

Could you post your vi?

David

Message Edited by David Crawford on 04-27-2006 02:56 PM

[iRobotTester]

David,

It works now!!

I changed the KGU? field name to KGU and it worked!  I guess the ? was a problem. 

Thanks for your help.

Scott

[DavidJCrawford]

Brilliant, well done.

So was the field name in the database just "KGU" and not "KGU?" then?

David

[iRobotTester]

No the field in the database was really KGU?.  Adding the brackets [KGU?] appears not to "fix" the fact that there is a ? in the field name.

Scott