Create, save, and execute non-SELECT DML statements (INSERT, UPDATE etc.)

Avatar
  • updated
  • Under review

Hello,

Can FlySpeed query be used to build, save and execute Append, Update, Delete queries?  I primarily work with Access databases and I want to use FlySpeed to create and organize all of my queries, but when I try and create DML statements it gives error "non-SELECT statement..."

Other than that, the software is great and am buying the lifetime standalone version.

Thanks

Avatar
Anonymous

Hello,

Thank you for your feedback!

Unfortunately, the visual building of DML statements is postponed, but you can type them manually on the SQL Text tab. Hopefully, we can add this feature next year.