Member Avatar for JosipMiller

Hello,

I connected my Delphi application with MS Access database and I am stuck a bit with a problem: how to execute UPDATE Query stored in MS Access database from Delphi ?

Stored query in Access works properly. All other queries (mostly SELECT) stored in Access I have connected properly from Delphi.

Any ideas how to do this ?

Thank you,

Josip

  • 2 Contributors
  • 4 Replies
  • 236 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by JosipMiller
Member Avatar for LizR

An update query should work the same - whats the problem ?

Member Avatar for JosipMiller

An update query should work the same - whats the problem ?

Query itself is not the problem. As I mentioned, it works. Problem is that I don't know how to execute UPDATE query from Delphi. Query is stored in MS Access database, not in Delphi application.

Thanks,

Josip

Member Avatar for LizR

As I said, exactly the same way you do your select queries.

Member Avatar for JosipMiller

As I said, exactly the same way you do your select queries.

I solved it ! Thank you for helping me with this.

Josip

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.