Update Value to MS Access Database iLogic

[ngnam1988]

Dears,

I'm working with MS Access Database. I really found some good post about this. At the moment I can CREATE NEW; GET data from database. But I didn't found the query that can UPDATE the existed record. I tried many times with SQL UPDATE Statement but not success. Inventor return an error

My query:

UPDATE 000Code SET (DESCRIPTION = 'BRACE', REVISION = '00', WEIGHT = '21', Remarks = '') WHERE (CODE = '000-000-081-104');

Please help me. Thanks you very much!
Ref. Topics:
https://forums.autodesk.com/t5/inventor-ilogic-and-vb-net-forum/how-to-get-ilogic-to-record-data-sea...

https://forums.autodesk.com/t5/inventor-ilogic-and-vb-net-forum/connect-to-sql-or-microsoft-access-f...

[JelteDeJong · Accepted solution]

I'm not a sql specialist but I remember that the "Microsoft Access Sql" syntax is different from all other sql syntax. It uses (sometimes) right brackets. something like this:

UPDATE 000Code 
SET [DESCRIPTION] = 'BRACE',  [REVISION ] = '00', [WEIGHT] = '21', [Remarks] = ''
WHERE [CODE ] = '000-000-081-104'

[ngnam1988]

Thanks @JelteDeJong

I tried and it's worked perfectly! Thanks you very much!

[carolien.depauw]

Hi,

I have a problem to complete this update function. Is it possible to put a little more of your rule, so I can see how it works.

Kind regards,

Carolien