Community
Inventor Programming - iLogic, Macros, AddIns & Apprentice
Inventor iLogic, Macros, AddIns & Apprentice Forum. Share your knowledge, ask questions, and explore popular Inventor topics related to programming, creating add-ins, macros, working with the API or creating iLogic tools.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Update Value to MS Access Database iLogic

3 REPLIES 3
SOLVED
Reply
Message 1 of 4
ngnam1988
369 Views, 3 Replies

Update Value to MS Access Database iLogic

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

3 REPLIES 3
Message 2 of 4
JelteDeJong
in reply to: ngnam1988

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

Message 3 of 4
ngnam1988
in reply to: ngnam1988

Thanks @JelteDeJong

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

Message 4 of 4
carolien.depauw
in reply to: ngnam1988

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

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report