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...
Solved! Go to Solution.
Solved by JelteDeJong. Go to 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.
Blog: hjalte.nl - github.com
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.