Update Value to MS Access Database iLogic

ngnam1988
Advocate
Advocate

Update Value to MS Access Database iLogic

ngnam1988
Advocate
Advocate

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');

 

ngnam1988_0-1660564405262.png

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

0 Likes
Reply
Accepted solutions (1)
401 Views
3 Replies
Replies (3)

JelteDeJong
Mentor
Mentor
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'

 

Jelte de Jong
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.

EESignature


Blog: hjalte.nl - github.com

ngnam1988
Advocate
Advocate

Thanks @JelteDeJong

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

0 Likes

carolien.depauw
Explorer
Explorer

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

0 Likes