Book a Demo

Author Topic: How can I use update statement in EA  (Read 2608 times)

Michael

  • EA Novice
  • *
  • Posts: 13
  • Karma: +0/-0
    • View Profile
How can I use update statement in EA
« on: October 11, 2014, 11:01:05 am »
I am using normal Builder , but there is no action no update occurs on the intent table see the image please.

Anyway how could I modify the tables using SQL DML.
I do not like to use ODBC or any third party software, it would be complicated to config with every project.

Thank you

« Last Edit: October 11, 2014, 11:13:30 am by MichaelRahn »

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: How can I use update statement in EA
« Reply #1 on: October 11, 2014, 05:17:47 pm »
The builder accepts only SELECT statements. Use a standard client or something like TOAD to manipulate the DB. Or use a script with Repository.Exectue("UPDATE...")

q.